Introduction to Oracle tutorial

This tutorial shows you to mobilize an Oracle 10g database using MobiLink. It sets up synchronization between an Oracle 10g consolidated database and a SQL Anywhere remote database. You could also set up an UltraLite remote database.

The purpose of this tutorial is to mobilize the data pertaining to a sales team. In this scenario, each salesperson is a remote synchronization client. Each salesperson has a local SQL Anywhere database that is synchronized to a corporate Oracle database at headquarters using MobiLink. Each salesperson access corporate data with their laptop or handheld device, and manipulates data from the remote database.

Required software

This tutorial assumes that you have a complete install of SQL Anywhere (including MobiLink) on your local computer where you are running the tutorial. This tutorial was created using Oracle Database 10g Release 2. The tutorial may work for other versions of Oracle, but this is not guaranteed. This tutorial also assumes that you have installed Oracle Database 10g on your local computer, but you may also access it remotely.

This tutorial assumes you performed a basic installation of Oracle Database 10g, which creates a starter database named orcl. The orcl database has the Order Entry (OE) and Human Relations (HR) sample schemas. Alternatively, you may manually install the sample schemas or use the Oracle Database Configuration Assistant. For more information about installing both sample schemas, see [external link] http://www.oracle.com/technology/obe/obe1013jdev/common/OBEConnection.htm.

This tutorial assumes that you can connect to Oracle as the SYS user with SYSDBA privileges. This is a requirement in Lesson 7 when you grant permission for the V_$TRANSACTION Oracle system view. The password for the SYS user is set during installation of an Oracle database.

Overview

This tutorial shows you how to:

Make important considerations, such as synchronization directions for remote tables, when designing a remote schema.
Add unique primary keys to consolidated and remote databases.
Create an ODBC data source that connects MobiLink to an Oracle 10g database.
Set up synchronization between a consolidated database and remote database using the Create Synchronization Model Wizard.
Customize a synchronization model using Model mode.
Deploy a consolidated database and remote database using the Deploy Synchronization Model Wizard.
Synchronize the remote client with the consolidated database.