Contents

Title and Copyright Information

Preface

• Intended Audience
• Documentation Accessibility
• Send Us Your Comments
• Related Documents
• Conventions

1 Oracle Database Lite Concepts

• 1.1 Overview of Oracle Database Lite
  • 1.1.1 What Is A Mobile Architecture?
  • 1.1.2 What Are The Benefits Of A Mobile Architecture?
  • 1.1.3 Why Use Oracle Database Lite?
• 1.2 Execution Models for Oracle Lite Database
  • 1.2.1 Embedded Application in Single Process
  • 1.2.2 Multiple Processes Accessing the Same Database
  • 1.2.3 Multiple Embedded Application Clients Accessing Remote Database
  • 1.2.4 Mobile Option for a Client in a Single Process
  • 1.2.5 Mobile Option for Multiple Clients Accessing Remote Database
• 1.3 Oracle Database Lite Application Models
  • 1.3.1 Publish-Subscribe Model for Mobile Users
    • 1.3.1.1 Defining the Weight and Conflict Resolution for Publication Items
    • 1.3.1.2 Behavior and Requirements for Primary Keys, Foreign Keys and Not Null Fields in Publication Items
  • 1.3.2 Client Mobile Database Created on First Synchronization
• 1.4 How Oracle Database Lite Synchronizes
  • 1.4.1 Deciding on Automatic or Manual Synchronization
  • 1.4.2 Deciding on Synchronization Refresh Option
    • 1.4.2.1 Fast Refresh
    • 1.4.2.2 Complete Refresh
    • 1.4.2.3 Queue-Based Refresh
    • 1.4.2.4 Forced Refresh
• 1.5 Mobile Application Design
  • 1.5.1 Steps for Designing Your Mobile Application
    • 1.5.1.1 Read the Documentation Before Design
    • 1.5.1.2 Gather Mobile Requirements
    • 1.5.1.3 Proof of Concept
    • 1.5.1.4 Prototype
    • 1.5.1.5 Design for Data Subsets
    • 1.5.1.6 Design for Indexing
    • 1.5.1.7 Design for Sequences
    • 1.5.1.8 Design for Synchronization
    • 1.5.1.9 Design for Administration
    • 1.5.1.10 Design for the Language Utilized for Handheld Devices
  • 1.5.2 Application Programming Interfaces
  • 1.5.3 Supported Languages for Building Mobile Applications
    • 1.5.3.1 Native Applications
    • 1.5.3.2 Standalone Java Applications
    • 1.5.3.3 Web Applications
  • 1.5.4 Application Deployment into the Mobile Environment
• 1.6 Oracle Database Lite Components Involved in Synchronization
  • 1.6.1 Oracle Database Lite RDBMS
  • 1.6.2 Mobile Sync
  • 1.6.3 Mobile Server
  • 1.6.4 Message Generator and Processor (MGP)
  • 1.6.5 Mobile Server Repository
  • 1.6.6 Device Manager
• 1.7 Mobile Development Kit (MDK)
  • 1.7.1 Mobile SQL (mSQL)
  • 1.7.2 Using the Mobile Database Workbench
  • 1.7.3 Using the Packaging Wizard
• 1.8 Overview of Performance Tuning
  • 1.8.1 SQL Query Tuning
    • 1.8.1.1 Determining Performance of Client SQL Queries With the EXPLAIN PLAN
    • 1.8.1.2 Determining Performance of Client SQL Queries With SQL Tracing
  • 1.8.2 Analyzing Performance of Publications With the Consperf Utility
• 1.9 Security Considerations
  • 1.9.1 The Oracle Database Lite Encryption Utility—EncryptDB

2 Third Party Licensing in Oracle Database Lite

• 2.1 Sun Microsystems JRE 1.4.2 and JRE 5.0
• 2.2 Third Party Licensing for ZLib and JZLib

3 Requirements Before Installation or Development

• 3.1 Include the Latest Patches
• 3.2 Release Notes
• 3.3 Supported Components and Technologies
  • 3.3.1 Oracle Universal Installer
  • 3.3.2 Certified Oracle RDBMS to Use With Oracle Database Lite
  • 3.3.3 JDK Platform Support
  • 3.3.4 Certified Application Server Configurations and OID Support
  • 3.3.5 Certified Platforms and Technologies for the Mobile Server
  • 3.3.6 Certified Browsers
• 3.4 Oracle Components That Work With Oracle Database Lite
• 3.5 System Requirements for Mobile Server on Windows
  • 3.5.1 Hardware Requirements For Windows
  • 3.5.2 Software Requirements For Windows
  • 3.5.3 Defining Password for OracleDatabaseLite User for Branch Office on Windows Machine
    • 3.5.3.1 Pre-Configuring OracleDatabaseLite User Password Before Branch Office Installation
    • 3.5.3.2 Modifying Existing OracleDatabaseLite User Password After Branch Office Installation
