Contents

Title and Copyright Information

Send Us Your Comments

Preface

Intended Audience

Documentation Accessibility

1 Using the Workspace for Managing the Mobile Server

1.1 Using the Mobile Workspace

1.2 Using Mobile Manager to Manage Your Mobile Server

1.2.1 Viewing Mobile Servers

1.2.1.1 Mobile Manager Home Page

1.2.1.2 Manage Applications

1.2.1.3 Manage Users

1.2.1.4 Mobile Server Administration

1.2.2 Viewing Mobile Devices

1.2.2.1 Installed Mobile Devices

1.2.2.2 Mobile Device Platforms

2 Installing Mobile Clients

2.1 Preparing the Device for a Mobile Application

2.2 Installing the Mobile Client Software

2.2.1 Configuring for Default Sync When Installing the Client

2.3 Configuring the Client for Secure Socket Layer (SSL)

2.4 Using Offline Instantiation to Distribute Multiple Mobile Clients

3 Managing Your Mobile Client

3.1 Using the Mobile Client Workspace to Manage Your Web Clients

3.1.1 Instructions for Using the Mobile Workspace

3.1.1.1 Applications Tab

3.1.1.2 Configuration Tab

3.1.1.3 Help Tab

3.1.1.4 Sync Tab

3.1.1.5 Log Off Tab

3.1.2 Log on to Mobile Client Workspace

3.1.3 Customizing the Mobile Client Workspace

3.1.4 Executing Mobile Applications Installed on Your Mobile Client

3.1.5 Scheduling Data Synchronization Jobs

3.2 Using the msync GUI to Initiate Synchronization of Your Linux, PocketPC, and Win32 Client/Server Application Clients

3.3 Using the Device Management Client GUI to Manage the Client-Side Device

3.4 Initiating Updates of Oracle Database Lite Software from the Client

4 Managing Your Mobile Applications

4.1 Listing Applications

4.2 Publishing Applications to the Mobile Server Repository

4.3 Manage Application Properties or Users

4.4 Managing User-Specific Application Parameters (Data Subsetting)

4.5 Managing Access Privileges for Users and Groups

4.5.1 Grant Application Access to Users and Groups

4.5.2 Revoke Application Access to Users and Groups

4.6 Selecting Application Files for Public Use

4.7 Adding Web Application Archive (WAR) Files

4.8 Modifying Registry Entries

5 Managing Users and Groups

5.1 Managing Users and Groups

5.1.1 What Are Mobile Server Users?

5.1.1.1 Mobile Server User Privilege: Administrator

5.1.1.2 Mobile Server User Privilege: User

5.1.1.3 Associating Mobile Server Users With Published Applications

5.1.2 Displaying Users

5.1.3 Adding New Users

5.1.4 Adding New Groups

5.1.5 Managing OID Users in the Mobile Server

5.2 Managing Access Privileges for Users and Groups

5.2.1 Grant or Revoke Application Access to Users

5.2.2 Include or Exclude Users from Group Based Access

5.2.3 Grant or Revoke Application Access to Groups

5.3 Managing Application Parameter Input (Data Subsetting)

5.4 Assigning Application Roles to Users

5.5 Creating an Administrator

5.6 Manually Adding Devices for a User

5.7 Set Update Policy for Software Updates for the User

6 Managing Synchronization

6.1 How Does the Synchronization Process Work?

6.2 Managing the Sync Server

6.2.1 Starting/Stopping the Sync Server

6.2.2 Checking Synchronization Alerts

6.2.3 Managing Sync Sessions

6.2.4 Displaying Operating System (OS) and Java Virtual Machine (JVM) Information

6.3 Configuring Data Synchronization

6.4 How Do You Encrypt All Databases for the Initial Sync?

6.4.1 Configuring on the Local Client for Automatic Encryption of Local Snapshots

6.4.2 Configuring on the Server for Automatic Encryption of Local Snapshots

6.5 Managing Trace Settings and Trace Files

6.6 Browsing the Repository for Synchronization Details

6.6.1 Viewing User Information

6.6.2 Viewing Publications

6.6.3 Viewing Publication Items

6.6.4 Viewing Synchronization Queues

6.6.4.1 Viewing Transactions in the In-Queue

6.6.4.2 Viewing Subscriptions in the Out-Queue

6.6.4.3 Viewing Transactions in the Error Queue

6.7 Monitoring and Analyzing Performance

6.7.1 Viewing Sync Server Statistics

6.7.2 Viewing MGP Cycles and Statistics

6.7.3 Analyzing Performance of Publications With the Consperf Utility

6.7.3.1 Deciphering the Performance Evaluation Files

6.7.4 Monitoring Synchronization Using SQL Scripts

