> For the complete documentation index, see [llms.txt](https://docs.cloudio.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.cloudio.io/setting-up-the-cloudio-platform/platform-installation/configuring-the-database/configuring-the-oracle-database.md).

# Configuring the Oracle database

{% hint style="info" %}
To install platform using Oracle database, we need to create the following two schemas:

* xxcloudio for the platform objects
* xxapps for the custom application object
  {% endhint %}

1. Create a database schema xxcloudio for the platform objects and grant appropriate privileges as shown in the script.

```
CREATE USER xxcloudio IDENTIFIED BY xxcloudio
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT QUOTA UNLIMITED ON USERS;

GRANT CREATE JOB TO xxcloudio;
GRANT CREATE MATERIALIZED VIEW TO xxcloudio;
GRANT CREATE PROCEDURE TO xxcloudio;
GRANT CREATE SEQUENCE TO xxcloudio;
GRANT CREATE SESSION TO xxcloudio;
GRANT CREATE SYNONYM TO xxcloudio;
GRANT CREATE TABLE TO xxcloudio;
GRANT CREATE VIEW TO xxcloudio;
GRANT CREATE TRIGGER TO xxcloudio;
GRANT CREATE TYPE TO xxcloudio;
GRANT EXECUTE ON DBMS_LOB TO xxcloudio;
GRANT EXECUTE ON DBMS_SESSION TO xxcloudio;
GRANT EXECUTE ON DBMS_APPLICATION_INFO TO xxcloudio;
GRANT CONNECT TO xxcloudio;
GRANT RESOURCE TO xxcloudio;

ALTER USER xxcloudio DEFAULT ROLE NONE;
```

1. Create a database schema xxapps for custom application objects

   and grant appropriate privileges as shown in the script.

```
CREATE USER xxapps IDENTIFIED BY xxapps
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP 
PROFILE DEFAULT QUOTA UNLIMITED ON USERS;

GRANT CREATE JOB TO xxapps;
GRANT CREATE MATERIALIZED VIEW TO xxapps;
GRANT CREATE PROCEDURE TO xxapps;
GRANT CREATE SEQUENCE TO xxapps;
GRANT CREATE SESSION TO xxapps;
GRANT CREATE SYNONYM TO xxapps;
GRANT CREATE TABLE TO xxapps;
GRANT CREATE VIEW TO xxapps;
GRANT CREATE TRIGGER TO xxapps;
GRANT CREATE TYPE TO xxapps;
GRANT EXECUTE ON DBMS_LOB TO xxapps;
GRANT EXECUTE ON DBMS_SESSION TO xxapps;
GRANT EXECUTE ON DBMS_APPLICATION_INFO TO xxapps;
GRANT CONNECT TO xxapps;
GRANT RESOURCE TO xxapps;

ALTER USER xxapps DEFAULT ROLE NONE;
```

1. If you are using the Oracle EBS 12.2 or above, ensure that the

   XXAPPS schema is enabled. You can enable the schema using the

   following commands:

```
sqlplus "/as sysdba" a
alter session set current_schema=APPS;
exec AD_ZD_PREP.ENABLE_CUSTOM_USER('XXAPPS');
```

{% hint style="info" %}
**Note**\
The database administrator must open the DB Listener Port to  provide access from the Tomcat Server for the application connectivity.
{% endhint %}