Translate

Wednesday, 23 May 2012

OBIEE 11.1.1.6 Custom RCU Tool Standalone on Oracle Database

Solutions by Shahed Munir & Krishna Mohan

RCU Tool has been broken down so a RCU can be created via scripts and on a Oracle Database without running the GUI from windows or Linux 32bit Box.

Can be run on Solaris ,Linux 64 Bit or any other platform where you can access sql commands.



There are occasions when the Oracle delivered Repository Creation Utility (RCU) cannot be

used. Examples of this could be – OBIEE installation team may not be able to connect from a windows machine etc.

DBAs might not be able to run a GUI tool due to security policies.

To overcome this situation we have come up with a custom RCU creation script that can be

passed on to a DBA who has the sys access without the need to down load and run the GUI

based RCU.

This set of scripts create the required schemas namely DVBI_BIPLATFORM and DVBI_MDS.

Both the schemas are set with password as ‘abcd’. Follow the below instructions

1. FTP File to Database Server

2. Create a temporary Directory “RCU”

3. Unzip the DVBI_RCU.zip file to within directory above

4. Make sure permissions are ok for above files

5. Connect to sqlplus as sys dba e.g sqlplus sqlplus sys/xxxxx@DBIK23.intra.net AS

SYSDBA

6. At the sql prompt run the below command

@create_users.sql

After the above script is run, make sure the session has exited

Open another session and check that the following users and schemas have been created


User Tablespace


DBVI_BIPLATFORM DVBI_BIPLATFORM

DVBI_MDS DVBI_MDS

RCU_TEMP


Proceed to next step only if the above users and table spaces have been create


1. Connect to sqlplus as sys dba e.g sqlplus sqlplus sys/xxxxx@DBIK23.intra.net AS

SYSDBA

2. At the sql prompt run the below command

@creatercu.sql

Both the scripts above create two log files namely, rcu.log and rcu_users.log in the same

directory as the scripts you unzipped.

Download Working Example scripts from here.

Click here to download a working example

No comments:

Post a Comment

Google Big Query Clone / Copy DataSets / Tables - PROD --> TEST --> DEV Projects

Google Big Query Cloning of Datasets & Tables across GCS Projects. We searched the internet and could not find a simple cloning / ...