Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » MobiLink - Getting Started » MobiLink tutorials » Tutorial: Using MobiLink with an Oracle Database 10g

 

Lesson 8: Starting the server and client

In a previous lesson, you modified the download cursor script to download information related to one salesperson. In this lesson, you specify the salesperson by setting the remote ID to the salesperson identifier, and start the MobiLink consolidated and remote database.

Prerequisites

This lesson assumes you have completed all preceding lessons. See Lesson 1: Designing the schemas.

This lesson assumes you have the roles and privileges listed in the Permissions and privileges section at the start of this tutorial: Tutorial: Using MobiLink with an Oracle Database 10g.

Context and remarks

By default, MobiLink uses the snapshot/READ COMMITTED isolation level for upload and download. For the MobiLink server to make the most effective use of snapshot isolation, the Oracle account used by the MobiLink server must have access to the GV_$TRANSACTION Oracle system view. If access is not given, a warning is issued and rows may be missed on download.

 Task
  1. Connect as the SYS user with SYSDBA privileges using the Oracle SQL Plus application. At a command prompt, run the following command:

    sqlplus SYS/your password for sys as SYSDBA
  2. To grant access to the GV_$TRANSACTION Oracle system view, execute the following statement:

    GRANT SELECT ON SYS.GV_$TRANSACTION TO OE;
  3. To grant access to the V$SESSION and GV_$SESSION Oracle system views, execute the following statement:

    GRANT SELECT ON SYS.V_$SESSION TO OE;
          GRANT SELECT ON SYS.GV_$SESSION TO OE;
  4. To grant access to other system objects, execute the following statement:

    GRANT SELECT ON SYS.GV_$LOCK TO OE;
    GRANT EXECUTE ON SYS.DBMS_UTILITY TO OE;
    GRANT SELECT ON DBA_OBJECTS TO OE;
  5. At a command prompt, navigate to the directory where you created the synchronization model. (This is the root directory you chose in the first step of the Create Synchronization Model Wizard.)

    If you used the suggested directory names, navigate to the following directory: mlorc\oracle_project\sync_oracle_deploy\.

  6. To start the MobiLink server, run the following command:

    mlsrv.bat "DSN=oracle_cons;UID=OE;PWD=sql"
    • mlsrv.bat   is the command file created to start the MobiLink server.

    • DSN   is the ODBC data source name.

    • UID   is the user name you use to connect to the consolidated database.

    • PWD   is the password you use to connect to the consolidated database.

    When this command runs successfully, the message MobiLink server Started appears in the MobiLink server messages window.

    If the MobiLink server fails to start, check the connection information for the consolidated database.

  7. At a command prompt, navigate to the directory where the Deploy Synchronization Model Wizard created your remote database.

    If you used the suggested directory names, navigate to the following directory: mlora\oracle_project\sync_oracle_deploy\.

  8. Start your remote SQL Anywhere database by running the following command:

    dbsrv16 -n remote_eng sync_oracle_remote.db -n remote_db
    • dbsrv16   is the database server used to start the SQL Anywhere database.

    • remote_eng   is the database server name.

    • sync_oracle_remote.db   is the database file that is started on remote_eng.

    • remote_db   is the name of the database on remote_eng.

Results

When this command runs successfully, a SQL Anywhere database server named remote_eng starts and loads the database called remote_db.

 See also