Skip Headers
Oracle® Database Lite Administration and Deployment Guide
10g (10.0.0)
Part No. B12262-01
  Go To Index
Index

Next
Next
 

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Intended Audience
Documentation Accessibility
Structure

1 Introduction

1.1 What is the Mobile Server
1.2 Concepts and Terminology
1.3 Implementation Tutorial
1.4 Detailed Instructions
1.5 Conventions

2 Getting Started

2.1 The Overall Flow

3 Mobile Manager Overview

3.1 Logging On
3.2 Mobile Manager Overview
3.2.1 Mobile Servers
3.2.1.1 Mobile Manager Home Page
3.2.1.2 Administering Applications
3.2.1.3 Administering Users
3.2.1.4 Mobile Server Administration
3.2.2 Mobile Devices
3.2.2.1 Devices
3.2.2.2 Platforms
3.2.2.3 Administration

4 Administering Mobile Applications

4.1 Overview
4.2 Listing Applications
4.3 Modifying Application Properties
4.4 Suspending Mobile Applications
4.5 Resuming Mobile Applications
4.6 Uploading Applications to the Mobile Server Repository
4.6.1 Creating Database Tables
4.7 Removing Applications from the Mobile Server
4.8 Modifying Data Subsetting Parameters
4.9 Modifying Registry Entries
4.10 Selecting Application Files for Public Use
4.11 Adding Web Application Archive (WAR) Files
4.12 Adding Bookmarks

5 Administering Users

5.1 Overview
5.2 Standalone Mode
5.2.1 Displaying User Groups and Individual Users
5.2.2 Adding New Groups
5.2.3 Adding New Users

6 Provisioning

6.1 Managing Access Privileges
6.1.1 Granting or Revoking Application Access to Users and Groups
6.1.2 Including or Excluding Users from Group Based Access
6.2 Managing Snapshots
6.2.1 Read-only Snapshots
6.2.2 Updatable Snapshots
6.2.3 Refreshing a Snapshot
6.2.4 Snapshot Template Variables

7 Administering the Mobile Server

7.1 Viewing System Status Reports for the Server
7.2 Suspending Applications
7.3 Resuming Applications
7.4 Viewing Active User Sessions

8 Managing Synchronization

8.1 Overview
8.2 The Data Synchronization Manager: An Introduction
8.3 Managing the Sync Service
8.3.1 Starting/Stopping the Sync Service
8.3.2 Checking Sync Service Alerts
8.3.3 Managing Active Sync Sessions
8.3.4 Managing the Session History List
8.3.5 Displaying Operating System (OS) and Java Virtual Machine (JVM) Information
8.4 Monitoring and Analyzing Sync Performance
8.4.1 Viewing Sync Statistics
8.4.2 Analyzing Performance of Publications
8.5 Administering the Synchronization Service
8.5.1 Managing Configuration Parameters
8.5.2 Managing Trace Settings and Trace Files
8.6 Browsing the Sync Repository
8.6.1 Viewing User Information
8.6.2 Viewing Publications
8.6.3 Viewing Publication Items
8.6.4 Viewing Publication Queues
8.7 Scheduling MGP Cycles to Run Inside the Mobile Server
8.8 Running the Message Generator and Processor (MGP) from the Command Line
8.8.1 Overview
8.8.2 MGP Cycles
8.8.3 Configuring MGP
8.9 Monitoring Synchronization Using SQL Scripts
8.9.1 Shared Maps
8.9.2 Synchronization Times for All Clients
8.9.3 Failed Transactions for all Clients
8.9.4 Completely Refreshed Publication Items for all Clients
8.9.5 Publications Flagged for Complete Refresh for All Clients
8.9.6 Clients and Publication where Subscription Parameters are Not Set
8.9.7 Record Counts for Map-based Publication Item by Client
8.9.8 Record Count for Map-based Publication Items by Store
8.9.9 All Client Sequence Partitions and Sequence Values
8.9.10 All Publication Item Indexes

9 Job Scheduler

9.1 Overview
9.2 Managing the Job Engine
9.2.1 Starting the Job Scheduler
9.2.1.1 Stopping the Job Scheduler
9.2.2 Checking Job Scheduler Alerts
9.2.3 Managing Active Jobs
9.2.4 Managing the Job History List
9.3 Administering Scheduled Jobs
9.3.1 Creating a New Job
9.3.2 Editing Existing Jobs
9.3.3 Enabling Jobs
9.3.4 Disabling Jobs
9.3.5 Deleting Jobs
9.3.6 Default Jobs
9.3.6.1 MGP_DEFAULT
9.3.6.2 PURGE_HISTORY_DEFAULT

