Skip Headers

Oracle® Database Lite Administration and Deployment Guide Release 10.3 Part Number E12089-02 |
Home | Book List | Contents | Index | Contact Us

Previous | Next
| View PDF

# 1 Oracle Database Lite Management With the Mobile Server

Use the Mobile Manager for managing the Mobile Server. In addition, Mobile clients on a Windows platform can use the Mobile Manager for managing Mobile clients with OC4J, Web-to-Go, BC4J, or Branch Office Mobile clients.

Note:

See Oracle Database Lite Client Guide or Oracle Database Lite SQLite Mobile Client Guide for details on how to manage and synchronize each of the Mobile clients—including Linux, WinCE, and Win32—which are not managed using the Mobile Manager.

The Mobile Manager only displays the relevant functionality for the user who logs in. Use the Mobile Manager to manage Mobile applications and its users.

The following sections detail how to use the Mobile Manager.

- Section 1.1, "Using Mobile Manager to Manage Your Mobile Server"

- Section 1.2, "Manage Mobile Server Farms"

- Section 1.3, "Enabling UIX Dynamic Image Generation on UNIX to See Mobile Manager Buttons"

## 1.1 Using Mobile Manager to Manage Your Mobile Server

The Mobile Manager is used to manage the Mobile Server. An administrator is the only user that is able to log on and use the Mobile Manager. To logon to the Mobile Manager, perform the following steps.

1. Using a browser, connect to the Mobile Server by entering the following URL.

   `http://<your_Mobile_Server_host_name>/webtogo`

   As Figure 1-1 displays, the Mobile Server Workspace appears with Mobile Server logon page. The Mobile Server Workspace provides you access to your Mobile applications through hyperlinks in a Web browser. It also includes the Mobile Manager as an option in the applications section.

   Figure 1-1 Logon Page

   Description of "Figure 1-1 Logon Page"

2. Log on to the Mobile Manager with the Mobile Server administrator username and password. A default administrator is created when you install with username/password of `administrator/admin`. Change the default password or create your own administrator user with appropriate username/password.

   Note:

   See Section 4.3.1.2.1, "Define Username and Password" for conventions for creating the username or password.

   As shown in Figure 1-2, the Mobile Server Workspace displays the Mobile Manager in the Applications tab, which is the application available to administrators for managing any Mobile Server.

   Note:

   Section 6.2, "Log on to the Mobile Client Workspace" in the Oracle Database Lite Client Guide describes the functions of each of the tabs at the top of the Mobile Workspace.

   Figure 1-2 Mobile Manager Workspace Page

   Description of "Figure 1-2 Mobile Manager Workspace Page"

3. Click the Mobile Manager icon or link. As Figure 1-3 displays, the Mobile Server farm page appears with a list of installed Mobile Servers that use this repository.

   The Mobile Servers farm page lists all Mobile Servers that are configured to run against the same repository. This page lists Mobile Server information such as Host name, Port, SSL enabled, Up or Down Status, the MGP instance, start time of the instance, and Mobile Server version (see Figure 1-3).

   If a Mobile Server instance is not running (status column displays down), the hyperlink for the host name—where the Mobile Server exists—is not enabled. Refresh this page after a Mobile Server instance is started or stopped by clicking on Mobile Server link to see the updated status for the Mobile Server. Using search criteria based on host name, you can filter the Mobile Server display list for only those servers you are interested in.

   Figure 1-3 Mobile Server Farm Page

   Description of "Figure 1-3 Mobile Server Farm Page"

A Mobile Server farm is a group of Mobile Servers configured to run against the same repository. The Mobile Server farm page contains Mobile Server and Mobile Devices tabs. The following sections describe each component of the Mobile Server Farm:

- Section 1.1.1, "Viewing Mobile Servers"

- Section 1.1.2, "Viewing Mobile Devices"

### 1.1.1 Viewing Mobile Servers

From the Mobile Server farm page, select the Mobile Server on which you want to adminster. This displays the Mobile Server home page for that Mobile Server.

The following sections describe the Mobile Server pages and how you can use them to administer your Mobile Server and its components:

- Section 1.1.1.1, "Mobile Server Home Page"

- Section 1.1.1.2, "Manage Applications"

- Section 1.1.1.3, "Manage Users"

- Section 1.1.1.4, "Mobile Server Administration"

- Section 1.1.1.5, "Data Synchronization"

- Section 1.1.1.6, "Job Scheduler"

#### 1.1.1.1 Mobile Server Home Page

The Mobile Server home page provides a reference to the working status of its components. It displays if the Mobile Server is running or shut down and properties of the database in which the repository resides. When required to lookup current MGP Cycles, In Queue transactions, Out Queue publications, and transactions listed in the Error Queue, use the given links. Alerts are displayed as exceptions and failures for the Synchronization server, MGP, and the Job Scheduler. You use the Mobile Server home page to start or shut down the Synchronization server and the Job Scheduler. You also access these components from this page.

In addition, from this page, you can navigate to display Mobile Server applications, users, and other administrative details by selecting the Applications, Users, or Administration tabs.

The following sections describe information displayed on the Mobile Server home page.

