Oracle Enterprise Repository 11g Installation

Installation

• OER11g comes as a separate installation. It can be installed on an existing SOA/WL 11g.
• Download OER 11g as OER111120_generic.jar
• Execute the following DB scripts

CREATE TABLESPACE OER_SOA1_DATA

DATAFILE '/opt/oracle/oradata/oer/oer_soa1_data.dbf' SIZE 300M

AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED

EXTENT MANAGEMENT LOCAL AUTOALLOCATE

LOGGING

ONLINE

SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE OER_SOA1_INDEX

DATAFILE '/opt/oracle/oradata/oer/oer_soa1_index.dbf' SIZE 300M

AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED

EXTENT MANAGEMENT LOCAL AUTOALLOCATE

LOGGING

ONLINE

SEGMENT SPACE MANAGEMENT AUTO;

CREATE USER OER_SOA1 IDENTIFIED BY password

DEFAULT TABLESPACE OER_SOA1_DATA

TEMPORARY TABLESPACE TEMP

PROFILE DEFAULT

ACCOUNT UNLOCK;

GRANT "CONNECT" TO OER_SOA1;

ALTER USER OER_SOA1 DEFAULT ROLE "CONNECT", "RESOURCE";

GRANT CREATE MATERIALIZED VIEW TO OER_SOA1;

GRANT CREATE SEQUENCE TO OER_SOA1;

GRANT CREATE SESSION TO OER_SOA1;

GRANT CREATE SYNONYM TO OER_SOA1;

GRANT CREATE SNAPSHOT TO OER_SOA1;

GRANT CREATE TABLE TO OER_SOA1;

GRANT CREATE TRIGGER TO OER_SOA1;

GRANT CREATE VIEW TO OER_SOA1;

GRANT UNLIMITED TABLESPACE TO OER_SOA1;

• There are 2 steps involved. First is to install the OER in the middleware/repository111 folder. The second is to create a new domain or extend an existing one with the OER. See below for the steps.
• Run java -jar OER111120_generic.jar This will launch the installation screen. Enter the DB information.
• After installation, create a weblogic domain with OER
• The default port is 7101.
• Note : I could not install this on a SOA Suite. I tried to create a new domain and the installation wizard displays the status of 90% and hangs over there. So I installed a vanilla Weblogic11g and then installed OER on that. This works fine.
• The URL is http://localhost:7101/oer 
• The login is "admin" and "admin"

Note: If you have face an error during the installation you have to clean the tablespace and redo the domain creation/extension process.