1/11
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 10
g
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 10
g
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 10
g
Release 1 or 2 to version 10
g
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 10
g
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 10
g
Release 3
6.3.2
Upgrade Mobile Client 10
g
Release 1 or 2 to 10
g
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
Scripting on this page enhances content navigation, but does not change the content in any way.