RCU schema silent installs

RCU schema silent installs

Schema can be installed using graphical ui or silent install

Pre-Requisaites
1. Before performing any of the install you should make sure all servers are done and you not connected to schema which you are trying to drop and recreate
2. all schema files are present under RCU_HOME/rcu/integration/soainfra/oracle/
3. Parameters that is required for running command

• databaseType 
• machine name
• db_port
• db_sid
• schema prefix
• component 

example : let us consider dropping and recreting of SOAINFRA schema
file present at RCU_HOME/rcu/integration/soainfra/oracle/createschema_soainfra_oracle.sql

How to Drop a Repository
NOTE: you have to have all password handy

 Drop repro

$RCU_HOME/RCU/bin/rcu -dropRepository -silent -databaseType ORACLE -connectString your machine.com:1521:dbsid.com -dbUser sys -lockSchemas false -dbRole sysdba -schemaPrefix PSNEW -component SOAINFRA

========================Output=========================================   
Output
Processing command line ....
Repository Creation Utility - Checking Prerequisites
Checking Global Prerequisites
Repository Creation Utility - Checking Prerequisites
Checking Component Prerequisites
Repository Creation Utility - Drop
Repository Drop in progress.
Percent Complete: 33
Percent Complete: 30
Percent Complete: 96
Repository Creation Utility: Drop - Completion Summary
Database details:
Host Name                       : yourmachine.com
Port                            : 1521
Service Name                    : dbsid.COM
Connected As                    : sys
Prefix for (prefixable) Schema Owners : PSNEW
RCU Logfile                     : /scratch/test/RCU/rcu/log/logdir.2012-08-21_06-12/rcu.log
Component schemas dropped:
Component                       Status  Logfile
SOA Infrastructure              Success /scratch/test/RCU/rcu/log/logdir.2012-08-21_06-12/soainfra.log
========================================================================

How to create a Repository
NOTE: you have to have all password handy
      
CreateRepo 
 $RCU_HOME/RCU/bin/rcu -createRepository -silent -databaseType ORACLE -connectString your machine.com:1521:dbsid.com -dbUser sys -lockSchemas false -dbRole sysdba -schemaPrefix PSNEW -component SOAINFRA

========================Output=========================================

Processing command line ....
Repository Creation Utility - Checking Prerequisites
Checking Global Prerequisites
The database you are connecting is with non-AL32UTF8 character set. Oracle strongly recommends using AL32UTF8 as the database character set.
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: 7
Percent Complete: 14
Percent Complete: 21
Percent Complete: 21
Percent Complete: 32
Percent Complete: 94
Repository Creation Utility: Create - Completion Summary
Database details:
Host Name                   : yourmachine.com
Port                                : 1521
Service Name                        : db_sid.COM
Connected As                        : sys
Prefix for (prefixable) Schema Owners : PS6NEW
RCU Logfile                 : /scratch/test/RCU/rcu/log/logdir.2012-08-21_06-21/rcu.log
Component schemas created:
Component                   Status  Logfile
SOA Infrastructure          Success /scratch/test/RCU/rcu/log/logdir.2012-08-21_06-21/soainfra.log
Repository Creation Utility - Create : Operation Completed
======================================================================

NOTE: you can pass multiple schema components as below

-component SOAINFRA -component ORASDPM -component MDS -component BAM

Each component before creation asks for passwords

======================================================================
Likely Error usually encountered 

Processing command line ....
Repository Creation Utility - Checking Prerequisites
Checking Global Prerequisites
Repository Creation Utility - Checking Prerequisites
Checking Component Prerequisites
RCU-6092:Component Selection validation failed. Please refer to log at /scratch/test/RCU/rcu/log/logdir.2012-08-21_06-12/rcu.log for details.
RCU-6083:Failed - Check prerequisites requirement for selected component:SOAINFRA
Please refer to RCU log at /scratch/test7June/RCU/rcu/log/logdir.2012-08-21_06-12/rcu.log for details.
The schema owner PSNEW_SOAINFRA is connected to the database. Please disconnect and try again.


Solution : Please disconnect sqlplus from all schema users  and try again