ORACLE RAC 11g R2 Commands

This is collection of commands works on 11g R2. I found that lots of command have changed from 11G R1 to 11G R2 so this list can be used to quickly find relevant command.

1. To register a listener in CRS

$srvctl add listener -l LISTENER_TEST1 -p TCP:1521/IPC:LISTENER_TEST1 -o /ora/grid/product/11.2.0.3

2. To start the new listener

$srvctl start listener -l LISTENER_TEST1

3. To register a database with new listener

SQL> sqlplus / as sysdba
connected.
SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_TEST1)))' scope=both;

SQL> show parameter local_listener

4. The most used to command "crs_stat -t" is gone (deprecated) on 11gR2. Instead you

crsctl status resource [the output will be status of all resources]

You can still use the "-t" option to get a tabular report though ;)

crsctl status resource -t

Specify resource name "oracle.mydb.vip" to get the status of any particular resource -

crsctl status resource oracle.mydb.vip

 

 

Deprecated Command	Replacement Commands
crs_stat	crsctl check cluster -all
	crsctl stat res -t
crs_register	crsctl add resource
	crsctl add type
	crsctl modify resource
	crsctl modify type
crs_unregister	crsctl stop resource
	crsctl modify resource resource_name -attr "AUTO_START=never"
crs_start	crsctl start resource
	crsctl start crs
	crsctl start cluster
crs_stop	crsctl stop resource
	crsctl stop crs
	crsctl stop cluster
crs_getperm	crsctl getperm resource
	crsctl getperm type
crs_profile	crsctl add resource
	crsctl add type
	crsctl status resource
	crsctl status type
	crsctl modify resource
	crsctl modify type
crs_relocate	crsctl relocate resource
crs_setperm	crsctl setperm resource
	crsctl setperm type
crsctl check crsd	crsctl check crs
crsctl check cssd	crsctl check css
crsctl check evmd	crsctl check evm
crsctl debug res log resource_name:level	crsctl set log
crsctl set css votedisk	crsctl add css votedisk
	crsctl delete css votedisk
	crsctl query css votedisk
	crsctl replace css votedisk
crsctl start resources	crsctl start resource -all
crsctl stop resources	crsctl stop resource -all