10 Managing Devices

10.1 Overview and Architecture
10.1.1 Functionality
10.1.2 Terms and Definitions
10.1.3 Architecture
10.1.4 Security
10.1.4.1 Database Security
10.1.4.2 Communication Security
10.1.4.3 Command Execution
10.1.4.4 Database Synchronization Security
10.2 Device Management Client
10.2.1 Device Management Agent
10.2.1.1 Bootstrap Process
10.2.1.2 Configuration Parameters
10.2.1.3 User Interface
10.2.2 Software Update Client
10.2.3 Software Version Checker
10.3 Software Management Client (SMC)
10.3.1 Software Installation
10.3.2 Installation Configuration (INF) File
10.3.2.1 Setup Information
10.3.2.2 Properties
10.3.2.3 Initialization
10.3.2.4 Including Other INF Files
10.3.2.5 INSTALL Element
10.4 Device Management Server
10.4.1 Overview
10.4.2 Mobile Manager
10.4.3 Managing Device Platforms
10.4.3.1 Modifying Platform Properties
10.4.3.2 Creating Custom Platform
10.4.4 Managing Device Commands
10.4.4.1 Modifying Existing Commands
10.4.4.2 Creating New Commands
10.4.4.3 Creating Group Commands
10.4.5 Managing Device Configuration
10.4.5.1 Modifying Client Configuration Items
10.4.5.2 Creating Configuration Items
10.4.6 Managing Network Providers
10.4.6.1 Modifying Network Provider Properties
10.4.6.2 Creating New Network Providers
10.4.7 Administering Devices
10.4.7.1 Modifying Device Properties
10.4.7.2 Viewing Applications
10.4.7.3 Viewing Device Information
10.4.7.4 Scheduling or Sending Commands
10.4.7.5 Viewing Device Logs
10.4.7.6 Viewing the Device Command History

11 Tracing

11.1 Overview
11.2 Setting Trace Parameters
11.2.1 Mobile Server Modes
11.3 Editing the webtogo.ora File
11.4 Running the Mobile Server in Debug Mode

12 Deployment

12.1 Overview
12.2 How To Deploy

13 Deployment: Creating an Install CD for Mobile Clients

13.1 How to Create an Offline CD for Mobile Clients
13.1.1 Downloading the Offline Install Files
13.1.2 Compile the Offline Install Files
13.2 Installing a Mobile Client from the CD

14 Deployment: Using the Mobile Client for Web-to-Go

14.1 Overview
14.2 Installing the Mobile Client for Web-to-Go
14.2.1 Hardware Requirements
14.2.2 Software Requirements
14.2.3 Installation
14.3 Client-Side Configuration for Secure Socket Layer (SSL)
14.3.1 Communication between the Mobile Client and the Mobile Server
14.3.2 Connection between the Browser and the Mobile Client for Web-to-Go
14.4 Support for Non-SSL Mobile Clients

15 Administering and Using the Branch Office

15.1 Introduction
15.1.1 What is the Branch Office?
15.1.2 How the Branch Office Works
15.1.3 The Branch Office Manager
15.1.4 Synchronizing Data with Headquarters
15.2 Branch Office Installation and Configuration
15.2.1 Terms and Concepts
15.2.2 Overview
15.2.3 Branch Office Installation
15.3 Architecture
15.3.1 The Branch Office Environment
15.3.1.1 The Branch Office Client
15.3.1.2 The Branch Office
15.3.1.3 Company Headquarters
15.3.2 Connecting Clients to the Branch Office Database Machine
15.3.2.1 ODBC Connection
15.3.2.2 JDBC Connections
15.4 Administration
15.4.1 Overview
15.4.1.1 Database Service Administration
15.4.1.2 Remote User Maintenance
15.4.2 Logging into the Branch Office Manager
15.4.3 Using the Branch Office Manager
15.4.3.1 Updating Status Summary
15.4.3.2 Starting the Database Service
15.4.3.3 Stopping the Database Service
15.4.3.4 Viewing the Status of the Branch Office Database
15.4.4 Managing Branch Office Users
15.4.4.1 Creating Users
15.4.4.2 Setting User Roles
15.4.4.3 Setting User Properties
15.4.4.4 Setting User Privileges
15.4.4.5 Finding Users
15.4.4.6 Removing a User
15.4.5 Managing Applications
15.4.5.1 Installing Public Files

16 Offline Instantiation

