Wednesday, November 28, 2012

ODI_REPO(componentID - ODI) RCU schema creation using 11.1.1.15.0


[oracle@subhen-db09 ~]$ /oracle/source/OFM11gR1/ofm_rcu_linux_11.1.1.5.0/rcuHome/bin/rcu -silent -createRepository -databaseType ORACLE  -connectString  subhen-dbscan.espdev.aurdev.national.com.au:1621:ORCL -dbUser sys -dbRole sysdba -schemaPrefix CIS -component ODI -f < /home/oracle/password_ODI.txt

Processing command line ....
Repository Creation Utility - Checking Prerequisites
Checking Global Prerequisites







Repository Creation Utility - Checking Prerequisites
Checking Component Prerequisites
Repository Creation Utility - Creating Tablespaces
Validating and Creating Tablespaces
Repository Creation Utility - Create
Repository Create in progress.
Percent Complete: 0
Percent Complete: 0
Percent Complete: 10
Percent Complete: 10
Percent Complete: 10
Percent Complete: 50
Percent Complete: 100
Repository Creation Utility: Create - Completion Summary
Database details:
Host Name                       : subhen-dbscan.espdev.aurdev.national.com.au
Port                            : 1621
Service Name                    : ORCL
Connected As                    : sys
Prefix for (prefixable) Schema Owners : CIS
RCU Logfile                     : /oracle/app/logdir.2012-11-29_11-00/rcu.log
Component schemas created:
Component                       Status  Logfile
Master and Work Repository              Success /oracle/app/logdir.2012-11-29_11-00/odi.log

Repository Creation Utility - Create : Operation Completed
[oracle@subhen-db09 ~]$ sleep 2d

[oracle@subhen-db09 ~]$ cat /home/oracle/password_ODI.txt
<sys DB password >
Cis321
001
Cis321
D
001
WORKREP
Cis321
[oracle@subhen-db09 ~]$ sleep 2d

1 comment:

  1. hi,

    Thanks for this article and this is very very useful.
    I am trying to do the same thing in ODI12c. However looks like the sequence of inputs for password_odi.txt file is little different.
    No references in web also is available.
    Could you please help me in pointing to any reference for the same.

    ReplyDelete