OWB Repository Install on RAC using OMBPlus
There are few documents on MOS to check if OWB is installed correctly on RAC and Exadata (Doc ID 455999.1) and how to install an Warehouse Builder Repository on RAC (Doc ID 459961.1).
To install the OWB repository on RAC using OMBPlus, the steps are:
- Database preparation
- Repository installation on the first node
- Copy of the rtrepos.properties file on all nodes
- Registration of all the other nodes
- Check the installation
Step 1: Database preparation
UNIQUE Service Name
Make sure that EACH Node in the RAC has a UNIQUE service_name. If this is not the case, then add a unique service_name with the following command:
The resulting service name is instn.clusterdomainname. For example, if the instance name is racsrvc1,then the service name could be racsrvc1.us.oracle.com.
"srvctl" can be used to manage the RAC services:
Details are described in the OWB Installation Guide:
Paragraph "Ensuring the Availability of Service Names for Oracle RAC Nodes"
Make sure that EACH Node has the LISTENER configured correctly. The listener on each Node should be able to manage connections to the unique database service of each Node.
Step 2: repository installation on the first node
We assume that RAC has 2 Nodes: NODE1 and NODE2, the database instance is setup and the OWB software has been installed on all Nodes of the RAC.
Start the OMBPlus shell on the primary node say Node 1 from <OWB_HOME>/owb/bin/unix/OMBPlus.sh
Execute the following command
Step 3: copy of the rtrepos.properties file on all nodes
During repository seeding, a file rtrepos.properties is created/updated on Node 1 at location <OWB_HOME>\ owb\bin\admin directory. This file should be copied to all RAC Nodes to the same location. In this case to Node 2 at <OWB_HOME>\ owb\bin\admin.
Step 4: Registration of all the other nodes
After repository installation, all RAC Nodes should be registered. This to enable the OWB Runtime Service to fail over to one of the other Nodes when required (e.g. because of a node crash). This registration process consists of an update in tables OWBRTPS and WB_RT_SERVICE_NODES. These tables will be updated with Node specific details like the Oracle_Home where the OWB software has been installed on the Node and and host, port, service connection details for the instance running on the Node.
Step 5: Check installation
Check the owb home values in the following tables are correct.
Connect as the OWBSYS to the unique service net_service on each node and execute the script located in the <OWB_HOME>\ owb\rtp\sql directory
If the service is not available start the service using the following script
Your installation of the OWB repository is now complete.
You can also use the following OMBplus commands to create a OWB WORKSPACE and workspace owner.
In SQL*Plus as sysdba
Based on blog post: By Anil Menon on Mar 07, 2013