Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Send Us Your Comments

1 Oracle Database Lite Management With the Mobile Server

• 1.1 Using Mobile Manager to Manage Your Mobile Server
  • 1.1.1 Viewing Mobile Servers
    • 1.1.1.1 Mobile Server Home Page
    • 1.1.1.2 Manage Applications
    • 1.1.1.3 Manage Users
    • 1.1.1.4 Mobile Server Administration
    • 1.1.1.5 Data Synchronization
    • 1.1.1.6 Job Scheduler
  • 1.1.2 Viewing Mobile Devices
    • 1.1.2.1 Installed Mobile Devices
    • 1.1.2.2 Mobile Device Platforms
• 1.2 Manage Mobile Server Farms
• 1.3 Enabling UIX Dynamic Image Generation on UNIX to See Mobile Manager Buttons
  • 1.3.1 Headless Java
  • 1.3.2 X Server Access

2 Connecting to the Oracle Lite and Oracle Databases

• 2.1 Oracle Lite Database Overview
• 2.2 Creating and Managing the Database for a Mobile Client
• 2.3 Connecting to the Oracle Lite Database
  • 2.3.1 Connecting to an Embedded Oracle Lite Database
  • 2.3.2 Connecting to the Back-End Oracle Database
• 2.4 Enabling Client/Server for Multiple Users to Access Single Entry Point for Database

3 Managing Your Mobile Applications

• 3.1 Listing Applications
• 3.2 Publishing Applications to the Mobile Server Repository
• 3.3 Deleting an Application
• 3.4 Managing Application and Connection Properties
• 3.5 Managing User-Specific Application Parameters (Data Subsetting)
• 3.6 Managing Access Privileges for Users and Groups
  • 3.6.1 Granting Application Access to Users and Groups
  • 3.6.2 Revoking Application Access to Users and Groups
• 3.7 Selecting Application Files for Public Use
• 3.8 Adding Web Application Archive (WAR) Files
• 3.9 Modifying Registry Entries

4 Managing Users and Groups

• 4.1 What Are the Types of Mobile Server Users?
  • 4.1.1 Mobile Server User Privilege: Administrator
  • 4.1.2 Mobile Server User Privilege: Organizer
  • 4.1.3 Mobile Server User Privilege: User
  • 4.1.4 Mobile Server User Privilege: Member
• 4.2 Guide to Creating User and Administrator Types
  • 4.2.1 Creating a User to Access a Published Application
  • 4.2.2 Creating an Administrator
  • 4.2.3 Creating a Member of a User
• 4.3 Managing Users, Groups, and Members
  • 4.3.1 Managing Mobile Server Users
    • 4.3.1.1 Displaying Users
    • 4.3.1.2 Adding New Users
    • 4.3.1.3 Associating Mobile Server Users With Published Applications
    • 4.3.1.4 Duplicating Existing Users
    • 4.3.1.5 Swap Users on a Device
    • 4.3.1.6 Managing OID Users in the Mobile Server
    • 4.3.1.7 Providing Your Own Authentication for a User
  • 4.3.2 Adding New Groups
  • 4.3.3 Adding New Members and Associating Them With Users
    • 4.3.3.1 Creating New Members
    • 4.3.3.2 Associate Members With a User
  • 4.3.4 Deleting Groups or Individual Users
• 4.4 Managing Access Privileges for Users and Groups
  • 4.4.1 Grant or Revoke Application Access to Users
    • 4.4.1.1 Grant Application Access to Users
    • 4.4.1.2 Revoke Application Access to Users
  • 4.4.2 Include or Exclude Users from Group Based Access
    • 4.4.2.1 Include Users in a Group
    • 4.4.2.2 Exclude Users from a Group
  • 4.4.3 Grant or Revoke Application Access to Groups
• 4.5 Managing Application Parameter Input (Data Subsetting)
• 4.6 Assigning Application Roles to Users
• 4.7 Manually Adding Devices for a User
• 4.8 Configuring How the Device Receives Software Updates for the User

5 Managing Synchronization

