Oracle9i Lite Administration and Deployment Guide
Release 5.0.2 for UNIX Systems
Part No. B10203-01

Contents

List of Figures

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

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 Concepts

2.1 The Mobile Server Environment

2.1.1 Mobile Client

2.1.2 Mobile Server

2.1.3 Database Server

2.2 Synchronization Concepts

2.2.1 Data Synchronization

2.2.2 Synchronizing the Data and Application

2.3 Access Control Management

2.3.1 The Mobile Server Control Center

2.3.2 Web-to-Go Roles

2.4 Tracking Mobile Clients for Web-to-Go Sites

3 Getting Started

3.1 The General Flow

4 Mobile Server Control Center Overview

4.2 Mobile Server Control Center Overview

4.3 Mobile Server Administration Tasks

5 Administering Users

5.2 Standalone Mode

5.2.1 Listing Users and User Groups

5.2.2 Creating a User

5.2.3 Modifying or Dropping a User

5.2.4 Creating a Group

5.2.5 Modifying or Dropping a Group

5.3 Oracle9iAS Mode

5.3.1 Listing and Creating Users and User Groups

5.3.2 Modifying or Dropping a User

5.3.3 Creating a Group

5.3.4 Modifying or Dropping a Group

6 Administering Mobile Applications

6.1 Listing Applications

6.2 Creating Database Tables

6.3 Uploading Applications to the Mobile Server Repository

6.4 Modifying Application Properties

6.5 Removing Applications From the Mobile Server

6.6 Suspending an Application

6.7 Resuming an Application

6.8.1 Granting or Revoking Application Access for Users and Groups

6.8.2 Including Users in or Excluding Users from Group-Level Access

6.8.3 Granting or Revoking Web-to-Go Roles for a User

6.8.4 Granting or Revoking Applications Roles for a Group

6.9 Modifying Data Subsetting Parameters

6.10 Modifying Registry Entries

6.11 Selecting Application Files for Public Use

6.12 Creating System Bookmarks

6.13 Adding Web Application Archive (WAR) Files

7 Administering the Mobile Server

7.1 Viewing System Status Reports for the Server

7.2 Suspending the Server

7.3 Resuming the Server

7.4 Viewing Active User Sessions

7.5 Uploading the SSL Server Certificate to the Mobile Server Repository

7.6 Starting The Message Generator and Processor (MGP)

7.7 Stopping MGP

7.8 Using Server Trace and MGP Trace

8 Administering Web-to-Go Sites

8.1 Listing Sites

8.2 Clearing a Site from the Mobile Server

8.3 Viewing Site Details

9 Administering Synchronization for Branch Office Jobs

9.1 Scheduling Data Synchronization Jobs

9.2 Viewing Scheduled Data Synchronization Jobs

9.3 Creating a New Data Synchronization Job

9.4 Editing a Data Synchronization Job

9.5 Deleting a Data Synchronization Job

10 Administering Replication

10.1 Managing Replication and Snapshots

10.3 Snapshot Template Variables

10.4 The Message Generator and Processor (MGP)

10.4.1 MGP Cycles

10.4.2 Configuring MGP

10.5 Monitoring Synchronization

10.5.1 Synchronization Times for All Clients

10.5.2 Failed Transactions for All Clients

10.5.3 Completely Refreshed Publications Items for All Clients

10.5.4 Publications Flagged for Complete Refresh for All Clients

10.5.5 Clients and Publications where Subscription Parameters Are not Set

10.5.6 Record Counts for Map-Based Publication Items by Client

10.5.7 Record Count for Map-Based Publication Items by Store

10.5.8 All Client Sequence Partitions and Sequence Values

10.5.9 All Publication Item Indexes

11 Tracing

11.2 Turning Trace On and Off on a Running Mobile Server

11.3 Filtering Trace Output by Level

11.4 Filtering Trace Output by User

11.5 Specifying Trace Output Destination

11.6 Configuring the Trace File Pool

11.7 Creating a Trace File for Every User

11.8 Configuring Trace Settings for MGP

12 Deployment

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 Download the Offline Install Files

13.1.2 Compile the Offline Install Files

13.2 Installing Mobile Clients from the CD

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

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

14.5 Using The Workspace

14.6 Logging on to Web-to-Go

14.7 Accessing Applications

14.8 Running Applications

14.9 Configuring the Web-to-Go Workspace

14.9.1 Offline Mode Options

14.10 Configuring Application Settings

14.11 Changing Passwords

14.12 Creating and Editing User Bookmarks

14.12.1 Creating a User Bookmark

14.13 Accessing Bookmarks

14.14 Scheduling Data Synchronization Jobs

14.14.1 Viewing Data Synchronization Jobs

14.14.2 Creating a New Data Synchronization Job

14.14.3 Editing a Data Synchronization Job

14.14.4 Deleting a Data Synchronization Job

14.15 Switching Applications

14.15.1 Downloading Public Files

14.16 Logging off of Web-to-Go

A Troubleshooting FAQs

A.1 Inspecting the Files in the Mobile Server Repository

A.2 Running the Mobile Server in Debug Mode

A.3 First Synchronization Causes Browser to Time out

A.4 Accessing the Client Database Offline

B Mobile Server Configuration Parameters

B.2 [FILESYSTEM]

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 Secure Socket Layer (SSL) Support

D.1 Server-Side Configuration

D.1.1 Mobile Server in Standalone Mode

D.1.2 Oracle9iAS Configuration:

D.1.3 Mobile Server Configuration

D.1.4 Setting up the CA Certificate

D.2 Client-Side Configuration

D.2.1 Communication between the Mobile Client and the Mobile Server

D.2.2 Connection between the Browser and the Mobile Client for Web-to-Go

D.3 Support for Non-SSL Mobile Clients

E Scripting Language for the Mobile Server

E.1 Description of the Syntax

E.2 How to Run a Script INI File

E.3.1 Creating, Adding, and Granting Access

E.3.2 Deleting, Removing, and Revoking Access

F Bypassing a Proxy Server

G External Authentication

G.1 Using External Authentication

G.2 External Authentication Code Sample

H System Catalog Views

H.1 Mobile Server Catalog Views

H.1.1 "MOBILEADMIN".CV$ALL_CLIENTS

H.1.2 "MOBILEADMIN".CV$ALL_ERROR

H.1.3 "MOBILEADMIN".CV$ALL_PUBLICATIONS

H.1.4 "MOBILEADMIN".CV$ALL_SUBSCRIPTIONS

H.1.5 "MOBILEADMIN".CV$ALL_SEQUENCES

H.1.6 "MOBILEADMIN".CV$ALL_SEQUENCE_PARTITIONS

H.1.7 "MOBILEADMIN".CV$ALL_PUBLICATION_ITEMS_ADDED

H.1.8 "MOBILEADMIN".CV$ALL_PUBLICATION_ITEMS

H.1.9 "MOBILEADMIN".CV$ALL_PUBLICATION_INDEXES

H.1.10 "MOBILEADMIN".CV$ALL_SUBSCRIPTION_PARAMS

I
Using the JDBC Thin Driver

I.1 Upload Oracle JDBC Driver

I.2 Change the Applet Tag

J
Consolidator Performance (Consperf) Utility

J.2 Generating Timing Statistics for Publications

J.3 Generating Explain Plans for Publications

J.4 Automatically Tuning Publication Properties

J.5 Analyzing Mobile Server Objects for Cost Based Optimizer

J.6 Usage Model

J.7 Consperf Parameters

Glossary

Index

Copyright © 2002 Oracle Corporation
All rights reserved