Creating the Oracle database for Application Center

During the installation, the installer can create the Application Center database, except for the Oracle 12c database type, or the user and schema inside an existing database for you.

About this task

The installer can create the database, except for the Oracle 12c database type, or the user and schema inside an existing database if you enter the name and password of the Oracle administrator on the database server, and the account can be accessed through SSH. Otherwise, the database administrator can create the database or user and schema for you. When you manually create the database or user, you can use database names, user names, and a password of your choosing. Note that lowercase characters in Oracle user names can lead to trouble.

Procedure

If you 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_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 you 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.
Create a database user either by using Oracle Database Control, or by using the Oracle SQLPlus command-line interpreter.
- Using Oracle Database Control.
  1. Connect as SYSDBA.
  2. Go to the Users page: click Server, then Users in the Security section.
  3. Create a user, for example, named APPCENTER. If you want multiple instances of IBM MobileFirst™ Platform Server to connect to the same general-purpose database you created in step 1, 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
- Using the Oracle SQLPlus command-line interpreter.
  The commands in the following example create a user named APPCENTER for the database:
```
CONNECT SYSTEM/<SYSTEM_password>@ORCL
CREATE USER APPCENTER IDENTIFIED BY password DEFAULT TABLESPACE USERS QUOTA UNLIMITED ON USERS;
GRANT CREATE SESSION, CREATE SEQUENCE, CREATE TABLE TO APPCENTER;
DISCONNECT;
```