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 Roadmap to Understanding and Using the Mobile Server
  • 1.2.1 Designing and Developing your Mobile Applications
  • 1.2.2 Synchronizing Data from a Mobile Client to the Oracle Database
    • 1.2.2.1 Using the SQLite Database
    • 1.2.2.2 Using the Oracle Lite Database
  • 1.2.3 Configuring and Managing the Mobile Server Environment
  • 1.2.4 Performance Techniques

2 Third Party Licensing in Oracle Database Lite

• 2.1 SQLite Database
• 2.2 Sun Microsystems JRE 1.4.2 and JRE 5.0
• 2.3 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
  • 3.3.5 Certified Versions for OID Support
  • 3.3.6 Certified Platforms and Technologies for the Mobile Server
  • 3.3.7 Certified Browsers
• 3.4 Installation Requirements for the Oracle Database and Oracle Application Server in Working With Oracle Database Lite
  • 3.4.1 Installation Requirements for the Oracle Database for Working With a Mobile Client
  • 3.4.2 Installation Requirements for Using the Oracle Application Server With Oracle Database Lite
    • 3.4.2.1 Installing OracleAS Version 10.1.2
    • 3.4.2.2 Installing OracleAS Version 10.1.3
    • 3.4.2.3 Installing Oracle WebLogic Server 11g Release 1
• 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 JAVA15_HOME, JAVA_HOME and PATH
    • 3.7.1.3 DISPLAY
    • 3.7.1.4 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 Mobile Clients
• 3.9 System Requirements for Symbian Devices
• 3.10 Mounting the Installation CD-ROM For UNIX Systems
  • 3.10.1 Mounting CD-ROMs For AIX
  • 3.10.2 Mounting CD-ROMs For HP
  • 3.10.3 Mounting CD-ROMs For Linux
    • 3.10.3.1 Mounting CD-ROMs For Linux With Auto Mounting Software
    • 3.10.3.2 Mounting CD-ROMs For Linux Manually
• 3.11 Setting Up Location of the Datafile on the Server
• 3.12 Defining Synchronization Tablespace

4 Installation of Oracle Database Lite

• 4.1 Oracle Database Lite Installation Considerations
  • 4.1.1 Installing Multiple Languages on a Single Solaris Machine
  • 4.1.2 National Language Support for Chinese, Japanese, and Korean (CJK)
  • 4.1.3 Mobile Server on a DHCP Server is Not Supported
• 4.2 Starting Oracle Universal Installer
  • 4.2.1 Starting the Oracle Universal Installer on Windows
  • 4.2.2 Starting Oracle Universal Installer on UNIX
    • 4.2.2.1 Using the oraInventory Directory
    • 4.2.2.2 Location of Files on UNIX
• 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 for Mobile Server or Mobile Development Kit on Windows
    • 4.3.2.2 Silent Install Mobile Server or the Mobile Development Kit on UNIX
  • 4.3.3 Providing High Availability with a Farm of Multiple Mobile Servers
  • 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 Mobile Client Install
  • 4.3.7 Custom Install
• 4.4 Post-Installation Configuration Requirements
  • 4.4.1 Username and Password for WebLogic Server Domain
  • 4.4.2 Setup DISPLAY Variable for UNIX Systems in Oracle Application Server
  • 4.4.3 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 Upgrade Oracle Database Lite

• 5.1 Upgrade Your Oracle Database Lite from 5.0.2.x to 10g Release 3
  • 5.1.1 What 5.0.2.x Versions Can I Upgrade to 10g Release 3?
  • 5.1.2 Pre-Upgrade Instructions for the 5.0.2.x Version
  • 5.1.3 Upgrade Your 5.0.2.x Version Mobile Server Repository
  • 5.1.4 Upgrade Your 5.0.2.x Version Existing Applications
    • 5.1.4.1 Manual Upgrade Instructions For Web-to-Go Applications in Retrieving the OraUserProfile Class
  • 5.1.5 Upgrading BC4J Oracle Lite Mobile Client 5.0.2.x to Version 10g Release 2
  • 5.1.6 Upgrading 5.0.2.x Version Branch Office
  • 5.1.7 Use the Appropriate Context for Your Mobile Server
  • 5.1.8 Migrate Your 5.0.2.x Version Users From the Mobile Server Repostory to the Oracle Internet Directory
  • 5.1.9 Post-Upgrade Instructions for 5.0.2.x Version
  • 5.1.10 Remove the 5.0.2.x Installation
  • 5.1.11 New Consolidator Sequence Properties Added During Upgrade
  • 5.1.12 Upgrade Oracle Database Lite Release 2 to Release 3
• 5.2 Upgrade Your Oracle Database Lite from 10g Release 1 or 2 to 10g Release 3
  • 5.2.1 To What Versions Can I Upgrade Oracle Database Lite?
    • 5.2.1.1 Upgrading in the Same ORACLE_HOME
    • 5.2.1.2 Upgrading in a Separate ORACLE_HOME
    • 5.2.1.3 Supported Oracle Database Lite Versions for Upgrade
  • 5.2.2 Pre-Upgrade Instructions
  • 5.2.3 Upgrade Your Mobile Server Repository
  • 5.2.4 Upgrade Your Existing Applications
  • 5.2.5 Installing Sample Applications
  • 5.2.6 Upgrade Branch Office 10g Release 1 or 2 to version 10g Release 3
  • 5.2.7 Migrate Your Users From the Mobile Server Repository to the Oracle Internet Directory (OID)
    • 5.2.7.1 Mobile Server Installed On Oracle Application Server 10.1.2.0.0
    • 5.2.7.2 Mobile Server Installed on Oracle Application Server 10.1.3.1.0 or Higher
  • 5.2.8 Remove the 10g Release 1 or 2 Installation
  • 5.2.9 Remove Duplicate Mobile Server IDs from the Repository
• 5.3 Upgrade the Oracle Lite Mobile Client
  • 5.3.1 Upgrade the Oracle Lite Mobile Client Version 5.0.2.10 to Version 10g Release 3
  • 5.3.2 Upgrade the Oracle Lite Mobile Client 10g Release 1 or 2 to 10g Release 3
  • 5.3.3 Upgrade the Oracle Lite Mobile Clients from De-Supported Mobile Client Platforms

6 Quick Start for Oracle Database Lite

• 6.1 Installing the Sample Applications
• 6.2 Starting Oracle Database Lite and Its Job Scheduler
• 6.3 Starting a Windows 32 Application
  • 6.3.1 Software Requirements for the Win32 Demo
  • 6.3.2 Download the Oracle Lite Mobile Client from the Mobile Server
  • 6.3.3 Install the Mobile Client on the Win32 Device
  • 6.3.4 Start the Win32 Sample Application
  • 6.3.5 Enter and View Data in the Win32 Sample Application
  • 6.3.6 Synchronize the Win32 Sample Application Data to the Database
• 6.4 Starting a Web-Based Application
  • 6.4.1 Download the Mobile Client from the Mobile Server
  • 6.4.2 Install the Web Mobile Client
  • 6.4.3 Enter and Sync Data in the Web Client Sample
• 6.5 Starting an Application on Your WinCE Device
  • 6.5.1 Verify the Software and Hardware Requirements for the WinCE Demo
  • 6.5.2 Download the Mobile Client from the Mobile Server
  • 6.5.3 Install the WinCE Mobile Client
  • 6.5.4 Enter and View Data in the WinCE Sample Application
  • 6.5.5 Synchronize the WinCE Application Data to the Database

Index