This tutorial shows you to mobilize an Oracle Database 10g using MobiLink. It sets up synchronization between an Oracle Database 10g 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 accesses corporate data with their laptop or mobile device, and manipulates data from the remote database.

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 can create a new database using the Oracle Database Configuration Assistant and install the sample schemas or manually install the sample schemas into a blank database via SQL*Plus. The sample schema SQL files are available through separate Example download packages directly from Oracle. For more information about installing both sample schemas, see  http://www.oracle.com/technetwork/testcontent/connection11g-088156.html.

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

 Required software

 Overview

 Permissions and privileges

 See also