RAC manual configuration listening, ASM, and database creation

1. Configure listenera. $ Oracle_HOMEnetworkadminlistener.oraLISTENER1 (DESCRIPTION (ADDRESS (PROTOCOLTCP) (HOSTrac1-vi

1. Configure listenera. $ Oracle_HOME/network/admin/listener. oraLISTENER1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = rac1-vi

1. Configure listener
A. $ Oracle_HOME/network/admin/listener. ora
LISTENER1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = rac1-vip.oracle.com) (PORT = 1521) (IP = FIRST ))
(ADDRESS = (PROTOCOL = TCP) (HOST = rac1.oracle.com) (PORT = 1521) (IP = FIRST ))
)

B. $ ORA_CRS_HOME/crs/public/ora. rac1.LISTENER1. lsnr. cap
NAME = ora. rac1.LISTENER1. lsnr
TYPE = application
ACTION_SCRIPT =/u01/app/oracle/product/10.2.0/db_1/bin/racgwrap
ACTIVE_PLACEMENT = 0
AUTO_START = 1
Check_integer = 600
DESCRIPTION = CRS application for listener on node
FAILOVER_DELAY = 0
FAILURE_INTERVAL = 0
FAILURE_THRESHOLD = 0
HOSTING_MEMBERS = rac1
OPTIONAL_RESOURCES =
PLACEMENT = restricted
REQUIRED_RESOURCES = ora. rac1.vip
RESTART_ATTEMPTS = 5
SCRIPT_TIMEOUT = 600
START_TIMEOUT = 0
STOP_TIMEOUT = 0
UPTIME_THRESHOLD = 7d
USR_ORA_ALERT_NAME =
USR_ORA_CHECK_TIMEOUT = 0
USR_ORA_CONNECT_STR =/as sysdba
USR_ORA_DEBUG = 0
USR_ORA_DISCONNECT = false
USR_ORA_FLAGS =
USR_ORA_IF =
USR_ORA_INST_NOT_SHUTDOWN =
USR_ORA_LANG =
USR_ORA_NETMASK =
USR_ORA_OPEN_MODE =
USR_ORA_OPI = false
USR_ORA_PFILE =

C. crs_register ora. rac1.LISTENER1. lsnr

D. Repeat steps a, B, and c in node 2.

2. Create ASM
A. $ ORACLE_HOME/dbs/init + ASM1.ora
Cluster_database = true
Instance_type = asm
Large_pool_size = 12 m
Background_dump_dest =/u01/app/oracle/admin/+ ASM/bdump
Core_dump_dest =/u01/app/oracle/admin/+ ASM/cdump
User_dump_dest =/u01/app/oracle/admin/+ ASM/udump
Asm_diskgroups = 'data', 'flash'
+ ASM1.instance _ number = 1
+ ASM2.instance _ number = 2

B. export ORACLE_SID = + ASM
Sqlplus/as sysdba
Startup nomount
Create diskgroup DATA external redundancy disk '/dev/raw/raw1'

C. srvctl add asm-n rac1-I + ASM1-o $ ORACLE_HOME-p spfile + ASM1.ora

D. Node 2, repeat a, B, c

3. Create a RAC Database
A. Create a single instance Database

B. alter database add logfile thread 2 group 3 ('+ DATA/RACDB/redo01a. rdo', '+ DATA/RACDB/redo01b. rdo') size 50 M
Alter database add logfile thread 2 group 3 ('+ DATA/RACDB/redo01a. rdo', '+ DATA/RACDB/redo01b. rdo') size 50 M
Create undo tablespace UNDOTBS2 datafile '+ DATA/RACDB/undotbs02.dbf') size 50 M
Alter database enable thread 2

C. initRACDB. ora
Cluster_database = true
Cluster_instances = 2
RACDB1.thread = 1
RACDB2.thread = 2
RACDB1.undo _ tablespace = undotbs1
RACDB2.undo _ tablespace = undotbs2
RACDB1.instance _ number = 1
RACDB2.instance _ number = 2

D. srvctl add database-d RACDB-o/u01/app/oracle/product/10.2.0/db_1-p initRACDB. ora
Srvctl add instance-d RACDB-I RACDB1-n rac1
Srvctl add instance-d RACDB-I RACDB2-n rac2