Thursday, January 19, 2012

Installing Oracle Service Registry 11g on CentOS 6.2

This post is a how to install Oracle® Fusion Middleware Service Registry 11g (11.1.1)  on Linux CentOS 6.2.

Requirements

Hardware Requirements

  • CPU 1GHz+,  RAM 1 GB+: actual requirements depend on the on usage patterns of the target environment.
  • Free HDD Space ~500MB: enough if the selected database system is installed on another machine. The database server machine must have sufficient space for the selected database system.

Software Requirements

Installation Steps

  1. Create the OSR (Oracle Serice Registry) tablespaces and user:
    1. Create a SQL script archive createdb.sql with the following content (NOTE: assuming you already created the directory /opt/app/oracle/oradata/soagov/):
    2. -- createdb.sql --
      CREATE TABLESPACE uddinode
       LOGGING
       DATAFILE '/opt/app/oracle/oradata/soagov/uddinode.dbf' 
               SIZE 50M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
       DEFAULT STORAGE (
        INITIAL 5M
        NEXT 5M
        MINEXTENTS 1
        MAXEXTENTS UNLIMITED
        PCTINCREASE 50 );
      
      CREATE USER uddiuser
       PROFILE "DEFAULT"
       IDENTIFIED BY "uddiuser"
       DEFAULT TABLESPACE uddinode
       TEMPORARY TABLESPACE "TEMP"
       ACCOUNT UNLOCK;
      GRANT "CONNECT" TO uddiuser;
      GRANT "RESOURCE" TO uddiuser;
      
      GRANT UNLIMITED TABLESPACE TO uddiuser;
      GRANT CREATE ANY SYNONYM TO uddiuser;
      GRANT DROP ANY SYNONYM TO uddiuser;
      
      
    3. Run sqlplus an connect to your SID, soagov in this case:
      1. $ sqlplus sys@soagov AS SYSDBA
        
        embed the SQL file and exit:
        SQL> @createdb.sql
        SQL> exit
        
    4. Test connectivity to the database:
    5. $ sqlplus uddiuser/uddiuser
      
  2. Start the OSR installation. By default, It will start in graphical mode. You can use the -mode option to start it in console or silent mode. Or my preferred one, SSH X11 forwarding:
  3. $ java -jar oracle-service-registry-11.1.1.jar -log=~/OSR_install.log
    
  4. Follow the wizard and choose "Connect to Schema" on the "Database Setup" panel. Provide the credentials written below.

Known issues

3 comments: