1/25
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Send Us Your Comments
1
Managing the Mobile Server
1.1
Using the Mobile Workspace
1.2
Using Mobile Manager to Manage Your Mobile Server
1.2.1
Viewing Mobile Servers
1.2.1.1
Mobile Manager Home Page
1.2.1.2
Manage Applications
1.2.1.3
Manage Users
1.2.1.4
Mobile Server Administration
1.2.1.5
Data Synchronization
1.2.1.6
Job Scheduler
1.2.2
Viewing Mobile Devices
1.2.2.1
Installed Mobile Devices
1.2.2.2
Mobile Device Platforms
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
Managing Your Mobile Client
2.1
Start the Mobile Client
2.1.1
Start the Mobile Client
2.1.2
Log on to Mobile Client Workspace
2.2
Synchronize or Execute Applications on the Mobile Client
2.3
Manage the Mobile Client
2.3.1
Use the Mobile Client Workspace to Manage Your Web Clients
2.3.1.1
Instructions for Using the Mobile Workspace
2.3.1.2
Execute Mobile Applications Installed on Your Mobile Client
2.3.1.3
Customize the Mobile Client Workspace
2.3.1.4
Schedule Data Synchronization Jobs
2.3.2
Use the mSync GUI to Initiate Synchronization of Your Linux, WinCE, and Win32 Client/Server Application Clients
2.3.2.1
Use Mobile Client Tools on Linux
2.3.3
Support Network Roaming for Devices With Broadbeam
2.3.4
Reset the Mobile User Password
2.3.5
Use the Device Manager Client GUI to Manage the Client-Side Device
2.3.6
Initiate Updates of Oracle Database Lite Software from the Client
2.3.7
Defragmentation and Reducing Size of the Client Application Databases
2.3.7.1
Execute DefragDB
2.3.7.2
Pause or Cancel Defragmentation
2.3.7.3
Execute DefragDB With Command-Line
2.3.8
Communicate Between the Internet and Intranet Through a Reverse Proxy
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
Manage 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
Grant Application Access to Users and Groups
3.6.2
Revoke 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
Managing Users and Groups
4.1.1
What Are Mobile Server Users?
4.1.1.1
Mobile Server User Privilege: Administrator
4.1.1.2
Mobile Server User Privilege: User
4.1.1.3
Associating Mobile Server Users With Published Applications
4.1.2
Displaying Users
4.1.2.1
Enabling OID Users
4.1.2.2
Searching Group Names or User Names
4.1.3
Adding New Users
4.1.3.1
Define Username and Password
4.1.3.2
Assign Priviledge
4.1.3.3
Specify Device Policy
4.1.4
Duplicating Existing Users
4.1.5
Deleting Groups or Individual Users
4.1.6
Adding New Groups
4.1.7
Managing OID Users in the Mobile Server
4.2
Managing Access Privileges for Users and Groups
4.2.1
Grant or Revoke Application Access to Users
4.2.1.1
Grant Application Access to Users
4.2.1.2
Revoke Application Access to Users
4.2.2
Include or Exclude Users from Group Based Access
4.2.3
Grant or Revoke Application Access to Groups
4.3
Managing Application Parameter Input (Data Subsetting)
4.4
Assigning Application Roles to Users
4.5
Creating an Administrator
4.6
Manually Adding Devices for a User
4.7
Set Update Policy for 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.5
Configuring Data Synchronization For Farm or Single Mobile Server
5.6
Improving Performance for Multiple Clients that Use the Same Read-Only Data With a Cached User
5.7
How Do You Encrypt All Databases for the Initial Sync?
5.7.1
Configuring on the Local Client for Automatic Encryption of Local Snapshots
5.7.2
Configuring on the Server for Automatic Encryption of Local Snapshots
5.8
Managing Trace Settings and Trace Files
5.9
Browsing the Repository for Synchronization Details
5.9.1
Viewing User Information
5.9.2
Viewing Publications
5.9.3
Viewing Publication Items
5.9.4
Viewing Synchronization Queues
5.9.4.1
Viewing Transactions in the In-Queue
5.9.4.2
Viewing Subscriptions in the Out-Queue
5.9.4.3
Viewing Transactions in the Error Queue
5.10
Monitoring and Analyzing Performance
5.10.1
Viewing Sync Server Statistics
5.10.2
Viewing MGP Cycles and Statistics
5.10.3
Analyzing Performance of Publications With the Consperf Utility
5.10.4
Monitoring Synchronization Using SQL Scripts
6
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
Enabling or Disabling Jobs
6.3.4
Deleting Jobs
6.3.5
Default Jobs
6.3.5.1
MGP_DEFAULT
6.3.5.2
PURGE_HISTORY_DEFAULT
6.4
Managing Scheduled Jobs Using ConsolidatorManager APIs
6.4.1
Start Job Scheduler In Separate JVM
6.5
Using the ConsolidatorManager APIs to Create Jobs
7
Manage Your Devices
7.1
Installing the Mobile Client Software on 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 Win32 Parameters for Client Device
7.3
Supporting Network Roaming for Devices With Broadbeam
7.4
Viewing Device Information
7.4.1
Viewing Device Information
7.4.2
Viewing Database Information
7.4.3
Viewing Software Information
7.4.4
Commands
7.4.5
Queue
7.4.6
Command History
7.4.7
Viewing Device Logs
7.5
Configuring and Customizing Your Mobile Device Platform
7.5.1
Modifying Platform Properties for Installation
7.5.2
Enabling or Disabling All Mobile Devices in a Platform
7.5.3
Allowing Software Upgrades to All Mobile Devices in a Platform
7.5.4
Extend or Create a Custom Platform
7.5.4.1
Enable a Platform for Your Mobile Client
7.5.4.2
Create a Custom Platform By Extending an Existing Platform
7.5.4.3
Create a Custom Platform for Unregistered CAB Files
7.6
Configuring Your Mobile Devices
7.6.1
Enabling or Disabling a Mobile Device
7.6.2
Allowing Software Upgrades to the Mobile Device
7.7
Sending Commands to Your Mobile Devices
7.7.1
Scheduling or Sending Commands
7.7.1.1
Sending Commands
7.7.1.2
Scheduling Commands
7.7.2
Modifying Existing Commands
7.7.2.1
Adding Parameters to Mobile Device Commands
7.7.3
Creating New Commands
7.7.4
Creating Group Commands
7.7.5
Enabling or Disabling Mobile Device Commands
7.7.6
Viewing the Mobile Device Command History
7.7.7
Examples of Mobile Commands
7.8
Enabling Device Software Updates
7.8.1
Enabling Major Software Updates for Your Device
7.8.2
Applying Patches or Minor Updates
7.8.3
Controlling Device Software Updates
7.8.3.1
Enabling/Disabling Software Updates for the Oracle Database Lite Platform
7.8.3.2
Updating Application Software On Each Client
7.9
Using the Device Manager Agent (dmagent) on the Client
7.10
Managing the Network Protocol Between the Device and the Mobile Client Software
7.11
Installation Configuration (INF) File
7.11.1
Setup Information
7.11.2
Properties
7.11.3
Initialization
7.11.4
Including Other INF Files
7.11.5
INSTALL Element
7.12
Defining Device Manager Commands With the Device Manager OTL Tag Language
7.12.1
Device Manager Tag Language Data Types
7.12.1.1
Character
7.12.1.2
Number
7.12.1.3
Integer
7.12.1.4
Long
7.12.1.5
Double
7.12.1.6
Boolean
7.12.1.7
String
7.12.1.8
Array
7.12.1.9
Date Methods
7.12.1.10
Time Methods
7.12.1.11
Enumeration
7.12.1.12
File
7.12.2
Operators That You Can Use With the Device Manager Tag Language
7.12.3
Syntax for the Device Manager Tag Language
7.12.3.1
Initialization Statements
7.12.3.2
Assignment Statements
7.12.4
Conditional Statements
7.12.4.1
If-Else Conditional Statement
7.12.4.2
While Conditional Statement
7.12.4.3
Foreach Conditional Statement
7.12.4.4
Break Statement
7.12.4.5
Choose Statement
7.12.5
Define Custom Functions
7.12.6
Manage the Database Connection
7.12.6.1
Specify Database Connection Information for an Application
7.12.6.2
Disconnect from the Database
7.12.7
Global Classes
7.12.7.1
Methods of the System Class
7.12.7.2
Methods of the DeviceManager Class
7.12.8
Importing Another OTL Page
7.12.9
Error Handling
7.12.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
9.1
Using Offline Instantiation to Distribute Multiple Mobile Clients
9.2
Setting Up the Mobile Server Host and Mobile Development Kit Host
9.3
Downloading the Client Binaries Into the Client Root Directory
9.4
The OLI Package Directory
9.5
Configure How OLI Creates the Client Distribution Packages With the OLI Configuration File
9.5.1
SETUP
9.5.2
USERS
9.5.3
Example of OLI.INI File
9.6
Using the OLI Engine to Create and Package the Client Distribution File
9.6.1
Create and Populate Client Database Files with the MAKEODB Command
9.6.2
Package the Mobile Client Binaries with the Client Database Files with the package Command
9.6.3
Clean Up the OLI Tables Before Executing OLI for Another Distribution
9.6.4
Check the Status of OLI Clients
9.7
Deploying Client Distribution Files on Client Machines
9.7.1
Deploy Win32 Native or Web-to-Go Client Distribution Package
9.7.2
Deploy WinCE PocketPC Client Distribution Package
9.8
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.3
Configuring SSL For Mobile Server
11.3.1
Creating an SSL Certificate
11.3.2
Configuring Mobile Server for SSL
11.3.2.1
Configuring SSL for Mobile Server With OracleAS
11.3.2.2
Configuring SSL for Standalone Mobile Server
11.3.3
Enabling SSL Authentication for Web-to-Go Clients
11.3.4
Troubleshooting Error Messages for an SSL-Enabled Mobile Server
11.3.5
Client-Side Configuration for Secure Socket Layer (SSL)
11.3.5.1
Communication between the Mobile Client and the Mobile Server
11.3.5.2
Connection between the Browser and the Mobile Client for OC4J or Web-to-Go
11.3.5.3
Support for Non-SSL Mobile Clients
11.4
Encrypting the Client Oracle Lite Database
11.5
Using a Firewall Proxy or Reverse Proxy
11.5.1
Using Reverse Proxy to Communicate from Internet to Intranet
11.5.1.1
Configure the Apache Web Server as a Reverse Proxy
11.5.1.2
Set Up Mobile Server for Mobile Client Download
11.5.1.3
Download Reverse Proxy Mobile Client
11.5.1.4
Enable SSL When Using a Reverse Proxy
11.5.1.5
Configure Device Management to Work With a Firewall
11.5.2
Using HTTP Proxy to Communicate From Inside a Firewall
11.5.2.1
Proxy Configuration for Web-to-Go Clients
11.5.2.2
Proxy Configuration for All Other Clients
11.5.2.3
Proxy Configuration for the Device Management Agent
11.5.2.4
Reverse Proxy Configuration for HTTP PUSH from Mobile Server Not Supported
11.6
Branch Office Pre-Installation Considerations
11.7
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
Scripting Language for the Mobile Server
B.1
Description of the Syntax
B.2
Running a Script INI File
B.3
Examples
B.3.1
Creating, Adding, and Granting Access
B.3.2
Deleting, Removing, and Revoking Access
C
Data Synchronization Requirements in INIT.ORA
C.1
Relationships Between Relevant Parameters
C.2
Values for Processes and DML Locks
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
D.2.1
ALL_COL_COMMENTS
D.2.2
ALL_CONSTRAINTS
D.2.3
ALL_CONS_COLUMNS
D.2.4
ALL_DEPENDENCIES
D.2.5
ALL_INDEXES
D.2.6
ALL_IND_COLUMNS
D.2.7
ALL_OBJECTS
D.2.8
ALL_PRIVILEGES
D.2.9
ALL_SEQUENCES
D.2.10
ALL_SYNONYMS
D.2.11
ALL_TABLES
D.2.12
ALL_TAB_COLUMNS
D.2.13
ALL_TAB_COMMENTS
D.2.14
ALL_USERS
D.2.15
ALL_VIEWS
D.2.16
POL__ALLOBJ
D.2.17
POL__COLUSAGE
D.2.18
POL__COMMENT
D.2.19
POL__CONS
D.2.20
POL__DATABASE_PARAMETERS
D.2.21
POL__INDICES
D.2.22
POL__INDICESDT
D.2.23
POL__PROCEDURES
D.2.24
POL__PROCEDURE_COLUMNS
D.2.25
POL__SCHEMATA
D.2.26
POL__SEQ
D.2.27
POL__SYNONYM
D.2.28
POL__TBLCONS
D.2.29
POL__TBLUSAGE
D.2.30
POL__TRIGGERS
D.2.31
POL__VIEWS
D.2.32
POL__USERS
E
Using the JDBC Thin Driver
E.1
Upload the Oracle JDBC Driver
E.2
Change the Applet Tag
F
POLITE.INI Parameters
F.1
POLITE.INI File Overview
F.2
All Databases Section
F.2.1
CACHE_SIZE
F.2.2
DATA_DIRECTORY
F.2.3
DATABASE_ID
F.2.4
DB_CHAR_ENCODING
F.2.5
EXTERNAL_ENCRYPTION_DLL
F.2.6
FLUSH_AFTER_WRITE
F.2.7
MAX_INDEX_COLUMNS
F.2.8
MAX_ROWS
F.2.9
MESSAGE_FILE
F.2.10
NLS_DATE_FORMAT
F.2.10.1
Date Format
F.2.10.2
Date Format Examples
F.2.11
NLS_LOCALE
F.2.12
NLS_SORT
F.2.13
OLITE_SERVER_LOG
F.2.14
OLITE_SERVER_TRACE
F.2.15
OLITE_SQL_TRACE
F.2.16
OLITE_WRITE_VERIFY
F.2.17
SQLCOMPATIBILITY
F.2.18
TEMP_DB
F.2.19
TEMP_DIR
F.2.20
SERVICE_PORT
F.2.21
SERVICE_WDIR
F.3
Sync Client Parameters—SYNC Section
F.3.1
Overview of OCAPI—msync Client API
F.3.2
Synchronization Parameters
F.3.2.1
TIME_LOG
F.3.2.2
UPDATE_LOG
F.3.2.3
DEBUG
F.3.2.4
AUTO_COMMIT_COUNT
F.3.2.5
TEMP_DIR
F.3.2.6
RESUME_CLIENT_TIMEOUT
F.3.2.7
RESUME_CLIENT_MAXSEND
F.3.2.8
ERROR_REPORT
F.3.2.9
DB_ENCODING
F.3.2.10
MEM_THRESHOLD
F.3.2.11
VALIDATEDB
F.3.2.12
ENCRYPT_DB
F.3.2.13
SYNC_AGENT
F.3.2.14
SSL_IGNORE_CERT
F.4
Device Management Parameters—DMC Section
F.4.1
DISABLE_PROMPT
F.4.2
PUSH_PORT
F.4.3
UPDATE_DAY and UPDATE_TIME
F.4.4
MAX_RETRY
F.4.5
FREQUENCY
F.5
Network Parameters—NETWORK Section
F.5.1
DISABLE_SSL_CHECK
F.5.2
HTTP_PROXY
F.6
Sample POLITE.INI File
Glossary
Index
Scripting on this page enhances content navigation, but does not change the content in any way.