Creating an Oracle database

The following steps describe how to manually create an Oracle database for use with Leap.

About this task

To set up an Oracle database:

Procedure

Log into Oracle SQLPlus using the SYS DBA role.
For example, sqlplus / as sysdba.

Create three users.

Each user is mapped to a schema, where Leap will create tables.

ALTER SESSION SET CONTAINER = <Pluggable Database Name>;

CREATE USER FREEDOM IDENTIFIED BY <password>;
CREATE USER IF_CMIS IDENTIFIED BY <password>;
CREATE USER APP_DATA IDENTIFIED BY <password>;

Where <password> is an Oracle accepted password you create.

Create the administrator role.
Leap accesses the Oracle database through a data source. An administrator is required to establish the connection to the database.
```
CREATE USER <admin> IDENTIFIED BY <password>;
```
Where <admin> is an administrator's user name, and <password> is the administrator's password you create.
Set the permissions for the administrative user.
The following commands grant all permissions and privileges so the administrative user can access the database.
```
GRANT ALL PRIVILEGES TO <admin>;
GRANT EXECUTE ANY PROCEDURE TO <admin>;
```

Set table space quotas for the three users of the schemas.

GRANT UNLIMITED TABLESPACE TO FREEDOM;
GRANT UNLIMITED TABLESPACE TO IF_CMIS;
GRANT UNLIMITED TABLESPACE TO APP_DATA;
GRANT UNLIMITED TABLESPACE TO <admin>;

Results

The Oracle database is created.