To Create a New Replica Using Centralized Replication Computer
-
Start the Mobile Server on Mobile Server Machine
- To start the Mobile Server in standalone mode, run the following shortcut: Start > All Programs > Oracle Database Lite 10g > Mobile Server.
- Exit the Mobile Manager by closing the window.
If the Job Scheduler is not running, select the button next to it and click the Start button. The Status column in the Components section at the bottom of the page.
-
Start the Job Scheduler on Mobile Server Machine.
-
Start a browser with the URL http://<Mobile Server>/webtogo. Note that the Mobile Server host name that you provide is not the back-end database, but is the host where the Mobile Server and the middle-tier application server were installed. For Example: http://Machine2/webtogo.
Also, the URL assumes that you are using the default port of 80. If there was a port conflict and you had to change the port number, use the URL http://<Mobile Server>:<port_number>/webtogo.
- Logon as the administrator. The default administrator username/password is administrator/admin unless you have mentioned a different password during the Mobile Server Installation.
- On the Mobile Workspace screen, click Mobile Manager. This brings up the list of Mobile Servers available.
- Click on the Mobile Server with which you wish to connect. These are listed by host name and port number.
- On the Mobile Server screen, verify that the Job Scheduler is running. This is indicated by a green checkmark under.
-
Start a browser with the URL http://<Mobile Server>/webtogo. Note that the Mobile Server host name that you provide is not the back-end database, but is the host where the Mobile Server and the middle-tier application server were installed. For Example: http://Machine2/webtogo.
-
Create the Replication Publication.
Note: Step 3 is required only for the first time when publications are created. For subsequent users you can skip step 3 and go to step 4.
- At the command prompt, run the CREATEPUBLICATION.BAT utility, from ..\Program Files\Bentley\UtilitiesDesigner\, with the following parameters. Use parameters in the order specified and use a space to separate each value.
-
Cmd:\> CreatePublication <Server Name> <Master DB Instance> <Master User> <Master Password> <Repository DB Instance> <Repository User> <Repository Password> <Unique Name>
Where:
- <Server Name> = Host name of the Master Oracle Server database.
- <Master DB Instance> = Oracle SID of the Master database.
- <Master User> = Username for connecting to Master database.
- <Master Password> = Password for the Master User.
- <Repository DB Instance> = Oracle SID of the Repository database (Usually the same as Master database).
- <Repository User> = Username for Repository user (Usually MOBILEADMIN).
- <Repository Password> = Password for the Repository User.
- <Unique Name> = A name for the Workflow Manager Replication Publication.
- At the command prompt, run the SUBSCRIBEUSER.BAT utility, from ..\Program Files\Bentley\UtilitiesDesigner\, with the following parameters. Use parameters in the order specified and use a space to separate each value.
-
Subscribe the users to the Replication Publication.
- Create WorkflowManager User in Mobile Server using control center.
-
Cmd:\> SubscribeUser <Server Name> <Master DB Instance> <Master User> <Master Password> <Repository DB Instance> <Repository User> <Repository Password> <Unique Name> <Workflow Manager Username>
Where:
- <Server Name> = Host name of the Master Oracle Server database.
- <Master DB Instance> = Oracle SID of the Master database.
- <Master User> = Username for connecting to Master database.
- <Master Password> = Password for the Master User.
- <Repository DB Instance> = Oracle SID of the Repository database (Usually the same as Master database).
- <Repository User> = Username for Repository user (Usually MOBILEADMIN).
- <Repository Password> = Password for the Repository User.
- <Unique Name> = A name for the Workflow Manager Replication Publication.
- <Workflow Manager Username> = Workflow Manager User name of the user who is going to the use the replication database.
- Create Oracle Client ODBC DSN
-
Create Laptop Replication Files.
- Edit the POLITE.INI located in C:\Windows directory like this: [All Databases] MaxSharedMemSize=256 [SYNC] AUTO_COMMIT_COUNT=50.
- At the command prompt, run the REPLICA.BAT utility, from ..\Program Files\Bentley\UtilitiesDesigner\, with the following parameters. Use parameters in the order specified and use a space to separate each value.
-
Cmd:\> Replica <OracleLite_Home> < Username> < Username password in Mobile Server> <Mobile Server name> <proxy server> <proxy port>
Where:
- <OracleLite_Home> = Directory where you have the Oracle 10g Lite installed.
- < Username> = Workflow Manager User name of the user who is going to the use the replication database.
- < Username password in Mobile Server> = Password for the above user on the Mobile Server.
- <Mobile Server name> = Mobile Server machine name.
- <proxy server> = [Optional] Proxy Server name
- <proxy port> = [Optional] Proxy Port number
The REPLICA batch file performs several steps including the creation of the snapshot where each table in the Master database is replicated, loading of CU data from respective text files into the replication database, and creation of the sequence, indexes and views. After each step, the program will pause to give the System Administrator the opportunity to review any errors that may have occurred, the user can press <Enter> to continue execution or <Ctrl + C> to exit the batch program.
One of the steps in the program is to display an interactive Windows program providing the capability to generate a sequence number. After the sequence numbers are generated, the sequences will be automatically created in the replica database.
-
In the Sequence Generator Window:
- Select the User's name used as a parameter to run REPLICA.BAT.
- Select the "New Install" check box (Default is selected).
- Select Next.
- Select Finish to generate the sequence.
- Manually create the CHDATALITE DSN. (Refer to instructions in Create ODBC DSNs - Oracle Lite Installed)
- Exit the Application when it has finished generating the sequence.