16.1 Overview
16.2 Setting Up the Mobile Server Host and Mobile Development Kit Host
16.3 Setting Up the Mobile Client Root Directory
16.4 Setting Up the Mobile Client (Distribution) Root Directory
16.5 The OLI CD's Directory
16.6 The OLI Configuration File: Oli.ini
16.7 Using the OLI Engine
16.7.1 Using Sub-Commands
16.7.1.1 makeodb
16.7.1.2 package
16.7.1.3 cleanup
16.8 Deploying on Client Machines

17 Configuring SSL For Mobile Server

17.1 Creating an SSL Certificate
17.2 Configuring Mobile Server for SSL
17.2.1 Configuring SSL for Mobile Server With Oracle9iAS or OracleAS
17.2.2 Configuring SSL for Standalone Mobile Server
17.3 Troubleshooting Error Messages for an SSL-Enabled Mobile Server

A Troubleshooting FAQ's

A.1 Inspecting Files in the Mobile Server Repository
A.2 Running the Mobile Server in Debug Mode
A.3 First Synchronization Causes Browser to Timeout
A.4 Accessing the Client Database Offline
A.5 Accessing Schema Changes to a Published Application

B Mobile Server Configuration Parameters

B.1 [WEBTOGO]
B.2 [FILESYSTEM]
B.3 [DEBUG]
B.4 [PUBLIC]
B.5 [SERVLET_PARAMETERS]
B.6 [CONSOLIDATOR]

C Consolidator Requirements in INIT.ORA

C.1 Relationships Between Relevant Parameters
C.2 Values for Processes and DML Locks

D Scripting Language for the Mobile Server

D.1 Description of the Syntax
D.2 Running a Script INI File
D.3 Examples
D.3.1 Creating, Adding, and Granting Access
D.3.2 Deleting, Removing, and Revoking Access

E External Authentication

E.1 Using External Authentication
E.2 External Authentication Code Sample

F Bypassing a Proxy Server

G System Catalog Views

G.1 Mobile Server Catalog Views
G.1.1 "MOBILEADMIN".CV$ALL_CLIENTS
G.1.2 "MOBILEADMIN".CV$ALL_ERROR
G.1.3 "MOBILEADMIN".CV$ALL_PUBLICATIONS
G.1.4 "MOBILEADMIN".CV$ALL_SUBSCRIPTIONS
G.1.5 "MOBILEADMIN".CV$ALL_SEQUENCES
G.1.6 "MOBILEADMIN".CV$ALL_SEQUENCE_PARTITIONS
G.1.7 "MOBILEADMIN".CV$ALL_PUBLICATION_ITEMS_ADDED
G.1.8 "MOBILEADMIN".CV$ALL_PUBLICATION_ITEMS
G.1.9 "MOBILEADMIN.CV$ALL_PUBLICATION_ITEM_INDEXES
G.1.10 " MOBILEADMIN"CV.$ALL_SUBSCRIPTION_PARAMS

H Using the JDBC Thin Driver

H.1 Upload the Oracle JDBC Driver
H.2 Change the Applet Tag

I POLITE.INI Database Parameters

I.1 POLITE.INI File Overview
I.2 POLITE.INI Parameters
I.2.1 CacheSize
I.2.2 Database ID
I.2.3 DBCharEncoding
I.2.4 MAXINDEXCOLUMNS
I.2.5 NLS_DATE_FORMAT
I.2.5.1 Date Format
I.2.5.2 Date Format Examples
I.2.6 NLS_LOCALE
I.2.7 NLS_SORT
I.2.8 ReverseJoinOrder
I.2.9 SharedAddress
I.2.10 SuggestedSharedAddress
I.2.11 SQL Compatibility
I.2.12 TempDB
I.2.13 TempDir
I.2.14 OLITE_SQL_TRACE
I.2.15 FLUSH_AFTER_WRITE
I.3 Sample POLITE.INI File

J The Consolidator Client API (OCAPI)

J.1 Overview
J.2 Sync Client Parameters
J.2.1 TIME_LOG
J.2.2 UPDATE_LOG
J.2.3 COMPRESSION
J.2.4 DEBUG
J.2.5 AUTO_COMMIT_COUNT
J.2.6 TEMP_DIR
J.2.7 RESUME_CLIENT_TIMEOUT
J.2.8 RESUME_CLIENT_MAXSEND
J.2.9 ERROR_REPORT
J.2.10 DB_ENCODING
J.2.11 MEM_THRESHOLD
J.2.12 VALIDATEDB
J.2.13 ENCRYPDB

Glossary

Index