Create the Oracle databases

The <configureDatabase> Ant task can create databases and users for us. We set the name and password of the Oracle administrator on the database server, and make the account accessible through SSH.

Alternatively, the database administrator can create the databases or users and schemas for us. With manual creation we can set custom database and user names. Note that lowercase characters in Oracle user names can lead to trouble.

Procedure

1. Use the Oracle Database Configuration Assistant (DBCA) to create a new database named ORCL:

   Global database name	ORCL_mydomain
   SID	ORCL

   For the Custom Scripts tab of the step Database Content, do not run the SQL scripts. We must first create a user account.

   On the Character Sets tab of the step Initialization Parameters, select...

   • Unicode (AL32UTF8)
   • UTF8 - Unicode 3.0 UTF-8

   Accept defaults for everthing else.

   For UNIX and Linux machine, set up automatic database restarts. In /etc/oratab, for your database, set Y.

2. Create user for runtime database...

   • Using Oracle Database Control...

     1. Connect as SYSDBA and go to...
        Users | Server Security | Users

     2. Create a user, for example, named WORKLIGHT.

        To have multiple MobileFirst projects to connect to the database created earlier, use a different user name for each connection. Each database user has a separate default schema.

     3. Assign the following attributes:

        Profile	DEFAULT
        Authentication	password
        Default table space	USERS
        Temporary table space	TEMP
        Status	Unlocked
        Add system privilege	CREATE SESSION
        Add system privilege	CREATE SEQUENCE
        Add system privilege	CREATE TABLE
        Add quota	Unlimited for tablespace USERS

     4. Repeat to create other users, for example, WORKLIGHTREPORTS for the MobileFirst report database.

   • Using Oracle SQLPlus command-line interpreter...

     The commands in the following example create a user named WORKLIGHT and a user named WORKLIGHTREPORTS:

     CONNECT SYSTEM/<SYSTEM_password>@ORCL
     CREATE USER WORKLIGHT IDENTIFIED BY 'WORKLIGHT_password' DEFAULT TABLESPACE USERS QUOTA UNLIMITED ON USERS;
     GRANT CREATE SESSION, CREATE SEQUENCE, CREATE TABLE TO WORKLIGHT;
     DISCONNECT;
     CONNECT SYSTEM/<SYSTEM_password>@ORCL
     CREATE USER WORKLIGHTREPORTS IDENTIFIED BY 'WORKLIGHTREPORTS_password' DEFAULT TABLESPACE USERS QUOTA UNLIMITED ON USERS;
     GRANT CREATE SESSION, CREATE SEQUENCE, CREATE TABLE TO WORKLIGHTREPORTS;
     DISCONNECT;

Parent topic: Create databases manually