How to Install Metadata Repository for Oracle Infrastructure/Identity Management

Install the Respository Configuration Assistant Software

Prepare the kernel for RepCA:

# su - root

# vi /etc/sysctl.conf

# /sbin/sysctl -p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_max = 262144
kernel.shmmax = 4294967295
kernel.sem = 256 32000 100 142
fs.file-max = 206173
net.ipv4.ip_local_port_range = 1024 65000
kernel.msgmni = 2878
kernel.msgmnb = 65535

Unpack the Software and Install:

# cpio -idmv < as_linux_x86_mrca_101203.cpio

# export DISPLAY=192.168.1.3:0.0
# cd Disk1
# ./runInstaller

Run the root.sh script as root:

# pwd
/u01/app/oracle/product/mrca
# ./root.sh

Update /etc/oratab:

# echo "mrca:/u01/app/oracle/product/mrca:N" >> /etc/oratab
# export ORACLE_SID=mrca
# . oraenv

Prepare the destination database for the installation of the OracleAS Repository:

SQL> alter system set sga_target=600M scope=spfile;
SQL> alter system set pga_aggregate_target=96M scope=spfile;
SQL> alter system set java_pool_size=120M scope=spfile;
SQL> alter system set shared_pool_size=175M scope=spfile;
SQL> alter system set db_cache_size=144M scope=spfile;
SQL> alter system set sessions=400 scope=spfile;

# srvctl stop database -d em
# srvctl start database -d em

If not already present, install Ultrasearch Database Option:

# export ORACLE_SID=em1
# . oraenv
# export DISPLAY=192.168.1.3:0.0
# dbca

Check that all prerequisites for Installing the Metadata Repository Configuration Assistant are met:

# export ORACLE_SID=mrca
# . oraenv
# cd $ORACLE_HOME/repca/prereq

# DBPrereqChecker -DBHOST rac1.colestock.test -DBPORT 1521 -DBNAME em.colestock.test -SYSPWD password -LOGDIR /tmp/
Starting validation DatabasePrerequisite
Validation Succeeded -> DatabasePrerequisite
Validation check complete

Install the Metadata Repository Configuration Assistant:

# cd $ORACLE_HOME
# pwd
/u01/app/oracle/product/mrca
# ./runRepca

Resize any files as prompted:

SQL> alter database datafile '+DATA/em/datafile/undotbs1.261.655668297' resize 600M;
SQL> alter database datafile '+DATA/em/datafile/system.258.655668171' resize 1G;
SQL> alter database datafile '+DATA/em/datafile/undotbs2.260.655668271' resize 750M;

Before Installing the OracleAS Infrastructure/Identity Management you have to address the following bugs:

Bug 5612298 (SEE METALINK - Note:550260.1)

Download Patch 5612298 for HP-UX PA-RISC (64-bit) or HP-UX Itanium

MR schemas and objects will need to be cleaned up within the Database using the MRCA Installation Guide instructions.

Follow instructions in Patch 5612298 readme file:

After the MRCA successful installs, copy the patch ldap.tar to $ORACLE_HOME and extract the ldap.tar file from the $ORACLE_HOME by doing the following steps:

cp ldap.tar $ORACLE_HOME
cd $ORACLE_HOME
tar xvf ldap.tar

Note that the aforementioned note mentions HP-UX as the platform, but this has effected me on Linux as well! Also, it is the MRCA $ORACLE_HOME in which you should unpack this .tar file.

Warning to Have SSO Schema Version at 10.1.4.0.1 During Installation (SEE METALINK - Note:433208.1)

1. Connect to the Oracle Database as SYSDBA and perform the following:

SQL> update orasso.wwc_version$ set version='10.1.4.0.1';
SQL> Commit;

2. Re-start the Oracle Identity Management 10g (10.1.4.0.1) installation

Accomplishing the above will allow for a successful posthumous install of OracleAS Infrastructure/Identity Management...

Labels: Application Servers, Installation