Steps to create RAC One Node with dbca in silent mode

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;

Leave a Reply

Your email address will not be published. Required fields are marked *