6.7.4.1 Synchronization Times for All Clients

6.7.4.2 Failed Transactions for all Clients

6.7.4.3 Completely Refreshed Publication Items for all Clients

6.7.4.4 Publications Flagged for Complete Refresh for All Clients

6.7.4.5 Clients and Publication where Subscription Parameters are Not Set

6.7.4.6 Record Counts for Map-based Publication Item by Client

6.7.4.7 Record Count for Map-based Publication Items by Store

6.7.4.8 All Client Sequence Partitions and Sequence Values

6.7.4.9 All Publication Item Indexes

6.7.5 Synchronization Performance Affected by WebCache

7 Job Scheduler

7.1 Scheduling a Job to Execute at a Specific Time or Interval

7.2 Managing the Job Engine

7.2.1 Starting the Job Scheduler

7.2.2 Checking Job Scheduler Alerts

7.2.3 Managing Active Jobs

7.2.4 Managing the Job History List

7.3 Manage Scheduled Jobs Using the Mobile Manager

7.3.1 Creating a New Job

7.3.2 Editing Existing Jobs

7.3.3 Enabling or Disabling Jobs

7.3.4 Deleting Jobs

7.3.5 Default Jobs

7.3.5.1 MGP_DEFAULT

7.3.5.2 PURGE_HISTORY_DEFAULT

7.4 Managing Scheduled Jobs Using ConsolidatorManager APIs

7.5 Using the ConsolidatorManager APIs to Create Jobs

8 Manage Your Devices

8.1 Installing the Mobile Client Software on Your Mobile Device

8.2 Modifying Environment on Your Mobile Clients During Installation

8.3 Viewing Device Information

8.3.1 Viewing Device Information

8.3.2 Viewing Database Information

8.3.3 Viewing Software Information

8.3.6 Command History

8.3.7 Viewing Device Logs

8.4 Configuring and Customizing Your Mobile Device Platform

8.4.1 Modifying Platform Properties for Installation

8.4.2 Enabling or Disabling All Mobile Devices in a Platform

8.4.3 Allowing Software Upgrades to All Mobile Devices in a Platform

8.4.4 Extend or Create a Custom Platform

8.4.4.1 Enable a Platform for Your Mobile Client

8.4.4.2 Create a Custom Platform By Extending an Existing Platform

8.5 Configuring Your Mobile Devices

8.5.1 Enabling or Disabling a Mobile Device

8.5.2 Allowing Software Upgrades to the Mobile Device

8.6 Sending Commands to Your Mobile Devices

8.6.1 Scheduling or Sending Commands

8.6.1.1 Sending Commands

8.6.1.2 Scheduling Commands

8.6.2 Modifying Existing Commands

8.6.2.1 Adding Parameters to Mobile Device Commands

8.6.3 Creating New Commands

8.6.4 Creating Group Commands

8.6.5 Enabling or Disabling Mobile Device Commands

8.6.6 Viewing the Mobile Device Command History

8.6.7 Examples of Mobile Commands

8.7 Enabling Device Software Updates

8.7.1 Enabling Major Software Updates for Your Device

8.7.2 Applying Patches or Minor Updates

8.7.3 Controlling Device Software Updates

8.7.3.1 Enabling Software Updates for the Oracle Lite Platform

8.7.3.2 Updating Application Software On Each Client

8.8 Using the Device Management Client GUI to Manage Device on Client-side

8.9 Managing the Network Protocol Between the Device and the Mobile Client Software

8.10 Installation Configuration (INF) File

8.10.1 Setup Information

8.10.2 Properties

8.10.3 Initialization

8.10.4 Including Other INF Files

8.10.5 INSTALL Element

8.11 Defining Device Manager Commands With the Device Manager OTL Tag Language

8.11.1 Device Manager Tag Language Data Types

8.11.1.1 Character

8.11.1.2 Number

8.11.1.3 Integer

8.11.1.5 Double

8.11.1.6 Boolean

8.11.1.7 String

8.11.1.9 Date Methods

8.11.1.10 Time Methods

8.11.1.11 Enumeration

8.11.2 Operators That You Can Use With the Device Manager Tag Language

8.11.3 Syntax for the Device Manager Tag Language

8.11.3.1 Initialization Statements

8.11.3.2 Assignment Statements

8.11.4 Conditional Statements

8.11.4.1 If-Else Conditional Statement

8.11.4.2 While Conditional Statement

8.11.4.3 Foreach Conditional Statement

8.11.4.4 Break Statement

8.11.4.5 Choose Statement

8.11.5 Define Custom Functions

8.11.6 Manage the Database Connection

8.11.6.1 Specify Database Connection Information for an Application

8.11.6.2 Disconnect from the Database

8.11.7 Global Classes

