Create the Oracle database for MobileFirst Server administration

The installation tools can create the database or user and schema inside an existing for us. Enter the name and password of the Oracle administrator on the database server, and accessible through SSH. Alternatively, the database administrator can create the database or user and schema for you. When we manually create the database or user, we can use database names, user names, and a password of our choice.

Attention: Lowercase characters in Oracle user names can lead to unwanted results.

1. If we do not already have a database named ORCL, use the Oracle Database Configuration Assistant (DBCA) and follow the steps in the wizard to create a new general-purpose database named ORCL:

   1. Use global database name ORCL_domain and system identifier (SID) ORCL.

   2. On the Custom Scripts tab of the step Database Content, do not run the SQL scripts because 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 using either Oracle Database Control or the Oracle SQLPlus command-line interpreter.

   • Use Oracle Database Control.

     1. Connect as SYSDBA.

     2. Go to...
        Security | Users | Server | Users

     3. Create a user, for example WLADMIN.

        To have multiple MobileFirst Server instances connect to your general-purpose database, ORCL_domain, use a different user name for each connection. Each database user has a separate default schema.

     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

   • Use the Oracle SQLPlus command-line interpreter.

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

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

Parent topic: Create administration database (Optional)