Installing Oracle Enterprise repository 11g

SOA governance has a wide spectrum , OER,OSR , OWSM are the key tools for effective SOA governance. OER provides Visibility into all SOA assets and their relationships to eliminate redundancy, promote reuse, and manage impact of change OER gives a broad view of the various service artifacts and developent in an organization. Unlike OSR , OER can be deployed with latest version of WLS like 10.3.4. Here are the steps to install and make it work.

Download OER from OTN , 11.1.1.5.0

1. Seup Database

Create table space
OER_DATA
OER_LOB
OER_INDEX

Create user OER IDENTIFIED BY OER_PWD

-----------------------------------------------------------------
-- create Table space
drop user OER_SOA1;
drop tablespace OER_SOA1_DATA INCLUDING CONTENTS AND DATAFILES;
drop tablespace OER_SOA1_LOB INCLUDING CONTENTS AND DATAFILES;
drop tablespace OER_SOA1_INDEX INCLUDING CONTENTS AND DATAFILES;

CREATE TABLESPACE OER_DATA
    DATAFILE 'D:/oraclexe/oradata/oer_data.dbf' SIZE 300M
 AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
    EXTENT MANAGEMENT LOCAL AUTOALLOCATE
    LOGGING
    ONLINE
    SEGMENT SPACE MANAGEMENT AUTO;
   
CREATE TABLESPACE OER_LOB
    DATAFILE 'D:/oraclexe/oradata/oer_lob.dbf' SIZE 300M
 AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
    EXTENT MANAGEMENT LOCAL AUTOALLOCATE
    LOGGING
    ONLINE
    SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE OER_INDEX
    DATAFILE 'D:/oraclexe/oradata/oer_index.dbf' SIZE 300M
 AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
    EXTENT MANAGEMENT LOCAL AUTOALLOCATE
    LOGGING
    ONLINE
    SEGMENT SPACE MANAGEMENT AUTO;

---------------------------------------------------------------------
-- create user

CREATE USER OER IDENTIFIED BY OER_PWD DEFAULT TABLESPACE OER_DATA TEMPORARY TABLESPACE TEMP;

GRANT CREATE MATERIALIZED VIEW TO OER;
GRANT CREATE SEQUENCE TO OER;
GRANT CREATE SESSION TO OER;
GRANT CREATE SYNONYM TO OER;
GRANT CREATE TABLE TO OER;
GRANT CREATE TRIGGER TO OER;
GRANT CREATE VIEW TO OER;
GRANT UNLIMITED TABLESPACE TO OER;

2. before running the installer
set path=D:\Oracle\Middleware\home_osb_11g14\jdk160_21\bin;%PATH%

3. cd D:\Softwares\SOA-SW-Latest\OER\ofm_oer_generic_11.1.1.5.0_disk1_1of1
java -jar OER111150_generic.jar

4. specify home as : D:\Oracle\Middleware\home_osb_11g14
This the middleware home where you have WLS 10.3.4 or 10.3.x installed.
OER : D:\Oracle\Middleware\home_osb_11g14\repository111

5. Give server : localhost [This is imp as the server startup will use this server to connect, this can be other server if installed there]
port : 7102 [I used this as i have OSR running on the same port ie 7101]
Reposirory app name : oer

6. configure database :
Provide the table space and user created.
Details : XE DB details
User : OER /OER_PWD
driver file location : need ojdbc6.jar
can find this is soa software , like inside ofm_rcu_win_11.1.1.4.0_disk1_1of1\rcuHome\jdbc\lib

8.After the installation ,  Extend the exixting domain with OER

9. If need to create new domain : oerosbsoa_domain
update WL_LLR_ADMINSERVER
also the table : WL_LLR_OSB_SERVER1 to avoid


Caused By: java.sql.SQLException: JDBC LLR, table verify failed for table 'WL_LLR_OSB_SERVER1', row 'JDBC LLR Domain//Server' record had unexpected value
'soaosb_domain//osb_server1' expected 'soa_osb_oer_domain//osb_server1'*** ONLY the original domain and server that creates an LLR table may access it ***

11. login  to http://localhost:7102/oer/
default : admin/admin

12. istall the OER adapter in Jdev using help-> check for updates
Only after this you will see the option for creating OER connection and setting up the App level settings
- create connection
url : http://localhost:7102/oer
user : admin/welcome1

13. Install the Harvester to Jdev , locate the zip from the  repository111 folder
11.1.1.5.0-OER-Harvester
C:\Oracle\FMW\home11gR1\repository111\core\tools\solutions

14. Import the Harvester-Solution-Pack to OER
11.1.1.5.0-OER-Harvester-Solution-Pack

After this you should be able to harvest the SOA project to OER and start using OER.


Cheers !!