1/18
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Oracle Database Mobile Server Management
1.1
Using Mobile Manager to Manage Your Mobile Server
1.1.1
Viewing Mobile Servers
1.1.1.1
Mobile Server Home Page
1.1.1.2
Manage Applications
1.1.1.3
Manage Users
1.1.1.4
Mobile Server Administration
1.1.1.5
Data Synchronization
1.1.1.6
Job Scheduler
1.1.2
Viewing Mobile Devices
1.1.2.1
Installed Mobile Devices
1.1.2.2
Mobile Device Platforms
1.2
Manage Mobile Server Farms
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
1.4
Mobile Server Run Time Libraries
2
Managing the Client and Back-End Databases
2.1
Creating and Managing the Database for a Mobile Client
2.2
Connecting to the Back-End Oracle Database
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
Managing 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
Granting Application Access to Users and Groups
3.6.2
Revoking Application Access to Users and Groups
4
Managing Users and Groups
4.1
What Are the Types of Mobile Server Users?
4.1.1
Mobile Server User Privilege: Administrator
4.1.2
Mobile Server User Privilege: Organizer
4.1.3
Mobile Server User Privilege: User
4.2
Guide to Creating User and Administrator Types
4.2.1
Creating a User to Access a Published Application
4.2.2
Creating an Administrator
4.3
Managing Users and Groups
4.3.1
Managing Mobile Server Users
4.3.1.1
Displaying Users
4.3.1.2
Adding New Users
4.3.1.3
Associating Mobile Server Users With Published Applications
4.3.1.4
Duplicating Existing Users
4.3.1.5
Swap Users on a Device
4.3.1.6
Managing OID Users in the Mobile Server
4.3.1.7
Providing Your Own Authentication for a User
4.3.2
Adding New Groups
4.3.3
Deleting Groups or Individual Users
4.4
Managing Access Privileges for Users and Groups
4.4.1
Grant or Revoke Application Access to Users
4.4.1.1
Grant Application Access to Users
4.4.1.2
Revoke Application Access to Users
4.4.2
Include or Exclude Users from Group Based Access
4.4.2.1
Include Users in a Group
4.4.2.2
Exclude Users from a Group
4.4.3
Grant or Revoke Application Access to Groups
4.5
Managing Application Parameter Input (Data Subsetting)
4.6
Manually Adding Devices for a User
4.7
Configuring How the Device Receives 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
Initiate Synchronization of the Mobile Client
5.2.1
Network Options for MSync Tool
5.2.2
Sync Options for MSync Tool
5.2.3
Use Mobile Client Tools on Linux
5.3
User Scenarios for Synchronization
5.4
Managing the Sync Server from the Data Synchronization Home Page
5.4.1
Starting/Stopping the Sync Server
5.4.2
Checking Synchronization Alerts
5.4.3
Managing Sync Sessions
5.4.4
Displaying Operating System (OS) and Java Virtual Machine (JVM) Information
5.5
Using Automatic Synchronization
5.5.1
Specifying Platform Rules for Automatic Synchronization
5.5.2
Start, Stop, or Get Status for Automatic Synchronization
5.5.3
How the Automatic Synchronization Transaction is Retried
5.5.4
Viewing Client-Side Synchronization Conflicts
5.6
Configuring Data Synchronization For Farm or Single Mobile Server
5.7
Resuming an Interrupted Synchronization
5.7.1
Defining Temporary Storage Location for Client Data
5.7.2
Controlling Server Load
5.8
Register a Remote Oracle Database for Application Data
5.8.1
Register or Deregister a Remote Oracle Database for Application Data
5.9
Improving Performance for Multiple Clients that Use the Same Read-Only Data With a Cached User
5.10
Synchronizing to a File With File-Based Sync
5.10.1
Upload Synchronization Transactions to an Encrypted File on the Mobile Client
5.10.2
Apply and Compose Mobile Client Transactions on the Mobile Server
5.10.3
Download Composed Transactions from Mobile Server to the Mobile Client
5.10.4
Troubleshooting File-Based Synchronization Scenarios
5.10.4.1
Normal Network Synchronization Occurs During File Upload
5.10.4.2
Conflict Resolution for File-Based Synchronization
5.11
Managing Trace Settings and Trace Files
5.12
Browsing the Repository for Synchronization Details
5.12.1
Viewing User Information
5.12.2
Viewing Publications
5.12.3
Viewing Publication Items
5.12.4
Viewing Synchronization Queues
5.12.4.1
Viewing Transactions in the In-Queue
5.12.4.2
Viewing Subscriptions in the Out-Queue
5.12.4.3
Viewing Server-Side Synchronization Conflicts and Errors in the Error Queue
5.12.5
Viewing Client-Side Synchronization Conflicts
5.13
Monitoring and Analyzing Performance
5.13.1
Viewing Sync Server Statistics
5.13.2
Displaying MGP Cycles and Statistics
5.13.3
Analyzing Performance of Publications With the Consperf Utility
5.13.4
Monitoring Synchronization Using SQL Scripts
6
Managing Jobs with the 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
Viewing MGP Current Cycle Statistics
6.3.4
Viewing MGP Cycle Statistics
6.3.5
Enabling or Disabling Jobs
6.3.6
Deleting Jobs
6.3.7
Default Jobs
6.3.7.1
MGP_DEFAULT
6.3.7.2
PURGE_HISTORY_DEFAULT
6.4
Managing or Creating Jobs Using ConsolidatorManager APIs
7
Manage Your Devices
7.1
Customize the Mobile Client Software Installation for Your Mobile Device
7.2
Configuring Mobile Clients Before Installation
7.2.1
Modifying Device Management Parameters for Client Device
7.3
Managing Devices
7.3.1
Configuring the Mobile Device through Properties
7.3.1.1
Enabling or Disabling a Mobile Device
7.3.2
Viewing Device Information
7.3.3
Viewing Database Information
7.3.4
Viewing Software Information
7.3.5
Commands
7.3.6
Queue
7.3.7
Command History
7.4
Configuring and Customizing Your Mobile Device Platform
7.4.1
Modifying Platform Properties for Installation
7.4.2
Enabling or Disabling All Mobile Devices in a Platform
7.4.3
Extend or Create a Custom Platform
7.4.3.1
Enable a Platform for Your Mobile Client
7.4.3.2
Create a Custom Platform By Extending an Existing Platform
7.5
Sending Commands to Your Mobile Devices
7.5.1
Scheduling or Sending Commands
7.5.1.1
Sending Commands
7.5.1.2
Scheduling Commands
7.5.2
Modifying Existing Commands
7.5.2.1
Adding Parameters to Mobile Device Commands
7.5.3
Creating New Commands
7.5.4
Creating Group Commands
7.5.5
Enabling or Disabling Mobile Device Commands
7.5.6
Viewing the Mobile Device Command History
7.6
Managing Device Software Updates
7.6.1
Configuring the Device to Receive Required Software Updates
7.6.1.1
Allowing Automatic Software Updates for the Oracle Database Mobile Server Platform
7.6.1.2
Updating Application Software On Each Client
7.6.1.3
Rolling Out Updates With Controlled Upgrade
7.6.2
Configuring Application Software for Automatic Update
7.6.2.1
Configuring Major Software Updates for Download
7.6.2.2
Configuring Patches or Minor Updates for Download
7.6.3
Initiate Updates of Oracle Database Mobile Server Software from the Client
7.7
Using the Device Manager Agent (dmagent) on the Client
7.8
Managing the Network Protocol Between the Device and the Mobile Client Software
7.9
Installation Configuration (INF) File
7.9.1
Setup Information
7.9.2
Properties
7.9.3
Initialization
7.9.4
Including Other INF Files
7.9.5
INSTALL Element
7.9.5.1
DIRECTORY Section
7.9.5.2
FILE Section
7.9.5.3
ENV Section
7.9.5.4
REGISTRY Section
7.9.5.5
ODBC Section
7.9.5.6
LINK Section
7.9.5.7
INI Section
7.9.5.8
EXECUTE Section
7.9.5.9
REGISTER Section
7.10
Defining Device Manager Commands With the Device Manager OTL Tag Language
7.10.1
Device Manager Tag Language Data Types
7.10.1.1
Character
7.10.1.2
Number
7.10.1.3
Integer
7.10.1.4
Long
7.10.1.5
Double
7.10.1.6
Boolean
7.10.1.7
String
7.10.1.8
Array
7.10.1.9
Date Methods
7.10.1.10
Time Methods
7.10.1.11
Enumeration
7.10.1.12
File
7.10.2
Operators That You Can Use With the Device Manager Tag Language
7.10.3
Syntax for the Device Manager Tag Language
7.10.3.1
Initialization Statements
7.10.3.2
Assignment Statements
7.10.4
Conditional Statements
7.10.4.1
If-Else Conditional Statement
7.10.4.2
While Conditional Statement
7.10.4.3
Foreach Conditional Statement
7.10.4.4
Break Statement
7.10.4.5
Choose Statement
7.10.5
Define Custom Functions
7.10.6
Manage the Database Connection
7.10.6.1
Specify Database Connection Information for an Application
7.10.6.2
Disconnect from the Database
7.10.7
Global Classes
7.10.7.1
Methods of the System Class
7.10.7.2
Methods of the DeviceManager Class
7.10.8
Importing Another OTL Page
7.10.9
Error Handling
7.10.10
Sample Device Manager Commands Using the Tag Language
8
Offline Instantiation for Mobile Clients
8.1
Using Offline Instantiation to Distribute Multiple Mobile Clients
8.2
Setting Up the Mobile Server Host and Mobile Development Kit Host
8.3
Downloading the Mobile Client SETUP Executable
8.4
Configure How OLI Creates the Client Distribution Packages With the OLI Configuration File
8.4.1
SETUP
8.4.2
USERS
8.4.3
Example of OLI.INI File
8.5
Using the OLI Engine to Create and Package the Client Distribution File
8.5.1
Create and Populate Client Database Files with the MAKEDB Command
8.5.2
Package the Mobile Client Binaries with the Client Database Files with the PACKAGE Command
8.5.3
Clean Up the OLI Tables Before Executing OLI for Another Distribution
8.5.4
Check the Status of OLI Clients
8.6
Deploying Client Distribution Files on Client Machines
9
Configure Security in Oracle Database Mobile Server
9.1
Security Enhancements
9.2
Which Password is Which?
9.2.1
Modifying Repository Password
9.3
Providing Security for the Mobile Client
9.4
Configuring for Secure Socket Layer (SSL) Communication
9.4.1
Creating an SSL Certificate
9.4.2
Configuring Mobile Server for SSL
9.4.3
Using Packaging Wizard For SSL-Enabled Mobile Server
9.4.4
Troubleshooting Error Messages for an SSL-Enabled Mobile Server
9.4.5
Support for Non-SSL Mobile Clients
9.5
Providing Your Own Authentication Mechanism for Oracle Database Mobile Server
9.6
Using a Firewall Proxy or Reverse Proxy
9.6.1
Using a Reverse Proxy to Communicate from Internet to Intranet
9.6.1.1
Configure the Apache Web Server as a Reverse Proxy
9.6.1.2
Set Up Mobile Server for Mobile Client Download
9.6.1.3
Download Reverse Proxy Mobile Client
9.6.1.4
Enable SSL When Using a Reverse Proxy
9.6.1.5
Configure Device Management to Work With a Firewall
9.6.2
Using HTTP Proxy to Communicate From Inside a Firewall
9.6.2.1
Proxy Configuration for Mobile Clients
9.6.2.2
Proxy Configuration for the Device Manager Agent
9.6.2.3
Reverse Proxy Configuration for HTTP PUSH from Mobile Server Not Supported
9.7
Providing SSL Client Authentication with a Common Access Card
9.7.1
Introduction to SSL Client Authentication
9.7.2
Smartcard and Common Access Card Overview
9.7.3
Oracle Database Mobile Server Supports Common Access Cards
9.7.4
Supported Platforms for the Common Access Card
9.7.4.1
Support for Mobile Clients That Are Not Enabled for Client Authentication
9.7.5
Prerequisites for Common Access Card
9.7.6
Configuration for Client Authentication Using the Common Access Card
9.7.6.1
Configuration of the Mobile Server to Request Client Authentication
9.7.6.2
Configuration of the Mobile Client to Use a CAC
9.7.6.3
Configuration for Reverse Proxy and Load Balancer
9.7.7
Using the Common Access Card
9.8
Security Warning for Demo Applications
10
Reports
10.1
Viewing System Status Reports for the Server
10.2
Viewing Active User Sessions
A
Configuration Files for the Mobile Server
A.1
Configuration Parameters for the MOBILE.ORA File
A.1.1
[APPLICATIONS]
A.1.2
[MOBILE]
A.1.3
[FILESYSTEM]
A.1.4
[DEBUG]
A.1.5
[CONSOLIDATOR]
A.1.5.1
Data Synchronization Parameters
A.1.5.2
Data Synchronoization Tracing and Logging
A.1.6
[EXTERNAL_AUTHENTICATION]
A.2
Data Synchronization Requirements in INIT.ORA
A.2.1
Relationships Between Relevant Parameters
A.2.2
Values for Processes and DML Locks
B
Write Scripts for the Mobile Server With the WSH Tool
B.1
Description of Syntax for WSH Batch Scripts
B.1.1
Creating a User
B.1.1.1
EXTERNALUSER Parameter
B.1.1.2
PRIVILEGE Parameter
B.1.2
Creating a Group
B.1.3
Adding Users to a Group
B.1.4
Removing Users from a Group
B.1.5
Creating Access Privileges
B.1.6
Granting Access
B.1.7
Revoking Access
B.1.8
Creating Registries
B.1.9
Creating Snapshot Variables
B.1.10
Deleting a User
B.1.11
Deleting a Group
B.1.12
Deleting Access Privileges
B.1.13
Deleting a Registry
B.1.14
Deleting Snapshot Variables
B.2
Running a Script INI File With the WSH Tool
B.3
Examples of Batch Script Files for WSH
B.3.1
Creating, Adding, and Granting Access
B.3.2
Deleting, Removing, and Revoking Access
C
Catalog Views for the Mobile Server
C.1
CV$ALL_CLIENTS
C.2
CV$ALL_ERROR
C.3
CV$ALL_PUBLICATIONS
C.4
CV$ALL_SUBSCRIPTIONS
C.5
CV$ALL_SEQUENCES
C.6
CV$ALL_SEQUENCE_PARTITIONS
C.7
CV$ALL_PUBLICATION_ITEMS_ADDED
C.8
CV$ALL_PUBLICATION_ITEMS
C.9
CV$ALL_PUBLICATION_ITEM_INDEXES
C.10
CV.$ALL_SUBSCRIPTION_PARAMS
Glossary
Index
Scripting on this page enhances content navigation, but does not change the content in any way.