X

Welcome to All Things Warehouse Builder

OWB Repository Install on RAC using OMBPlus

Anil Menon
Consulting Technical Manager

There are few documents on the Oracle Support site http://support.oracle.com  to check if OWB is installed correctly on RAC and Exadata (Doc
ID 455999.1) and How to Install a Warehouse Builder Repository on a RAC (Doc ID
459961.1).

 This blog will just show you how 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:

srvctl add service -d dbname -s instn -r instn

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:
srvctl [status|stop|start] service -d <db> -s <service-name>

Details are described in the OWB Installation Guide:
Paragraph "Ensuring the Availability of Service Names for Oracle RAC Nodes"

LISTENER Configuration
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

OMB+> OMBSEED DATA_TABLESPACE
'USERS' INDEX_TABLESPACE 'INDX' TEMPORARY_TABLESPACE 'TEMP'
SNAPSHOT_TABLESPACE 'USERS' USING CREDENTIAL
OWBSYS/PASSWORD@hostname:1521:servicename

OWB repository seeding completed.

OMB+> exit

 Step 3: Copy of the rtrepos.properties File on all Nodes

 During the 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 the 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.  

OMB+>OMBINSTALL OWB_RAC USING
CREDENTIAL OWBSYS/OWBSYS@localhost:1521:service_name

RAC instance has beeb
registered.

Step 5: Check the installation

Check the owb home values in the following tables are correct.

Select * from owbsys.owbrtps

Select * from owbsys.wb_rt_service_nodes.

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

SQL>@show_service.sql
Available
PL/SQL procedure successfully completed. 

If the service is not available start the service using the following script

SQL>@start_service.sql
Available

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

create user WORKSPACE_OWNER identified by PASSWORD;

grant resource, connect to WORKSPACE_OWNER;

grant OWB_USER to WORKSPACE_OWNER;

grant create session to WORKSPACE_OWNER;

In OMBPlus

OMB+> OMBINSTALL WORKSPACE 'WORKSPACE_WH' USING CREDENTIAL WORKSPACE_OWNER/PASSWORD@hostname:1521:service_name

Workspace has been created.

OMB+> exit



Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha
Oracle

Integrated Cloud Applications & Platform Services