Skip Headers
Oracle® Database Lite Oracle Lite Client Guide
Release 10.3

Part Number E12548-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

2 System Requirements for the Oracle Lite Database as the Mobile Client

Before you install, you must check to see that you have the correct hardware and software necessary for using Oracle Lite as your Mobile client on your device. The requirements for the Oracle Lite client are detailed in the following sections:

2.1 System Requirements for the Oracle Lite Database as the Mobile Client on Windows

Before you install, you must check to see that you have the correct hardware and software necessary for Windows Mobile clients. The requirements for both are detailed in the following sections:

2.1.1 Hardware Requirements for the Oracle Lite Database as the Mobile Client on Windows

The hardware requirements for Windows Mobile clients are described in the following table:

Table 2-1 Hardware Requirements for Mobile Clients

Component Hardware Requirements for this Component

Mobile Client for Win32

CPU: Pentium 4, 1 GHz

Disk Space: 30 MB

RAM: 256 MB

Mobile Client for Web-to-Go

CPU: Pentium 4, 1 GHz

Disk Space: 70 MB

RAM: 512 MB

Mobile Client for Windows CE/Windows Mobile

CPU: ARM-based processor or Emulator

Storage Space: 8 MB

Free program memory: 16 MB

It matters what external memory media and file system you use. See Section 2.1.1.1, "What File System and External Memory Media Should You Use for Windows CE?" for more information.

Branch Office

CPU: Pentium 4, 1 GHz

Disk Space: 70 MB

RAM: 512 MB


2.1.1.1 What File System and External Memory Media Should You Use for Windows CE?

When you are using a WinCE device, you will probably use some form of external memory media, such as Compact Flash or SD cards. Of these two, the SD card is more reliable in its method of connecting into the device. We have seen some issues of database corruption when using Compact Flash cards, since the card can be removed in the middle of a write without notice.

When you do choose a media, you can also decide on the type of file system you use. We strongly recommend that you use the Transaction-Safe FAT (TFAT) file system over the FAT system, which is the default and more widely used. FAT has some unreliability that was not noticeable in a laptop or desktop situation. However, this unreliability in its ability to flush its buffers fully when writing out to the removable memory does not handle well when the media is removed in the middle of the transaction. Thus, the shortcomings of the FAT file system is being seen more in the WinCE environment with removable memory. The TFAT design provides transaction-safety for data storage. That is, the data that is being written out to the removable media is either completely committed or rolled-back. Thus, the TFAT file system is highly recommended for any removable data—especially for the Oracle Lite database. There is a performance consideration for using the TFAT file system. It is slower than FAT, but also more reliable.

You need to decide whether performance or reliability is your priority. The following is the order of reliability with 1 being the least reliable and 3 being the most reliable:

  1. Compact Flash media with the FAT file system.

  2. SD card media with the FAT file system.

  3. Compact Flash or SD card media with the TFAT file system.

Note:

See the Microsoft Web site for information on how to create the TFAT file system.

2.1.2 Software Requirements for the Oracle Lite Database as the Mobile Client on Windows

The software requirements for Windows Mobile clients are described in the following sections:

2.1.2.1 Certified Operating Systems and Other Software Requirements

Table 2-2 Software Requirements for Windows Mobile Clients

Mobile Client Certified Operating System Other Software Requirements

Mobile Client for Win32

Windows Vista Ultimate, Windows XP Professional Edition with Service Pack 2, or Windows 2003

If using any Java APIs, including synchronization or JDBC, use JRE 5.0

If implementing any .NET applications, use Compact Framework .NET 1.1 or 2.0

Mobile Client for Web-to-Go

Windows Vista Ultimate, Windows XP Professional Edition with Service Pack 2, or Windows 2003

 

Mobile Client for Windows CE

Windows CE 5.0

See Section 2.1.2.3, "Supported Platforms for Oracle Database Lite WinCE" for full details.

If using JDBC, use either IBMJ9 or the CrEme JDK version 4.1 from NSIcom.com.

ActiveSync version 3.8 or higher.

Microsoft .NET Compact Framework 1.0

Mobile Client for Windows Mobile