• 3.6 System Requirements For UNIX Systems
  • 3.6.1 System Requirements For Linux
  • 3.6.2 System Requirements For Sun SPARC-Based Systems
  • 3.6.3 System Requirements For AIX-Based Systems
  • 3.6.4 System Requirements For HP-Based Systems
  • 3.6.5 Software Requirements For All UNIX Systems
• 3.7 Recommended System Configuration For UNIX
  • 3.7.1 Setting UNIX Environment Variables
    • 3.7.1.1 ORACLE_HOME
    • 3.7.1.2 JAVA13_HOME
    • 3.7.1.3 JAVA_HOME and PATH
    • 3.7.1.4 DISPLAY
    • 3.7.1.5 TMP and TMPDIR
  • 3.7.2 Pre-Install Requirements Before Installing the MDK on LINUX
  • 3.7.3 Creating UNIX Accounts and Groups
    • 3.7.3.1 UNIX Group Name For the Oracle Universal Installer Inventory
    • 3.7.3.2 UNIX Account to Own Oracle Software
  • 3.7.4 Configuring Kernel Parameters and Shell Limits for UNIX
    • 3.7.4.1 Configuring Shell Limits and System Configuration Parameters on AIX
    • 3.7.4.2 Configuring Kernel Parameters on HP-UX
    • 3.7.4.3 Configuring the Kernel Parameters on Linux
    • 3.7.4.4 Set Shell Limits for the User oracle
• 3.8 System Requirements For Windows Mobile Clients
  • 3.8.1 Hardware Requirements For Windows Mobile Clients
    • 3.8.1.1 What File System and External Memory Media Should You Use for Windows CE?
  • 3.8.2 Software Requirements For Windows Mobile Clients
    • 3.8.2.1 Certified Operating Systems and Other Software Requirements
    • 3.8.2.2 Supported and Certified Technologies for Windows Mobile Clients
    • 3.8.2.3 Supported Platforms for Oracle Database Lite WinCE
    • 3.8.2.4 Windows Mobile Client Notes
• 3.9 System Requirements for Linux Mobile Clients
  • 3.9.1 Certified Platforms and Supported Technologies for Linux Mobile Clients
  • 3.9.2 Software and Hardware Requirements for Linux Mobile Clients
  • 3.9.3 Setting Environment Variables Before Installing the Linux Mobile Client
• 3.10 System Requirements for Symbian Devices
• 3.11 Mounting the Installation CD-ROM For UNIX Systems
  • 3.11.1 Mounting CD-ROMs For AIX
  • 3.11.2 Mounting CD-ROMs For HP
  • 3.11.3 Mounting CD-ROMs For Linux
    • 3.11.3.1 Mounting CD-ROMs For Linux With Auto Mounting Software
    • 3.11.3.2 Mounting CD-ROMs For Linux Manually
• 3.12 Setting Up Location of the Datafile on the Server
• 3.13 Defining Synchronization Tablespace

4 Installation of Oracle Database Lite

• 4.1 Starting Oracle Universal Installer
  • 4.1.1 Starting the Oracle Universal Installer on Windows
  • 4.1.2 Starting Oracle Universal Installer on UNIX
    • 4.1.2.1 Using the oraInventory Directory
    • 4.1.2.2 Location of Files on UNIX
• 4.2 Oracle Database Lite Installation Considerations
  • 4.2.1 Problems with Multi-Byte Characters in User Names
  • 4.2.2 Installing Multiple Languages on a Single Solaris Machine
  • 4.2.3 National Language Support for Chinese, Japanese, and Korean (CJK)
  • 4.2.4 Mobile Server on a DHCP Server is Not Supported
• 4.3 Installing Oracle Database Lite
  • 4.3.1 GUI Install of the Mobile Server and MDK Components
    • 4.3.1.1 Installation of Mobile Development Kit
    • 4.3.1.2 Installation of Mobile Server
  • 4.3.2 Silent Install of Mobile Server and MDK Components
    • 4.3.2.1 Silent Install Mobile Server or the Mobile Development Kit on UNIX
    • 4.3.2.2 Silent Install for Mobile Server or Mobile Development Kit on Windows
  • 4.3.3 Install Multiple Mobile Servers Against the Same Mobile Server Repository (Farm)
  • 4.3.4 Install Oracle Database Lite on Linux
    • 4.3.4.1 Patch Required if Using Linux Redhat 3.0
    • 4.3.4.2 Providing Enough Swap Space on the Linux Platform
  • 4.3.5 Install Oracle Database Lite on Symbian Devices
    • 4.3.5.1 Prerequisites for Installation
    • 4.3.5.2 Oracle Database Lite 10g Components
    • 4.3.5.3 Installing Oracle Database Lite on Symbian Devices
  • 4.3.6 Client Install
  • 4.3.7 Custom Install
• 4.4 Post-Installation Configuration Requirements
  • 4.4.1 Setup DISPLAY Variable for UNIX Systems in Oracle Application Server
  • 4.4.2 Enabling Branch Office on Windows XP Service Pack 2
