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.
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.
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
To grant access to the GV_$TRANSACTION Oracle system view, execute the following statement:
GRANT SELECT ON SYS.GV_$TRANSACTION TO OE;
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;
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;
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\.
To start the MobiLink server, run the following command:
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.
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\.
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.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|