For up-to-date product documentation, see the IBM MobileFirst Foundation Developer Center.
Create the Oracle database tables with the Server Configuration Tool
Use the Server Configuration Tool that is provided with MobileFirst Server installation to create the Oracle database tables.
In Database Selection panel of the Server Configuration Tool, select the Oracle Standard or Enterprise Editions, 11g or 12c option. In the next three panes, enter the database credentials.
When you enter the Oracle user name in Database Additional Settings panel, it must be in uppercase. If you have an Oracle database user (FOO), but you enter a user name with lowercase (foo), the Server Configuration Tool considers it as another user. Unlike other tools for Oracle database, the Server Configuration Tool protects the user name against automatic conversion to uppercase.
The Server Configuration Tool uses a service name or Oracle System Identifier (SID) to identify a database. However, if we want to make the connection to Oracle RAC, you need to enter a complex JDBC URL. In this case, in the Database Settings panel, select the Connect using generic Oracle JDBC URLs option and enter a URL for the Oracle thin driver.
If you need to create database and user for Oracle, use the Oracle Database Creation Assistant (DBCA) tool. For more information, see Oracle database and user requirements.
The Server Configuration Tool can do the same but with a limitation. The tool can create a user for Oracle 11g or Oracle 12g. However, it can create a database only for Oracle 11g, and not for Oracle 12c.
If the database name or user name that is entered in the Database Additional Settings panel does not exist, refer to the following two sections for the extra steps to create the database or the user.
Parent topic: Create the database tables with the Server Configuration Tool
Create the database
Procedure
- Run an SSH server on the computer that runs the Oracle database.
The Server Configuration Tool opens an SSH session to the Oracle host to create the database. Except on Linux and some versions of UNIX systems, the SSH server is needed even if the Oracle database runs on the same computer as the Server Configuration Tool.
- In Database creation request panel, enter the login ID and password of an Oracle database user that has the privileges to create a database.
- In the same panel, also enter the password for the SYS user and the SYSTEM user for the database that is to be created.
Results
A database is created with the SID name that is entered in the Database Additional Settings panel. It is not meant to be used for production.
Create the user
Procedure
- Run an SSH server on the computer that runs the Oracle database.
The Server Configuration Tool opens an SSH session to the Oracle host to create the database. Except on Linux and some versions of UNIX systems, the SSH server is needed even if the Oracle database runs on the same computer as the Server Configuration Tool.
- In the Database Additional Settings panel, enter the login ID and password of the database user that is to be created.
- In Database creation request panel, enter the login ID and password of an Oracle database user that has the privileges to create a database user.
- In same panel, also enter the password for the SYSTEM user of the database.
Results
A database user is created with the name and password that are entered in the Database Additional Settings panel.