8.11.7.1 Methods of the System Class

8.11.7.2 Methods of the DeviceManager Class

8.11.8 Importing Another OTL Page

8.11.9 Installing an Application From a Server

8.11.10 Specifying a Schema File

8.11.11 Error Handling

8.11.12 Sample Device Manager Commands Using the Tag Language

9 Offline Instantiation

9.1 Using Offline Instantiation to Distribute Multiple Mobile clients

9.2 Setting Up the Mobile Server Host and Mobile Development Kit Host

9.3 Downloading the Client Binaries Into the Client Root Directory

9.4 The OLI Package Directory

9.5 Configure How OLI Creates the Client Distribution Packages With the OLI Configuration File

9.5.3 Example of OLI.INI File

9.6 Using the OLI Engine to Create and Package the Client Distribution File

9.6.1 Create and Populate Client Database Files with the MAKEODB Command

9.6.2 Package the Mobile Client Binaries with the Client Database Files with the package Command

9.6.3 Clean Up the OLI Tables Before Executing OLI for Another Distribution

9.6.4 Check the Status of OLI Clients

9.7 Deploying Client Distribution Files on Client Machines

9.7.1 Deploy Win32 Native or Web-to-Go Client Distribution Package

9.7.2 Deploy WinCE PocketPC Client Distribution Package

9.8 Creating a Single Package for Users That Share Data

10 Manage Your Branch Office

10.1 Introduction

10.1.1 What is the Branch Office?

10.1.2 How the Branch Office Works

10.1.3 The Branch Office Manager

10.1.4 Synchronizing Data with Headquarters

10.2 Branch Office Installation and Configuration

10.2.1 Terms and Concepts

10.2.2 Overview

10.2.3 Branch Office Installation

10.2.4 Enabling Branch Office on Windows XP Service Pack 2

10.2.5 Changing Branch Office Listener Port Number

10.3 Architecture

10.3.1 The Branch Office Environment

10.3.1.1 The Branch Office Client

10.3.1.2 The Branch Office

10.3.1.3 Company Headquarters

10.3.2 Connecting Clients to the Branch Office Database Machine

10.3.2.1 ODBC Connection

10.3.2.2 JDBC Connections

10.4 Administration

10.4.1 Logging into the Branch Office Manager

10.4.2 Using the Branch Office Manager

10.4.2.1 Updating Status Summary

10.4.2.2 Starting the Database Service

10.4.2.3 Stopping the Database Service

10.4.2.4 Viewing the Status of the Branch Office Database

10.4.3 Managing Branch Office Users

10.4.3.1 Creating Users

10.4.3.2 Setting User Roles

10.4.3.3 Setting User Properties

10.4.3.4 Setting User Privileges

10.4.3.5 Finding Users

10.4.3.6 Removing a User

10.4.4 Managing Applications

10.4.4.1 Downloading Public Files to Your Client

11 Using the Application Server OID With Mobile Server

12 Manage Security in Oracle Database Lite

12.1 Configuring SSL For Mobile Server

12.1.1 Creating an SSL Certificate

12.1.2 Configuring Mobile Server for SSL

12.1.2.1 Configuring SSL for Mobile Server With Oracle9iAS or OracleAS

12.1.2.2 Configuring SSL for Standalone Mobile Server

12.1.3 Troubleshooting Error Messages for an SSL-Enabled Mobile Server

12.1.4 Client-Side Configuration for Secure Socket Layer (SSL)

12.1.4.1 Communication between the Mobile Client and the Mobile Server

12.1.4.2 Connection between the Browser and the Mobile Client for Web-to-Go

12.1.4.3 Support for Non-SSL Mobile Clients

12.2 Encrypting the Client Oracle Lite Database

12.3 Security Warning for Demo Applications

13 Performance

13.1 Using Connection Pooling for Applications

13.2 Limit Application Connection Requests to the Database

13.3 Determine Correct Synchronization Templates to Use for Subscriptions

13.4 Synchronization Tablespace Layout

13.5 Synchronization Performance Affected by WebCache

14 Configure for National Language Support (NLS)

14.1 Configuring OC4J to Handle Multibyte Characters in Online Web Applications

15 Backup and Recovery

15.1 How Does Oracle Database Lite Store its Information?

15.2 Backing Up Oracle Database Lite

15.3 Oracle Database Lite Backup Coordination Between Client and Server

15.4 Oracle Database Lite Recovery Issues

16 Tracing and Logging

16.1 Enable Tracing on the Mobile Server

16.1.1 General Tracing for the Mobile Server

16.1.2 Data Synchronization Tracing

16.1.2.1 Description of the Five Data Synchronization Components

16.2 Enable Tracing on Mobile Clients