• 5.1 How Does the Synchronization Process Work?
  • 5.1.1 Defining Behavior of Apply/Compose Phase for Synchronization
• 5.2 User Scenarios for Synchronization
• 5.3 Managing the Sync Server from the Data Synchronization Home Page
  • 5.3.1 Starting/Stopping the Sync Server
  • 5.3.2 Checking Synchronization Alerts
  • 5.3.3 Managing Sync Sessions
  • 5.3.4 Displaying Operating System (OS) and Java Virtual Machine (JVM) Information
• 5.4 Using Automatic Synchronization
  • 5.4.1 Specifying Platform Rules for Automatic Synchronization
  • 5.4.2 Start, Stop, or Get Status for Automatic Synchronization
  • 5.4.3 How the Automatic Synchronization Transaction is Retried
  • 5.4.4 Viewing Client-Side Synchronization Conflicts
• 5.5 Configuring Data Synchronization For Farm or Single Mobile Server
• 5.6 Resuming an Interrupted Synchronization
  • 5.6.1 Defining Temporary Storage Location for Client Data
  • 5.6.2 Controlling Server Load
  • 5.6.3 Client Configuration.
• 5.7 Register a Remote Oracle Database for Application Data
  • 5.7.1 Register or Deregister a Remote Oracle Database for Application Data
• 5.8 Improving Performance for Multiple Clients that Use the Same Read-Only Data With a Cached User
• 5.9 Synchronizing to a File With File-Based Sync
  • 5.9.1 Upload Synchronization Transactions to an Encrypted File on the Mobile Client
  • 5.9.2 Apply and Compose Mobile Client Transactions on the Mobile Server
  • 5.9.3 Download Composed Transactions from Mobile Server to the Mobile Client
  • 5.9.4 Troubleshooting File-Based Synchronization Scenarios
    • 5.9.4.1 Normal Network Synchronization Occurs During File Upload
    • 5.9.4.2 Conflict Resolution for File-Based Synchronization
• 5.10 Encrypting the Oracle Lite Database
• 5.11 Managing Trace Settings and Trace Files
• 5.12 Browsing the Repository for Synchronization Details
  • 5.12.1 Viewing User Information
  • 5.12.2 Viewing Publications
  • 5.12.3 Viewing Publication Items
  • 5.12.4 Viewing Synchronization Queues
    • 5.12.4.1 Viewing Transactions in the In-Queue
    • 5.12.4.2 Viewing Subscriptions in the Out-Queue
    • 5.12.4.3 Viewing Server-Side Synchronization Conflicts and Errors in the Error Queue
  • 5.12.5 Viewing Client-Side Synchronization Conflicts
• 5.13 Monitoring and Analyzing Performance
  • 5.13.1 Viewing Sync Server Statistics
  • 5.13.2 Displaying MGP Cycles and Statistics
  • 5.13.3 Analyzing Performance of Publications With the Consperf Utility
  • 5.13.4 Monitoring Synchronization Using SQL Scripts

6 Managing Jobs with the Job Scheduler

• 6.1 Scheduling a Job to Execute at a Specific Time or Interval
• 6.2 Managing the Job Engine
  • 6.2.1 Starting the Job Scheduler
  • 6.2.2 Checking Job Scheduler Alerts
  • 6.2.3 Managing Active Jobs
  • 6.2.4 Managing the Job History List
• 6.3 Manage Scheduled Jobs Using the Mobile Manager
  • 6.3.1 Creating a New Job
  • 6.3.2 Editing Existing Jobs
  • 6.3.3 Viewing MGP Current Cycle Statistics
  • 6.3.4 Viewing MGP Cycle Statistics
  • 6.3.5 Enabling or Disabling Jobs
  • 6.3.6 Deleting Jobs
  • 6.3.7 Default Jobs
    • 6.3.7.1 MGP_DEFAULT
    • 6.3.7.2 PURGE_HISTORY_DEFAULT
• 6.4 Managing or Creating Jobs Using ConsolidatorManager APIs

7 Manage Your Devices

