# 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 %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.cloudio.io/setting-up-the-cloudio-platform/platform-installation/configuring-the-database/configuring-the-oracle-database.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.