Oracle Service Registry OSR 11g Installation

Oracle Service Registry(OSR) is part of the Oracle SOA Governance strategy but comes as a separate download. The installation is 2 steps

1. Installation of OSR files into registry111 folder under oracle middleware home
2. Creation/Extension of a Weblogic 11g domain with the OSR server

Installation Steps

• Execute java -jar oracle-service-registry-11.1.1.jar. This will launch the installation wizard.
• I found it easier to create the tablespace and the schema user before hand. I had to do this as for some reason the installation failed to create the tablespace for me.
• Once the registry111 folder is create then create or extend the existing weblogic11g domain
• If you face any problem during the domain process then cleanup and create the tablespace again.

OER 11g Thoughts

IMHO, the Oracle Enterprise Repository looks like a piece of work from interns(no disrespect to interns). It lacks the enterprise and professional quality that is expected from Oracle, BEA or any other enterprise vendor. This probably is a result of the acquisition and the need to have an extra check in the checklist.

The OER is deployed in the BEA domain. It has 2 parts. One is the the ability to search and view the assets and the second is the ability to manage the assets. The search can be done through the web while the asset management is through a Java Webstart application. Both the applications fall way short of usability.

I am not convinced that both OER and OSR(Oracle Service Registry) are required as they add to the clutter. The OER functionality could be built into the OSR so that the intra enterprise view could be the OER functionality while the extra enterprise view could be the OSR. This will reduce the amount of applications to be purchased, managed and maintained by the enterprises. This will also help in easier adoption of the Governance and in better governance by managing the assets well.

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.