- Section 1.1.1.1.1, "Checking Mobile Server Status"

- Section 1.1.1.1.2, "Viewing Main Database Properties"

- Section 1.1.1.1.3, "Monitoring Data Synchronization"

- Section 1.1.1.1.4, "Tracking Synchronization, MGP, and Job Scheduler Alerts"

- Section 1.1.1.1.5, "Starting or Stopping Mobile Server Components"

##### 1.1.1.1.1 Checking Mobile Server Status

General information such as current Mobile Server status, version, and mode. To lookup if the Mobile Server is running or not, you refer to this section. It also displays general information about the Mobile Server such as current status, version, date and time since it has been running, and installation mode. This information can be used when reporting a problem to Oracle Support.

##### 1.1.1.1.2 Viewing Main Database Properties

Displays properties of the main database in which the Mobile Server repository resides, such as database version, JDBC URL, JDBC Driver, JDBC version, and schema name.

##### 1.1.1.1.3 Monitoring Data Synchronization

Data Synchronization information such as MGP Job status, In Queue, Out Queue, and Error Queue details. See Chapter 5, "Managing Synchronization" for more information on Data Synchronization and the queues.

- To check the status of any of the MGP Job processes, click the Status link that is displayed for the desired MGP Cycle Status. The MGP Cycle page for that MGP Job displays the MGP cycle summary, lists the log tables that have been processed and corresponding dirty record count, and lists MGP Cycle statistics for users.

- The In Queue link displays the number of transactions that are currently present in the In Queue. To lookup these transactions, click the In Queue link. The In Queue transactions page allows you to search for transactions by user and lists current transactions in the In Queue.

- The Out Queue link displays the number of publications that are currently present in the Out Queue. To lookup these publications, click the Out Queue link. The Out Queue page allows you to search for publications by user and lists current publications in the Out Queue. You can also select an Out Queue publication and display the publication items that are associated with it.

- The Error Queue link displays the number of transactions that are currently present in the Out Queue. To lookup these transactions, click the Error Queue link. The Error Queue page also allows you to search for transactions that contain errors by user and lists current transactions in the Error Queue.

##### 1.1.1.1.4 Tracking Synchronization, MGP, and Job Scheduler Alerts

Alert details that describe alert severity and the date and time on which the alert was triggered. Based on the alert severity and the date and time on which the alert was triggered, information displayed in the Alerts table enables you to drill down to the root cause of an error and resolve it accordingly.

Your Mobile Server may encounter the following alerts.

- Synchronization server exceptions

- User synchronization failures

- Job scheduler exceptions

- Job failures

- MGP Job exceptions

- MGP User Apply or Compose failures

To view alert details, select the Alert name and click Check.

##### 1.1.1.1.5 Starting or Stopping Mobile Server Components

The Mobile Server home page provides controls to start and shut down the Synchronization server and the Job Scheduler. It displays the current status of these components and time since they are operating in the current status.

By default, the Data Synchronization server and Job Scheduler are available is running mode. To stop the Data Synchronization server or the Job Scheduler for maintenance or debugging, select the required component and click Stop. The Job Scheduler stops after scheduled jobs have been executed and synchronization sessions have been completed. To restart, select the required component and click Start.

See Chapter 5, "Managing Synchronization" for more information on Data Synchronization. See Chapter 6, "Managing Jobs with the Job Scheduler" for more information on the Job Scheduler.

#### 1.1.1.2 Manage Applications

The Applications page enables the Mobile Server administrator to accomplish the following tasks.

1. Publish applications.

2. Create or edit application properties.

3. Resume, suspend, and delete applications.

4. Grant or revoke application access to users and groups.

5. Create or edit data subsetting parameters.

6. When required, provision Mobile application files for public use.

7. Add WAR files.

See Chapter 3, "Managing Your Mobile Applications" for more information on how to manage your applications.

#### 1.1.1.3 Manage Users

The Users page enables the Mobile Server administrator to manage groups and users and their permissions. See Chapter 4, "Managing Users and Groups" for full details.

#### 1.1.1.4 Mobile Server Administration

Figure 1-4 shows the Administration page that enables the Mobile Server administrator to accomplish the following tasks:

Figure 1-4 Administration Page

Description of "Figure 1-4 Administration Page"

1. View the sessions that are active. See Section 13.2, "Viewing Active User Sessions" for full details.

2. Edit trace settings. See Chapter 3, "Tracing and Logging" in the Oracle Database Lite Troubleshooting and Tuning Guide for full details.

3. Edit the configuration file. We prefer that you modify the configuration using the GUI tool; however, if you decide to edit the `webtogo.ora` file directly, you can access it with this link. See Appendix A, "Configuration Parameters for the WEBTOGO.ORA File" for details on the parameters.

4. Add bookmarks. See Chapter 14, "Adding Popular URLs as Bookmarks to Mobile Server Main Page" for full details.

5. View a summary of the database, JRE, and Operating System. See Section 13.1, "Viewing System Status Reports for the Server" for full details.