• 7.1 Customize the Mobile Client Software Installation for Your Mobile Device
• 7.2 Configuring Mobile Clients Before Installation
  • 7.2.1 Modifying Device Management Parameters for Client Device
  • 7.2.2 Modifying WEBTOGO Parameters for Client Device
  • 7.2.3 Modifying Oracle Lite Mobile Client Win32 Parameters for Client Device
• 7.3 Managing Devices
  • 7.3.1 Viewing Device Information
  • 7.3.2 Viewing Database Information
  • 7.3.3 Viewing Software Information
  • 7.3.4 Commands
  • 7.3.5 Queue
  • 7.3.6 Command History
  • 7.3.7 Viewing Device Logs
• 7.4 Configuring and Customizing Your Mobile Device Platform
  • 7.4.1 Modifying Platform Properties for Installation
  • 7.4.2 Enabling or Disabling All Mobile Devices in a Platform
  • 7.4.3 Extend or Create a Custom Platform
    • 7.4.3.1 Enable a Platform for Your Mobile Client
    • 7.4.3.2 Create a Custom Platform By Extending an Existing Platform
• 7.5 Configuring Your Mobile Devices
  • 7.5.1 Enabling or Disabling a Mobile Device
• 7.6 Sending Commands to Your Mobile Devices
  • 7.6.1 Scheduling or Sending Commands
    • 7.6.1.1 Sending Commands
    • 7.6.1.2 Scheduling Commands
  • 7.6.2 Modifying Existing Commands
    • 7.6.2.1 Adding Parameters to Mobile Device Commands
  • 7.6.3 Creating New Commands
  • 7.6.4 Creating Group Commands
  • 7.6.5 Enabling or Disabling Mobile Device Commands
  • 7.6.6 Viewing the Mobile Device Command History
  • 7.6.7 Examples of Mobile Commands
• 7.7 Managing Device Software Updates
  • 7.7.1 Configuring the Device to Receive Required Software Updates
    • 7.7.1.1 Allowing Automatic Software Updates for the Oracle Database Lite Platform
    • 7.7.1.2 Updating Application Software On Each Client
    • 7.7.1.3 Rolling Out Updates With Controlled Upgrade
  • 7.7.2 Configuring Application Software for Automatic Update
    • 7.7.2.1 Configuring Major Software Updates for Download
    • 7.7.2.2 Configuring Patches or Minor Updates for Download
  • 7.7.3 Initiate Updates of Oracle Database Lite Software from the Client
• 7.8 Using the Device Manager Agent (dmagent) on the Client
• 7.9 Managing the Network Protocol Between the Device and the Mobile Client Software
• 7.10 Installation Configuration (INF) File
  • 7.10.1 Setup Information
  • 7.10.2 Properties
  • 7.10.3 Initialization
  • 7.10.4 Including Other INF Files
  • 7.10.5 INSTALL Element
    • 7.10.5.1 DIRECTORY Section
    • 7.10.5.2 FILE Section
    • 7.10.5.3 ENV Section
    • 7.10.5.4 REGISTRY Section
    • 7.10.5.5 ODBC Section
    • 7.10.5.6 JAVA Section
    • 7.10.5.7 LINK Section
    • 7.10.5.8 INI Section
    • 7.10.5.9 EXECUTE Section
    • 7.10.5.10 REGISTER Section
