Steps to create RAC one node with "dbca" in silent mode
1) runclufy to verify the environment
./runcluvfy.sh stage -pre crsinst
2) Run BBDA to install oracle software and create a regular RAC test DB on node 1 following the procedure provided by the engineering team.
3) Run BBDA to add RAC to node 2 ...n following the procedure provided by the engineering team
4) drop test DB
5) modify .profile_env to add below:
export ADMSCR=/oracle/admin/scripts export DIAG=/oracle/diag alias admscr='cd $ADMSCR'
6) mkdir -p /oracle/admin/scripts/rspfiles
7) admscr;cd rspfiles
8) copy JHTEST01.rsp@lcdre07mpapd1 to <your DB.rsp@your host>
9) modify <your DB.rsp@your host> to reflect your env such as
GDBNAME = "DBATST05.bankofamerica.com"
RACONENODESERVICENAME = DBATST05_SVC_01
SID = "DBATST05" (note the "" is necessary
NODELIST=lcdre07mpapd1,lcdre07npapd1
10) copy cr_JHTEST01_dbca.ksh@lcdre07mpapd1 cr_<your DB>_dbca.ksh and make change of the content to reflect right info
11) copy boa_112_db_asm.dbt@lcdre07mpapd1 to $ORACLE_HOME/assistants/dbca/templates@<your host>
12) admscr;cd rspfiles
export ORACLE_SID=DBATST05
./cr_JHTEST01_dbca.ksh
13) Look at the log file "/oracle/cfgtoollogs/dbca/JHTEST01/JHTEST01.log" for further details.
14) Add instances in /etc/oratab on the corresponding servers of the cluster
such as:
TRODSC01
TRODSC01_1
TRODSC01_2
15) Update remote_listener given that the cluster has been applied listener security patch
alter system set remote_listener='(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCPS)
(HOST=10.40.190.124)(PORT=49147))(ADDRESS=(PROTOCOL=TCPS)
(HOST=10.40.190.125)(PORT=49147))(ADDRESS=(PROTOCOL=TCPS)
(HOST=10.40.190.126)(PORT=49147))(ADDRESS=(PROTOCOL=TCPS)))'
scope=both sid='*';
test remote connection should be successful after the update:
lcdre1d4pdbd1 [TRODSC01_1]-> sqlplus sys@TRODSC01 as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Nov 28 10:42:53 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters and Automatic Storage Management options
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters and Automatic Storage Management options
/oracle/product/11.2.0/db_1/network/admin
16) cage the instance
SQL> alter system set cpu_count=4;
System altered.
SQL> alter system set resource_manager_cpu_allocation=4;
17) Set memory target/memory_max_target /* you won't do this if using huge pages */
18) Create ddl in /oracle/admin/<db_name>/scripts following the standard naming conventions.
19) Run our security scripts:
/oracle/admin/scripts/cr_sec_procs.ksh.jhou
20) Run standard baseline scripts:
/oracle/dba/standard/security/baseline.ksh
21) Change awr retention setting to 45 days:
/oracle/admin/scripts/awr_retention_chg.ksh.jhou
22) Install sqlt by running the following:
/oracle/admin/scripts/install_sqlt.ksh <dbname>
23) Run ESM as dbaroot:
/oracle/dba/ESM/ESMinstall.ksh (reference different procedure from Jesus)
24) add TRODSC01_1 entry to tnsnames.ora which I found RMAN configuration requires it.
25) alter system set audit_sys_operations=true scope=spfile;