This lesson assumes you have completed all preceding lessons. See Lesson 1: Designing the schemas.
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.
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 Oracle system view, execute the following statement:
GRANT SELECT ON SYS.V_$SESSION 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, you should have the following directories located in the root directory: sync_oracle\mlsrv.
Run the following command from the mlsrv directory:
sync_oracle_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, you should have the following directories located in the root directory: sync_oracle\remote.
Start your remote SQL Anywhere database by running the following command:
dbeng12 -n remote_eng sync_oracle_remote.db -n remote_db
dbeng12 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.
When this command runs successfully, a SQL Anywhere database server named remote_eng starts and loads the database called remote_db.
Proceed to Lesson 9: Setting the remote ID.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|