For up-to-date product documentation, see the IBM MobileFirst Foundation Developer Center.


Oracle database and user requirements

Review the database requirement for Oracle. Follow the steps to create user, database, and setup your database to meet the specific requirement.


Overview

Ensure that you set the database character set as Unicode character set (AL32UTF8) and the national character set as UTF8 - Unicode 3.0 UTF-8.

The runtime user (as discussed is Database users and privileges) must have an associated table space and enough quota to write the technical data required by the MobileFirst services. For more information about the tables that are used by the product, see Internal runtime databases.

The tables are expected to be created in the default schema of the runtime user. The Ant tasks and the Server Configuration Tool create the tables in the default schema of the user passed as argument. For more information about the creation of tables, see Creating the Oracle database tables manually.

The procedure creates a database if needed. A user that can create tables and index in this database is added and used as a runtime user.


Procedure

  1. If you do not already have a database, use the Oracle Database Configuration Assistant (DBCA) and follow the steps in the wizard to create a new general-purpose database, named ORCL in this example:
    1. Use global database name ORCL_your_domain, and system identifier (SID) ORCL.
    2. On the Custom Scripts tab of the step Database Content, do not run the SQL scripts because we must first create a user account.
    3. On the Character Sets tab of the step Initialization Parameters, select Use Unicode (AL32UTF8) character set and UTF8 - Unicode 3.0 UTF-8 national character set.
    4. Complete the procedure, accepting the default values.
  2. Create a database user by using either Oracle Database Control or the Oracle SQLPlus command line interpreter.
    • Using Oracle Database Control:
      1. Connect as SYSDBA.
      2. Go to the Users page and click Server, then Users in the Security section.
      3. Create a user, for example MFPUSER.
      4. Assign the following attributes:

        • Profile: DEFAULT
        • Authentication: password
        • Default tablespace: USERS
        • Temporary tablespace: TEMP
        • Status: Unlocked
        • Add system privilege: CREATE SESSION
        • Add system privilege: CREATE SEQUENCE
        • Add system privilege: CREATE TABLE
        • Add quota: Unlimited for tablespace USERS
    • Using the Oracle SQLPlus command line interpreter:

      The commands in the following example create a user named MFPUSER for the database:

      CONNECT SYSTEM/<SYSTEM_password>@ORCL CREATE USER MFPUSER IDENTIFIED BY MFPUSER_password DEFAULT TABLESPACE USERS QUOTA UNLIMITED ON USERS; GRANT CREATE SESSION, CREATE SEQUENCE, CREATE TABLE TO MFPUSER; DISCONNECT;

Parent topic: Database requirements