Configuring the Oracle database

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

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');

Note The database administrator must open the DB Listener Port to provide access from the Tomcat Server for the application connectivity.