6. Upload an SSL certificate. When you are using an SSL connection with a reverse proxy in connection with a Web-to-Go client, you need to upload an SSL certificate. See Section 11.6.1.4, "Enable SSL When Using a Reverse Proxy" for full details.

#### 1.1.1.5 Data Synchronization

When you select this link, you can configure and manage how synchronization occurs.

- Start or stop all synchronization activity for this Mobile Server.

- View the active sessions where synchronization is currently occuring.

- View statistics of previously executed synchronization sessions.

- Execute the Consperf performance tool to evaluate the synchronization performance.

- Modify parameters that affect how synchronization is performed.

- View the activity within the Repository—with each of the queues used for managing synchronization or with the users, publications, and publication items loaded in the repository.

- View all details about the MGP, including statistics, cycles and the Job Scheduler.

#### 1.1.1.6 Job Scheduler

If you click on the Job Scheduler link, you can do the following:

- Start/stop the Job Scheduler

- View, enable, disable or delete any scheduled job.

### 1.1.2 Viewing Mobile Devices

The Mobile devices tab lists all Mobile devices that are registered with any Mobile Server, and are part of the same Mobile Server farm. The following sections briefly describe the functionality available to you in the Mobile Devices tab:

- Section 1.1.2.1, "Installed Mobile Devices"

- Section 1.1.2.2, "Mobile Device Platforms"

For full details on managing your Mobile devices, see Chapter 7, "Manage Your Devices".

#### 1.1.2.1 Installed Mobile Devices

View the installed Mobile device information such as device name, owner, platform, version, and date and time on which it was last accessed. Figure 1-5 displays the Devices page.

Figure 1-5 Devices Page

Description of "Figure 1-5 Devices Page"

To manage the Mobile device, click the Device Name link from the list. For full details on managing your Mobile devices, see Chapter 7, "Manage Your Devices".

#### 1.1.2.2 Mobile Device Platforms

This page lists Mobile device platform information such as platform name, language, enabled, bootstrap, device count, and base platform.

There are hyperlinks that enable you to do the following:

- View device, installed Oracle Database Lite software, back-end database information, what is currently in the command queues, and the logs.

- Extend and manage device platforms—You can extend existing platforms for your own customization—adding other binaries to download or instructions on how to modify the client environment.

- Create commands to be sent to the Mobile device—You can create commands that execute on the device. These commands can start a synchronization, retrieve information, modify the client environment, and many other options.

For full details on managing your Mobile devices, see Chapter 7, "Manage Your Devices".

## 1.2 Manage Mobile Server Farms

When you configure multiple Mobile Servers against a single repository, this is known as a farm.

To enable the Device Manager, Mobile Manager and all of the Mobile clients to work properly in Farms, you need to modify the `webtogo.ora` file on EACH Mobile Server.

Add and enable the following parameter in the `[WEBTOGO]` section of `webtogo.ora` file on all Mobile Servers in the Farm:

`DM_AUTO_SYNC_CACHE=YES`

Then, to enable synchronization for all Mobile Servers in the Farm, perform the tasks described in Section 5.5, "Configuring Data Synchronization For Farm or Single Mobile Server".

## 1.3 Enabling UIX Dynamic Image Generation on UNIX to See Mobile Manager Buttons

UIX generates images dynamically. On UNIX systems, this requires headless Java to be enabled or access to an X server to be enabled for the JVM. If you do not configure one of the following, then you will not see the buttons in the Mobile Manager.

- Section 1.3.1, "Headless Java"

- Section 1.3.2, "X Server Access"

### 1.3.1 Headless Java

Headless Java is only supported in Java 2 version 1.4 and later. In order to avoid X server configuration issues, enable headless operation by setting the Java option: `java.awt.headless` to `true`.

In Mobile Server standalone mode, set the parameter when you start the Mobile Server by modifying the `runmobileserver` script to include the following:

    java -Djava.awt.headless=true -jar oc4j.jar

When deploying to an OC4J instance within the application server, the Java option must be specified within the `opmn.xml` file, as follows:

    <oc4j instanceName="OC4J_Demos" gid="OC4J_Demos">
          <!-- OC4J configuration information here... -->
          <java-option value="-Djava.awt.headless=true "/>
        </oc4j>

After modification, restart OC4J.

### 1.3.2 X Server Access

An accessible X server must be running at the same time as the Mobile Server. To make an X server accessible to the Mobile Server, the X server host grants access to the Mobile Server host through commands, such as `xhost +`. The Mobile Server host configures the `DISPLAY` environment variable to point to the X server, as follows:

    set DISPLAY=<X server machine name>:<X server number>.<screen number>

In Mobile Server standalone mode, set the `DISPLAY` environment variable before starting the Mobile Server.

When deploying to an OC4J instance within the application server, the `DISPLAY` must be specified within the `opmn.xml` file, as follows:

    <oc4j instanceName="OC4J_Demos" gid="OC4J_Demos">
          <!-- OC4J configuration information here... -->
          <environment>
            <prop name="DISPLAY" value="machinename:0.0"/>
          </environment>
        </oc4j>

where `value` is `<machine name or IP address of the XServer>:<display number>`

After modification, restart OC4J.