Show TOC

Configuring Oracle to Support MobiliserLocate this document in the navigation structure

To support Mobiliser applications with Oracle on your SAP Mobile Platform Server, make Oracle-specific changes to the dbmaintain script and execute it.

Procedure

  1. Edit the dbmaintain script.
    1. Make a backup copy of <installer_root>\db_tools\db\oracle\smp3\sql\dbmaintain.properties.oracle-<xxx>.
      Where <xxx> is either sid or svc, depending on the connection mode set during Oracle installation.
    2. Use a text editor to open <installer_root>\db_tools\db\oracle\smp3\sql\dbmaintain.properties.oracle-<xxx>.
    3. Enter the location of the JDBC driver that was downloaded for use with SAP Mobile Platform Server.
      Locate this line, and enter the JDBC driver location after the equal sign:
      database.driverLocation=
      Note Use two backslashes to represent each single backslash in the path. For example, for the file C:\temp\ojdb6.jar, enter C:\\temp\\ojdb6.jar.
    4. Replace terms in braces with appropriate values for your system.
      • {HOST} with the host name for your database
      • {PORT} with the port number for your database
      • (DBNAME} with smp3, or if you changed it, the new database name
    5. Save and close the file.
  2. Run the dbmaintain script against your database.
    Note Use Java 8 to run the Java commands described here: either the Java instance that is installed with SAP Mobile Platform Server, or another available instance.
    1. In a command prompt, go to <installer_root>\db_tools\db\oracle\smp3\sql.
    2. Run:

      java -jar com.sybase365.mobiliser.vanilla.standalone-<version>-scriptarchive-oracle.jar -c dbmaintain.properties.oracle-<xxx> -u <dbusername> -p <dbpassword>

      where:
      • <version> is the actual version text in the file name on your system.
      • <xxx> is either sid or svc, depending on the connection mode set during Oracle installation.
      • <dbusername> is the database name, gomobile, or if you changed it from the default, the new name.
      • <dbpassword> is the database password, secret, or if you changed it from the default, the new password.
    3. Run:

      java -jar com.sap.mobile.platform.server.db.oracle.dbmaintain-<version>-scriptarchive-oracle.jar -c dbmaintain.properties.oracle-<xxx> -u <dbusername> -p <dbpassword>

      where:
      • <version> is the actual version text in the file name on your system.
      • <xxx> is either sid or svc, depending on the connection mode set during Oracle installation.
      • <dbusername> is the database name, gomobile, or if you changed it from the default, the new name.
      • <dbpassword> is the database password, secret, or if you changed it from the default, the new password.
    4. When the dbmaintain script has successfully connected to your database, if the dbMaintainer.fromScratch.enabled parameter is true, the script warns you that any existing objects in the database will be dropped if you continue.
      • If this is a fresh installation on a new system, you may safely answer yes to this prompt, and the script continues.
      • To preserve existing objects in your database:
        1. Answer no to the prompt.
        2. Edit this line in the dbmaintain script, replacing true with false:
          dbMaintainer.fromScratch.enabled=true
        3. Re-run the dbmaintain script.
    5. Review the "Dry Run Results" and continue if there are no issues.

      After several minutes, you should see the message The database has been updated successfully.