• 7.11 Defining Device Manager Commands With the Device Manager OTL Tag Language
  • 7.11.1 Device Manager Tag Language Data Types
    • 7.11.1.1 Character
    • 7.11.1.2 Number
    • 7.11.1.3 Integer
    • 7.11.1.4 Long
    • 7.11.1.5 Double
    • 7.11.1.6 Boolean
    • 7.11.1.7 String
    • 7.11.1.8 Array
    • 7.11.1.9 Date Methods
    • 7.11.1.10 Time Methods
    • 7.11.1.11 Enumeration
    • 7.11.1.12 File
  • 7.11.2 Operators That You Can Use With the Device Manager Tag Language
  • 7.11.3 Syntax for the Device Manager Tag Language
    • 7.11.3.1 Initialization Statements
    • 7.11.3.2 Assignment Statements
  • 7.11.4 Conditional Statements
    • 7.11.4.1 If-Else Conditional Statement
    • 7.11.4.2 While Conditional Statement
    • 7.11.4.3 Foreach Conditional Statement
    • 7.11.4.4 Break Statement
    • 7.11.4.5 Choose Statement
  • 7.11.5 Define Custom Functions
  • 7.11.6 Manage the Database Connection
    • 7.11.6.1 Specify Database Connection Information for an Application
    • 7.11.6.2 Disconnect from the Database
  • 7.11.7 Global Classes
    • 7.11.7.1 Methods of the System Class
    • 7.11.7.2 Methods of the DeviceManager Class
  • 7.11.8 Importing Another OTL Page
  • 7.11.9 Error Handling
  • 7.11.10 Sample Device Manager Commands Using the Tag Language

8 Manage Your Branch Office

• 8.1 Introduction
  • 8.1.1 What is the Branch Office?
  • 8.1.2 How the Branch Office Works
  • 8.1.3 The Branch Office Manager
  • 8.1.4 Synchronizing Data with Headquarters
• 8.2 Branch Office Installation and Configuration
  • 8.2.1 Terms and Concepts
  • 8.2.2 Overview
  • 8.2.3 Branch Office Pre-Installation Considerations
  • 8.2.4 Branch Office Installation
  • 8.2.5 Enabling Branch Office on Windows XP Service Pack 2
  • 8.2.6 Changing Branch Office Listener Port Number and Working Directory
  • 8.2.7 Accessing Branch Office or the Multi-User Service Using an ODBC or JDBC Driver
  • 8.2.8 Changing the Language or Locale for Branch Office Client
• 8.3 Architecture
  • 8.3.1 The Branch Office Environment
    • 8.3.1.1 The Branch Office Client
    • 8.3.1.2 The Branch Office
    • 8.3.1.3 Company Headquarters
  • 8.3.2 Connecting Clients to the Branch Office Database Machine
    • 8.3.2.1 ODBC Connection
    • 8.3.2.2 JDBC Connections
• 8.4 Administration
  • 8.4.1 Logging into the Branch Office Manager
  • 8.4.2 Using the Branch Office Manager
    • 8.4.2.1 Updating Status Summary
    • 8.4.2.2 Starting the Database Service
    • 8.4.2.3 Stopping the Database Service
    • 8.4.2.4 Viewing the Status of the Branch Office Database
  • 8.4.3 Managing Branch Office Users
    • 8.4.3.1 Creating Users
    • 8.4.3.2 Setting User Roles
    • 8.4.3.3 Setting User Properties
    • 8.4.3.4 Setting User Privileges
    • 8.4.3.5 Finding Users
    • 8.4.3.6 Removing a User
  • 8.4.4 Managing Applications
    • 8.4.4.1 Downloading Public Files to Your Client

9 Offline Instantiation for Oracle Lite Mobile Clients

• 9.1 Using Offline Instantiation to Distribute Multiple Oracle Lite Mobile Clients
• 9.2 Setting Up the Mobile Server Host and Mobile Development Kit Host
• 9.3 Downloading the Oracle Lite Mobile Client SETUP Executable
• 9.4 Configure How OLI Creates the Client Distribution Packages With the OLI Configuration File
  • 9.4.1 SETUP
  • 9.4.2 USERS
  • 9.4.3 Example of OLI.INI File
• 9.5 Using the OLI Engine to Create and Package the Client Distribution File
  • 9.5.1 Create and Populate Client Database Files with the MAKEODB Command
  • 9.5.2 Package the Mobile Client Binaries with the Client Database Files with the PACKAGE Command
  • 9.5.3 Clean Up the OLI Tables Before Executing OLI for Another Distribution
  • 9.5.4 Check the Status of OLI Clients
• 9.6 Deploying Client Distribution Files on Client Machines
  • 9.6.1 Deploy Win32 Native or Web-to-Go Client Distribution Package
  • 9.6.2 Deploy WinCE PocketPC Client Distribution Package