16.2.1 Turn on Tracing using the Mobile Client WEBTOGO.ORA File

16.2.2 Turn on Tracing using the -d0 Option for Web-to-Go Clients With the WEBTOGO Executable

16.2.3 View Device Logs

16.3 Viewing the Log Files From the Application Server

17 Reports

17.1 Viewing System Status Reports for the Server

17.2 Viewing Active User Sessions

18 Adding Popular URLs as Bookmarks to Mobile Server Main Page

18.1 Setting Up Popular URLs as Bookmarks

18.2 Deleting Bookmarks

A Troubleshooting FAQs

A.1 Synchronization Errors and Conflicts

A.1.1 General Synchronization Errors and Conflicts

A.1.2 Synchronization Error if WinCE/Pocket PC Device Clock is Inaccurate

A.2 Problems When Synchronizing Large Number of Rows

A.3 Inspecting Files in the Mobile Server Repository

A.4 Running the Mobile Server With Tracing Enabled

A.5 First Synchronization Causes Browser to Timeout

A.6 Accessing the Client Database Offline

A.7 Accessing Schema Changes to a Published Application

A.8 Troubleshooting An Out of Memory Error

A.9 Troubleshooting an IllegalArgumentException

B Configuration Parameters for the WEBTOGO.ORA File

B.2 [FILESYSTEM]

B.5 [SERVLET_PARAMETERS]

B.6 [CONSOLIDATOR]

C Data Synchronization Requirements in INIT.ORA

C.1 Relationships Between Relevant Parameters

C.2 Values for Processes and DML Locks

D Scripting Language for the Mobile Server

D.1 Description of the Syntax

D.2 Running a Script INI File

D.3.1 Creating, Adding, and Granting Access

D.3.2 Deleting, Removing, and Revoking Access

E Bypassing a Proxy Server

F System Catalog Views

F.1 Mobile Server Catalog Views

F.1.1 "MOBILEADMIN".CV$ALL_CLIENTS

F.1.2 "MOBILEADMIN".CV$ALL_ERROR

F.1.3 "MOBILEADMIN".CV$ALL_PUBLICATIONS

F.1.4 "MOBILEADMIN".CV$ALL_SUBSCRIPTIONS

F.1.5 "MOBILEADMIN".CV$ALL_SEQUENCES

F.1.6 "MOBILEADMIN".CV$ALL_SEQUENCE_PARTITIONS

F.1.7 "MOBILEADMIN".CV$ALL_PUBLICATION_ITEMS_ADDED

F.1.8 "MOBILEADMIN".CV$ALL_PUBLICATION_ITEMS

F.1.9 "MOBILEADMIN".CV$ALL_PUBLICATION_ITEM_INDEXES

F.1.10 " MOBILEADMIN".CV.$ALL_SUBSCRIPTION_PARAMS

G Using the JDBC Thin Driver

G.1 Upload the Oracle JDBC Driver

G.2 Change the Applet Tag

H POLITE.INI Parameters

H.1 POLITE.INI File Overview

H.2 All Databases Section

H.2.1 CACHE_SIZE

H.2.2 DATA_DIRECTORY

H.2.3 DATABASE_ID

H.2.4 DB_CHAR_ENCODING

H.2.5 EXTERNAL_ENCRYPTION_DLL

H.2.6 FLUSH_AFTER_WRITE

H.2.7 MAX_INDEX_COLUMNS

H.2.8 MESSAGE_FILE

H.2.9 NLS_DATE_FORMAT

H.2.9.1 Date Format

H.2.9.2 Date Format Examples

H.2.10 NLS_LOCALE

H.2.11 NLS_SORT

H.2.12 OLITE_SERVER_LOG

H.2.13 OLITE_SERVER_TRACE

H.2.14 OLITE_SQL_TRACE

H.2.15 SQLCOMPATIBILITY

H.2.17 TEMP_DIR

H.2.18 SERVICE_PORT

H.3 Sync Client Parameters—SYNC Section

H.3.1 Overview of OCAPI—msync Client API

H.3.2 Synchronization Parameters

H.3.2.1 TIME_LOG

H.3.2.2 UPDATE_LOG

H.3.2.3 COMPRESSION

H.3.2.5 AUTO_COMMIT_COUNT

H.3.2.6 TEMP_DIR

H.3.2.7 RESUME_CLIENT_TIMEOUT

H.3.2.8 RESUME_CLIENT_MAXSEND

H.3.2.9 ERROR_REPORT

H.3.2.10 DB_ENCODING

H.3.2.11 MEM_THRESHOLD

H.3.2.12 VALIDATEDB

H.3.2.13 ENCRYPT_DB

H.4 Device Parameters—DMC Section

H.5 Sample POLITE.INI File

Glossary

Index