Setting Up a Custom Oracle Database

If you plan to use Oracle, create and run the smp3.sql script and download the Oracle JDBC driver.

Note: In the steps below, <installer_root> is the root directory in the installer image.

Verify that SAP Mobile Platform supports the version of Oracle you are planning to use.
1. Go to the SAP Product Availability Matrix (PAM) http://service.sap.com/pam. Click the Mobile link at the top of the page. Scroll to find the appropriate product and version in the product list.
2. Under the Essentials heading in the upper right corner, click the "Open in New Window" link to open the Support Matrices... PowerPoint file.
3. Click through to the SAP Note for persistence databases supported by SAP Mobile Platform 3.0.
Install Oracle anywhere on the same network where you will be installing SAP Mobile Platform. Consult with your company's database administrator, or have the database administrator perform the installation for you.
Record the values for these parameters:
- Host name – the host system on which the database software is installed.
- Login – the admin login for the database software.
- Port number – the port number the database software uses.
If you installed Oracle on a different server from the one where you will install SAP Mobile Platform Server, copy the db_tools directory (and all subdirectories) from the SAP Mobile Platform Server installer image to a temporary location on the database server.
In the steps below, <installer_root> will refer to the directory into which you copied db_tools.
Create and run the smp3.sql script.
1. Open a terminal window.
2. In the SAP Mobile Platform installer image, navigate to:
```
<installer_root>/db_tools/db/oracle/smp3/sql
```
3. Use a text editor to create a smp3.sql file in this location.
4. Use a text editor to open 001_SMP3_drop_and_create_user.DDL from this location and copy its entire contents into the smp3.sql file.
5. As the last line in the smp3.sql file, enter:
```
EXIT;
```
6. (Optional) Change user name and password.
  This example shows a contiguous block of the noncomment lines in the 001_SMP3_drop_and_create_user.DDL file for ASE is shown below. Replace:
  - gomobile with the new database user name.
  - secret with the new database user password.
  Be sure to:
  - Refer to your database documentation for limitations on length and allowable characters for these parameters.
  - Replace all instances of each default text string in the 001_SMP3_drop_and_create_user.DDL script with the same value.
  - Make note of the changes you make. You will need to enter the changed values during SAP Mobile Platform Server installation.
  Replace highlighted items below as needed to implement the changes you wish to make.
```
...
DROP USER gomobile CASCADE;
CREATE USER gomobile
    IDENTIFIED BY secret
    DEFAULT TABLESPACE USERS
    TEMPORARY TABLESPACE TEMP
    PROFILE DEFAULT
    ACCOUNT UNLOCK;
    GRANT SY365_OBJOWNER TO gomobile;
    GRANT CREATE SESSION TO gomobile;
    GRANT CONNECT TO gomobile;
    ALTER USER gomobile DEFAULT ROLE ALL;
    ALTER USER gomobile QUOTA UNLIMITED ON USERS;
```
  Note: Oracle does not define a database name as such, and by convention uses the same name for the user and the schema. The SAP Mobile Platform Server installer needs either the Oracle service name or SID to connect to your Oracle database.
7. Save and close smp3.sql.
8. Enter:
```
sqlplus <username>/<password>@<servername> @smp3.sql > smp3.log
```
  Where:
  - <servername> is the server where Oracle is installed.
  - <username> is an admin user, such as sa.
  - <password> is the password for <username>.
(Optional) Configure your Oracle database to support Mobiliser.
See Configuring Oracle to Support Mobiliser.
Download the JDBC driver from oracle.com for the version of Oracle you are using.
The installer will ask you for the path to this driver.
Make a minimum of 25 database connections available for SAP Mobile Platform Server.

Next

Running the Installer