• 9.7 Creating a Single Package or Shared CD for Users That Share Data

10 Using the Application Server OID With Mobile Server

11 Configure Security in Oracle Database Lite

• 11.1 Security Enhancements
• 11.2 Which Password is Which?
  • 11.2.1 Modifying Repository Password
• 11.3 Providing Security for the Mobile Client
• 11.4 Configuring for Secure Socket Layer (SSL) Communication
  • 11.4.1 Creating an SSL Certificate
  • 11.4.2 Configuring Mobile Server for SSL
    • 11.4.2.1 Configuring SSL for Mobile Server With OracleAS
    • 11.4.2.2 Configuring SSL for Standalone Mobile Server
  • 11.4.3 Using Packaging Wizard For SSL-Enabled Mobile Server
  • 11.4.4 Enabling SSL Authentication for Web-to-Go Clients
  • 11.4.5 Troubleshooting Error Messages for an SSL-Enabled Mobile Server
  • 11.4.6 Client-Side Configuration for Secure Socket Layer (SSL)
    • 11.4.6.1 Communication between the Mobile Client and the Mobile Server
    • 11.4.6.2 Connection between the Browser and the Mobile Client for OC4J or Web-to-Go
    • 11.4.6.3 Support for Non-SSL Mobile Clients
• 11.5 Providing Your Own Authentication Mechanism for Oracle Database Lite
• 11.6 Using a Firewall Proxy or Reverse Proxy
  • 11.6.1 Using a Reverse Proxy to Communicate from Internet to Intranet
    • 11.6.1.1 Configure the Apache Web Server as a Reverse Proxy
    • 11.6.1.2 Set Up Mobile Server for Mobile Client Download
    • 11.6.1.3 Download Reverse Proxy Mobile Client
    • 11.6.1.4 Enable SSL When Using a Reverse Proxy
    • 11.6.1.5 Configure Device Management to Work With a Firewall
  • 11.6.2 Using HTTP Proxy to Communicate From Inside a Firewall
    • 11.6.2.1 Proxy Configuration for Web-to-Go Clients
    • 11.6.2.2 Proxy Configuration for All Other Clients
    • 11.6.2.3 Proxy Configuration for the Device Manager Agent
    • 11.6.2.4 Reverse Proxy Configuration for HTTP PUSH from Mobile Server Not Supported
• 11.7 Providing SSL Client Authentication with a Common Access Card
  • 11.7.1 Introduction to SSL Client Authentication
  • 11.7.2 Smartcard and Common Access Card Overview
  • 11.7.3 Oracle Database Lite Supports Common Access Cards
  • 11.7.4 Supported Platforms for the Common Access Card
    • 11.7.4.1 Support for Mobile Clients That Are Not Enabled for Client Authentication
  • 11.7.5 Prerequisites for Common Access Card
  • 11.7.6 Configuration for Client Authentication Using the Common Access Card
    • 11.7.6.1 Configuration of the Mobile Server to Request Client Authentication
    • 11.7.6.2 Configuration of the Mobile Client to Use a CAC
    • 11.7.6.3 Configuration for Reverse Proxy and Load Balancer
  • 11.7.7 Using the Common Access Card
• 11.8 Security Warning for Demo Applications

12 Configure for National Language Support (NLS)

• 12.1 Configuring OC4J to Handle Multibyte Characters in Web Applications

13 Reports

• 13.1 Viewing System Status Reports for the Server
• 13.2 Viewing Active User Sessions

14 Adding Popular URLs as Bookmarks to Mobile Server Main Page

• 14.1 Setting Up Popular URLs as Bookmarks
• 14.2 Deleting Bookmarks

A Configuration Parameters for the WEBTOGO.ORA File

• A.1 [APPLICATIONS]
• A.2 [WEBTOGO]
• A.3 [FILESYSTEM]
• A.4 [DEBUG]
• A.5 [PUBLIC]
• A.6 [SERVLET_PARAMETERS]
• A.7 [CONSOLIDATOR]
  • A.7.1 Data Synchronization Parameters
  • A.7.2 Data Synchronoization Tracing and Logging

