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


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

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

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.