Oracle SOA Suite Online Training

Interested in learning Oracle SOA Suite 12c?
Learn from the author of this blog!
A complete and comprehensive course on the #1 platform on SOA - Oracle SOA Suite

Click here to find the complete course details
Click here to check the first session on Oracle SOA Suite 12c

================================================================================================

Oracle Enterprise Repository Installation - Schema Requirements

Just like any other fusion product installations, OER also needs certain schemas to be in Oracle database prior to installation.

Though we don't have any readymade RCU like in SOA, the schemas required for OER installation are very few, so execute the following commands

Log into Oracle (system or DBA privileges are required).
Create a data tablespace named OER_DATA with at least 300M of available space.
Create an index tablespace named OER_INDEX with at least 300M of available space.

CREATE TABLESPACE OER_DATA
 DATAFILE 'oer_data.dbf' SIZE 100M AUTOEXTEND ON
NEXT 10240K MAXSIZE UNLIMITED
 EXTENT MANAGEMENT LOCAL AUTOALLOCATE
 LOGGING
 ONLINE
 SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE OER_INDEX
 DATAFILE 'oer_index.dbf' SIZE 100M AUTOEXTEND
ON NEXT 5120K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
 LOGGING
 ONLINE
 SEGMENT SPACE MANAGEMENT AUTO;

CREATE USER OER IDENTIFIED BY welcome1
DEFAULT TABLESPACE OER_DATA
 TEMPORARY TABLESPACE TEMP
 PROFILE DEFAULT
 ACCOUNT UNLOCK;
GRANT "CONNECT" TO OER;
ALTER USER OER DEFAULT ROLE "CONNECT", "RESOURCE";
GRANT CREATE MATERIALIZED VIEW TO OER;
GRANT CREATE SEQUENCE TO OER;
GRANT CREATE SESSION TO OER;
GRANT CREATE SYNONYM TO OER;
GRANT CREATE SNAPSHOT TO OER;
GRANT CREATE TABLE TO OER;
GRANT CREATE TRIGGER TO OER;
GRANT CREATE VIEW TO OER;
GRANT UNLIMITED TABLESPACE TO OER;

Once the above sql's are executed, run the installer.
During installation process, one step is to provide the tablespace names. Use the following names
Data : OER_DATA
Blob : OER_DATA
Index : OER_INDEX
Username : OER
Password : welcome1

Hope this helps.

No comments:

Post a comment