B Data Synchronization Requirements in INIT.ORA

• B.1 Relationships Between Relevant Parameters
• B.2 Values for Processes and DML Locks

C Write Scripts for the Mobile Server With the WSH Tool

• C.1 Description of Syntax for WSH Batch Scripts
  • C.1.1 Creating a User
    • C.1.1.1 EXTERNALUSER Parameter
    • C.1.1.2 PRIVILEGE Parameter
  • C.1.2 Creating a Group
  • C.1.3 Adding Users to a Group
  • C.1.4 Removing Users from a Group
  • C.1.5 Creating Access Privileges
  • C.1.6 Granting Access
  • C.1.7 Revoking Access
  • C.1.8 Creating Registries
  • C.1.9 Creating Snapshot Variables
  • C.1.10 Deleting a User
  • C.1.11 Deleting a Group
  • C.1.12 Deleting Access Privileges
  • C.1.13 Deleting a Registry
  • C.1.14 Deleting Snapshot Variables
• C.2 Running a Script INI File With the WSH Tool
  • C.2.1 Execute Batch Command Script File on the Mobile Server
  • C.2.2 Inspect Files on Web-to-Go or Branch Office Client
• C.3 Examples of Batch Script Files for WSH
  • C.3.1 Creating, Adding, and Granting Access
  • C.3.2 Deleting, Removing, and Revoking Access

D Catalog Views for the Mobile Server and the Mobile Client

• D.1 Mobile Server System Catalog Views
  • D.1.1 CV$ALL_CLIENTS
  • D.1.2 CV$ALL_ERROR
  • D.1.3 CV$ALL_PUBLICATIONS
  • D.1.4 CV$ALL_SUBSCRIPTIONS
  • D.1.5 CV$ALL_SEQUENCES
  • D.1.6 CV$ALL_SEQUENCE_PARTITIONS
  • D.1.7 CV$ALL_PUBLICATION_ITEMS_ADDED
  • D.1.8 CV$ALL_PUBLICATION_ITEMS
  • D.1.9 CV$ALL_PUBLICATION_ITEM_INDEXES
  • D.1.10 CV.$ALL_SUBSCRIPTION_PARAMS
• D.2 Client Oracle Lite Database System Catalogs

E POLITE.INI Parameters

• E.1 POLITE.INI File Overview
• E.2 All Databases Section
• E.3 Sync Client Parameters—SYNC Section
  • E.3.1 Overview of OCAPI—msync Client API
  • E.3.2 Synchronization Parameters
    • E.3.2.1 TIME_LOG
    • E.3.2.2 UPDATE_LOG
    • E.3.2.3 DEBUG
    • E.3.2.4 AUTO_COMMIT_COUNT
    • E.3.2.5 TEMP_DIR
    • E.3.2.6 RESUME_CLIENT_TIMEOUT
    • E.3.2.7 RESUME_CLIENT_MAXSEND
    • E.3.2.8 ERROR_REPORT
    • E.3.2.9 DB_ENCODING
    • E.3.2.10 MEM_THRESHOLD
    • E.3.2.11 VALIDATEDB
    • E.3.2.12 ENCRYPTDB
    • E.3.2.13 SSL_IGNORE_CERT
• E.4 Synchronization Agent—SYNC_AGENT Section
  • E.4.1 SYNC_AGENT
    • E.4.1.1 ENABLE
    • E.4.1.2 SYNC_LOG
• E.5 Device Management Parameters—DMC Section
  • E.5.1 DISABLE_PROMPT
  • E.5.2 PUSH_PORT
  • E.5.3 UPDATE_DAY and UPDATE_TIME
  • E.5.4 MAX_RETRY
  • E.5.5 FREQUENCY
  • E.5.6 DEBUG
• E.6 Network Parameters—NETWORK Section
  • E.6.1 DISABLE_SSL_CHECK
  • E.6.2 HTTP_PROXY
• E.7 Sample POLITE.INI File

Glossary

Index