Windows Mobile 2003 Windows Pocket PC 2003 Windows Mobile 2003, 2nd edition Windows Pocket PC 2003, 2nd edition

See Section 2.1.2.3, "Supported Platforms for Oracle Database Lite WinCE" for full details.

ActiveSync version 3.8 or higher.

Microsoft .NET Compact Framework 1.1

If using JDBC, use either IBMJ9 or the CrEme JDK version 4.1 from NSIcom.com.

  • Windows Mobile 5

  • Windows Mobile 5 for Pocket PC

  • Windows Mobile 5 for Pocket PC Phone Edition

  • Windows Mobile 5 AKU2

ActiveSync version 4.1 or higher.

Microsoft .NET Compact Framework 1.1 or 2.0

If using JDBC, use either IBMJ9 or the CrEme JDK version 4.1 from NSIcom.com.

  • Windows Mobile 6

  • Windows Mobile 6 Classic

  • Windows Mobile 6 Professional

ActiveSync version 4.5 or higher.

Microsoft .NET Compact Framework 1.1 or 2.0

If using JDBC, use either IBMJ9 or the CrEme JDK version 4.1 from NSIcom.com.

OC4J

Windows Vista Ultimate, Windows XP Professional Edition with Service Pack 2, or Windows 2003

 

Branch Office

Windows XP Professional Edition with Service Pack 2, or Windows 2003

 

You should install all of the patches required for the JDK for the Windows operating system. This is constantly under review and published on the JDK download page on the Sun Microsystems Web site.

2.1.2.2 Supported and Certified Technologies for Windows Mobile Clients

The following are the supported and certified technologies for Mobile clients:

Note:

Ensure that after you install the required software, that they the appropriate directories are included in the PATH. For example, after you install the JDK, ensure that the JAVA_HOME is included in the PATH.

Table 2-3 Supported and Certified Technologies for Windows Mobile Clients

Mobile Client Supported Technologies Certified Technologies

Mobile Client for Win32

  • Sun Microsystems Java Runtime Edition 5.0

  • JDBC 1.2

  • ADO.Net 1.1 – requires Microsoft .Net Framework 1.1 or 2.0

  • ADO.Net 2.0 – requires Microsoft .Net Framework 2.0

  • ODBC 2.0 and 3.5

  • SQL92

 

Mobile Client for Web-to-Go

  • Sun Microsystems Java Runtime Edition 5.0

  • Java Servlets 2.2

  • JDBC 1.2

  • Oracle Java Server Pages Version 9.0.2.0.0

  • Oracle UIX version 2.1.7

  • Oracle XML Parser 9.0.3.0.0

Struts version 1.1 is certified for use with Oracle Database Lite Web-to-Go.

Mobile Client for Windows CE

  • ODBC 2.0 and 3.5

  • JDBC 1.2

  • ADO.Net 1.1 (Requires Microsoft Compact .Net Framework 1.0 + Service Pack 2) or 2.0

  • ADO.Net 2.0 – requires Microsoft .Net Compact Framework 2.0

  • Microsoft ActiveSync version 3.8 or for Windows CE 5.0, use Microsoft ActiveSync version 4.1 or higher.

Oracle Database Lite is certified with the following JVMs on Windows Mobile 2003 Second Edition:

  • IBM J9 Websphere Everyplace Micro Environment for Windows Mobile 2003 ARM Personal Profile

  • Creme JVM 4.1, which can be obtained at http://www.nsicom.com

NOTE: Java Stored Procedures are not supported on Windows CE.

OC4J

  • Sun Microsystems Java Runtime Edition 5.0

  • Java Servlets 2.4

  • JDBC 1.2

  • Oracle Java Server Pages Version 10.1.3.0.0

  • Oracle UIX version 2.2.24

  • Oracle XML Parser 10.1.3.0.0

  • Struts version 1.1

  • JDeveloper 10.1.3

Branch Office

 

Struts version 1.1


2.1.2.3 Supported Platforms for Oracle Database Lite WinCE

Table 2-4 provides the full list of supported platforms for Pocket PC and Windows Mobile:

Table 2-4 Pocket PC and Windows Mobile Supported Platforms

Product Name WinCE Version Chipsets Oracle Lite Client CAB file download from Setup page

Pocket PC 2003 Windows Mobile 2003

4.20.1081

ARMV4

Oracle Lite PPC2003 ARMV4, which uses the <language>\ppc2003\armv4\olite.cab

Windows Mobile 2003 2nd Edition

4.21.1088

ARMV4

Oracle Lite PPC2003 ARMV4, which uses the <language>\ppc2003\armv4\olite.cab

Windows Mobile 5 and Windows Mobile 5 AKU2

5.0 and 5.1.465

ARMV4I

Oracle Lite PPC50 ARMV4I, which uses the <language>\ppc50\armv4i\olite.cab

Windows Mobile 6

5.2.1236

ARMV4I

Oracle Lite PPC60 ARMV4I, which uses the <language>\ppc60\armv4i\olite.cab


If you wish to use Java, mSQL and utilities, you must also install the Tools CAB files after installation of the olite.cab file, which is described in Section 3.2.3, "Installing Tools CAB Files for Java, MSQL, and Utility Support".

2.1.2.4 Windows Mobile Client Notes

For Mobile Client Web-to-Go, Win32, Branch Office and BC4J:

  • Internet Explorer 6.0 is required when using SSL to synchronize with the Mobile Server.

  • The product requires the Microsoft C Runtime Library 7.1 (msvcrt71.dll), which you can download off the Microsoft site or other sites on the Web.

2.2 System Requirements for the Oracle Lite Database as the Mobile Client on Linux

The Mobile Server installation includes the following Mobile Clients for Linux:

Note:

The Device Manager agent (DMagent) must be running to successfully uninstall the Linux Client.

Before you install, you must check to see that you have the requirements necessary for Linux Mobile clients. The requirements for both are detailed in the following sections:

2.2.1 Certified Platforms and Supported Technologies for Linux Mobile Clients

Table 2-5 provides the full list of certified and supported platforms for Linux Mobile clients:

Table 2-5 Certified Platforms and Supported Technologies for Linux Mobile Clients

Mobile Client Certified Platforms Supported Technologies

Oracle Lite Linux Web-to-Go

RedHat Enterprise Linux AS release 4

  • JavaSoft Java Runtime Edition 1.4.2

  • Java Servlets 2.2

  • JDBC 1.2

  • Oracle Java Server Pages Version 9.0.2.0.0

  • Oracle UIX version 2.1.7

  • Oracle XML Parser 9.0.3.0.0

Oracle Lite Linux x86

RedHat Enterprise Linux AS release 4

  • JavaSoft Java Runtime Edition 1.4.2

  • JDBC 1.2

  • ODBC 2.0

  • SQL92


Note for Oracle Lite Linux WEB: Mozilla version 1.7.x is the preferred internet browser on Linux.

2.2.2 Software and Hardware Requirements for the Oracle Lite Database as the Mobile Client on Linux

Table 2-6 provides the software and hardware requirements for Linux Mobile clients:

Table 2-6 Software and Hardware Requirements for Linux Mobile Clients

Mobile Client Hardware Requirement Software Requirements

Mobile Client for Linux Web-to-Go

CPU: Pentium III 360 MHz

Disk Space: 40 MB

RAM: 128 MB

Redhat Enterprise Linux AS Release 4

JDK 1.4.2 must be installed

Mobile Client for Linux x86

CPU: Pentium III 360 MHz

Disk Space: 30 MB

RAM: 128 MB

Redhat Enterprise Linux AS Release 4

JDK 1.4.2 must be installed


2.2.3 Setting Environment Variables Before Installing the Linux Mobile Client

peSet the following environment variables:

  • Set OLITE_HOME to where Oracle Database Lite is installed, such as /home/<user>/olite

  • Set JAVA_HOME to the Java installation directory

  • Add the following to the LD_LIBRARY_PATH

    $JAVA_HOME/jre/lib/i386$JAVA_HOME/jre/lib/i386/server
    $OLITE_HOME/bin
    
  • Add $OLITE_HOME/bin to the PATH