• 4.5 Starting Mobile Server
• 4.6 Testing Your Mobile Server Installation
• 4.7 Removing Demo Applications
• 4.8 How to Uninstall Oracle Database Lite

5 Installing Your Mobile Client

• 5.1 Preparing the Device for a Mobile Application
• 5.2 Installing the Mobile Client Software
  • 5.2.1 Installing Web-to-Go on Linux
  • 5.2.2 Use SDK CAB Files for Client Install for Java, MSQL, and Utility Support
    • 5.2.2.1 Downloading SDK CAB Files for PPC50 ARMV4I and PPC2003 ARMV4
    • 5.2.2.2 Downloading SDK CAB Files for WCESTD500 ARMV4I and WCESTD500 X86
• 5.3 Configuring for Default Sync When Installing the Client
• 5.4 Configuring the Client for Secure Socket Layer (SSL)
• 5.5 Specifying Whether the Client Uses a Static or Dynamic (DHCP) IP Address
• 5.6 Using Offline Instantiation to Distribute Multiple Mobile Clients

6 Upgrade Oracle Database Lite

• 6.1 Upgrade Your Oracle Database Lite from 5.0.2.x to 10g Release 3
  • 6.1.1 What 5.0.2.x Versions Can I Upgrade to 10g Release 3?
  • 6.1.2 Pre-Upgrade Instructions for the 5.0.2.x Version
  • 6.1.3 Upgrade Your 5.0.2.x Version Mobile Server Repository
  • 6.1.4 Upgrade Your 5.0.2.x Version Existing Applications
    • 6.1.4.1 Manual Upgrade Instructions For Web-to-Go Applications in Retrieving the OraUserProfile Class
  • 6.1.5 Upgrading BC4J Mobile Client 5.0.2.x to Version 10g Release 2
  • 6.1.6 Upgrading 5.0.2.x Version Branch Office
  • 6.1.7 Use the Appropriate Context for Your Mobile Server
  • 6.1.8 Migrate Your 5.0.2.x Version Users From the Mobile Server Repostory to the Oracle Internet Directory
  • 6.1.9 Post-Upgrade Instructions for 5.0.2.x Version
  • 6.1.10 Remove the 5.0.2.x Installation
  • 6.1.11 New Consolidator Sequence Properties Added During Upgrade
  • 6.1.12 Upgrade Oracle Database Lite Release 2 to Release 3
• 6.2 Upgrade Your Oracle Database Lite from 10g Release 1 or 2 to 10g Release 3
  • 6.2.1 To What Versions Can I Upgrade Oracle Database Lite?
  • 6.2.2 Pre-Upgrade Instructions
  • 6.2.3 Upgrade Your Mobile Server Repository
  • 6.2.4 Upgrade Your Existing Applications
  • 6.2.5 Installing Sample Applications
  • 6.2.6 Upgrade Branch Office 10g Release 1 or 2 to version 10g Release 3
  • 6.2.7 Migrate Your Users From the Mobile Server Repository to the Oracle Internet Directory (OID)
    • 6.2.7.1 Mobile Server Installed On Oracle Application Server 10.1.2.0.0
    • 6.2.7.2 Mobile Server Installed on Oracle Application Server 10.1.3.1.0.0 or Higher
  • 6.2.8 Remove the 10g Release 1 or 2 Installation
  • 6.2.9 Remove Duplicate Mobile Server IDs from the Repository
• 6.3 Upgrade the Mobile Client
  • 6.3.1 Upgrade Mobile Client Version 5.0.2.10 to Version 10g Release 3
  • 6.3.2 Upgrade Mobile Client 10g Release 1 or 2 to 10g Release 3

7 Quick Start for Oracle Database Lite

• 7.1 Installing the Sample Applications
• 7.2 Starting Oracle Database Lite and Its Job Scheduler
• 7.3 Starting a Windows 32 Application
  • 7.3.1 Software Requirements for the Win32 Demo
  • 7.3.2 Download the Mobile Client from the Mobile Server
  • 7.3.3 Install the Mobile Client on the Win32 Device
  • 7.3.4 Start the Win32 Sample Application
  • 7.3.5 Enter and View Data in the Win32 Sample Application
  • 7.3.6 Synchronize the Win32 Sample Application Data to the Database
• 7.4 Starting a Web-Based Application
  • 7.4.1 Download the Mobile Client from the Mobile Server
  • 7.4.2 Install the Web Mobile Client
  • 7.4.3 Enter and Sync Data in the Web Client Sample
• 7.5 Starting an Application on Your WinCE Device
  • 7.5.1 Verify the Software and Hardware Requirements for the WinCE Demo
  • 7.5.2 Download the Mobile Client from the Mobile Server
  • 7.5.3 Install the WinCE Mobile Client
  • 7.5.4 Enter and View Data in the WinCE Sample Application
  • 7.5.5 Synchronize the WinCE Application Data to the Database

Index