There are following RAC basic commands
How to Start and Stop Local Listener and SCAN Listener
First check which services are running from which nodes.
oragrid$ps -eaf|grep tns
———How to set environment if environment is not set———
bash-4.3$ which srvctl
/u02/grid/product/11.2.0/bin/srvctl
bash-4.3$ export PATH=$ORACLE_HOME/bin:$PATH
/u02/grid/product/11.2.0/bin/lsnrctl
–How to STOP Local Listener:- Run this command from one by one all nodes
oragrid$srvctl stop LISTENER -n adupgdb1
oragrid$srvctl stop LISTENER -n oracledb1
oragrid$srvctl stop LISTENER -n oracledb2
–How to STOP SCAN Listener —- Run only from any one node
oragrid$srvctl stop scan_listener
—– How to START Local Listener ——
oragrid$srvctl start LISTENER -n adupgdb1
oragrid$srvctl start LISTENER -n oracledb1
oragrid$srvctl start LISTENER -n oracledb2
—–How to start SCAN Listener ——
oragrid$srvctl start scan_listener
How to bounced Single SCAN Listener one by one on nodes
Run from the grid user.
bash-4.3$ srvctl status scan_listener -i 3
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node adupgdb1
bash-4.3$ srvctl stop scan_listener -i 3
bash-4.3$ srvctl status scan_listener -i 3
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is not running
bash-4.3$ srvctl start scan_listener -i 3
bash-4.3$ srvctl status scan_listener -i 3
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node adupgdb1
11gR2 Clusterware and Grid Home ñ What you need to know [ID 1053147.1] [ POST VIEWS : 15323 ]
1.
Clusterware Resource Status Check
bash-4.3# ./crsctl status resource -t
NAME TARGET STATE SERVER STATE_DETAILS
Local Resources
ora.LISTENER.lsnr
ONLINE ONLINE testdb1
ONLINE ONLINE testdb2
ora.TESTARCH.dg
ONLINE ONLINE testdb1
ONLINE ONLINE testdb2
ora.TESTDATA.dg
ONLINE ONLINE testdb1
ONLINE ONLINE testdb2
ora.TESTDATA1.dg
ONLINE ONLINE testdb1
ONLINE ONLINE testdb2
ora.TEST_VOTE.dg
ONLINE ONLINE testdb1
ONLINE ONLINE testdb2
ora.asm
ONLINE ONLINE testdb1 Started
ONLINE ONLINE testdb2 Started
ora.gsd
OFFLINE OFFLINE testdb1
OFFLINE OFFLINE testdb2
ora.net1.network
ONLINE ONLINE testdb1
ONLINE ONLINE testdb2
ora.ons
ONLINE ONLINE testdb1
ONLINE ONLINE testdb2
Cluster Resources
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE testdb1
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE testdb2
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE testdb2
ora.cvu
1 ONLINE ONLINE testdb2
ora.oc4j
1 OFFLINE OFFLINE
ora.scan1.vip
1 ONLINE ONLINE testdb1
ora.scan2.vip
1 ONLINE ONLINE testdb2
ora.scan3.vip
1 ONLINE ONLINE testdb2
ora.test.db
1 ONLINE ONLINE testdb1 Open
2 ONLINE ONLINE testdb2 Open
ora.testdb1.vip
1 ONLINE ONLINE testdb1
ora.testdb2.vip
1 ONLINE ONLINE testdb2
- STOP A and START A LISTENER
bash-4.3$ srvctl status listener -l LISTENER
Listener LISTENER is enabled
Listener LISTENER is running on node(s): testdb2,testdb1
bash-4.3$ srvctl stop listener -l LISTENER
bash-4.3$ srvctl status listener -l LISTENER
Listener LISTENER is enabled
Listener LISTENER is not running
bash-4.3$ srvctl start listener -l LISTENER
bash-4.3$ srvctl status listener -l LISTENER
Listener LISTENER is enabled
Listener LISTENER is running on node(s): testdb2,testdb1 - stop all the clusterware services/ resources on specific node (including DB and listener) (run as root)
bash-4.3# ./crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ‘testdb1’
CRS-2673: Attempting to stop ‘ora.crsd’ on ‘testdb1’
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on ‘testdb1’
CRS-2673: Attempting to stop ‘ora.LISTENER_SCAN1.lsnr’ on ‘testdb1’
CRS-2673: Attempting to stop ‘ora.LISTENER.lsnr’ on ‘testdb1’
CRS-2673: Attempting to stop ‘ora.TESTARCH.dg’ on ‘testdb1’
CRS-2673: Attempting to stop ‘ora.TEST_VOTE.dg’ on ‘testdb1’
CRS-2673: Attempting to stop ‘ora.test.db’ on ‘testdb1’
CRS-2677: Stop of ‘ora.LISTENER.lsnr’ on ‘testdb1’ succeeded
CRS-2673: Attempting to stop ‘ora.testdb1.vip’ on ‘testdb1’
CRS-2677: Stop of ‘ora.LISTENER_SCAN1.lsnr’ on ‘testdb1’ succeeded
CRS-2673: Attempting to stop ‘ora.scan1.vip’ on ‘testdb1’
CRS-2677: Stop of ‘ora.testdb1.vip’ on ‘testdb1’ succeeded
CRS-2672: Attempting to start ‘ora.testdb1.vip’ on ‘testdb2’
CRS-2677: Stop of ‘ora.scan1.vip’ on ‘testdb1’ succeeded
CRS-2672: Attempting to start ‘ora.scan1.vip’ on ‘testdb2’
CRS-2677: Stop of ‘ora.TESTARCH.dg’ on ‘testdb1’ succeeded
CRS-2676: Start of ‘ora.testdb1.vip’ on ‘testdb2’ succeeded
CRS-2676: Start of ‘ora.scan1.vip’ on ‘testdb2’ succeeded
CRS-2672: Attempting to start ‘ora.LISTENER_SCAN1.lsnr’ on ‘testdb2’
CRS-2677: Stop of ‘ora.test.db’ on ‘testdb1’ succeeded
CRS-2673: Attempting to stop ‘ora.TESTDATA.dg’ on ‘testdb1’
CRS-2673: Attempting to stop ‘ora.TESTDATA1.dg’ on ‘testdb1’
CRS-2677: Stop of ‘ora.TESTDATA1.dg’ on ‘testdb1’ succeeded
CRS-2677: Stop of ‘ora.TESTDATA.dg’ on ‘testdb1’ succeeded
CRS-2676: Start of ‘ora.LISTENER_SCAN1.lsnr’ on ‘testdb2’ succeeded
CRS-2677: Stop of ‘ora.TEST_VOTE.dg’ on ‘testdb1’ succeeded
CRS-2673: Attempting to stop ‘ora.asm’ on ‘testdb1’
CRS-2677: Stop of ‘ora.asm’ on ‘testdb1’ succeeded
CRS-2673: Attempting to stop ‘ora.ons’ on ‘testdb1’
CRS-2677: Stop of ‘ora.ons’ on ‘testdb1’ succeeded
CRS-2673: Attempting to stop ‘ora.net1.network’ on ‘testdb1’
CRS-2677: Stop of ‘ora.net1.network’ on ‘testdb1’ succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on ‘testdb1’ has completed
CRS-2677: Stop of ‘ora.crsd’ on ‘testdb1’ succeeded
CRS-2673: Attempting to stop ‘ora.ctssd’ on ‘testdb1’
CRS-2673: Attempting to stop ‘ora.evmd’ on ‘testdb1’
CRS-2673: Attempting to stop ‘ora.asm’ on ‘testdb1’
CRS-2673: Attempting to stop ‘ora.mdnsd’ on ‘testdb1’
CRS-2677: Stop of ‘ora.ctssd’ on ‘testdb1’ succeeded
CRS-2677: Stop of ‘ora.evmd’ on ‘testdb1’ succeeded
CRS-2677: Stop of ‘ora.mdnsd’ on ‘testdb1’ succeeded
CRS-2677: Stop of ‘ora.asm’ on ‘testdb1’ succeeded
CRS-2673: Attempting to stop ‘ora.cluster_interconnect.haip’ on ‘testdb1’
CRS-2677: Stop of ‘ora.cluster_interconnect.haip’ on ‘testdb1’ succeeded
CRS-2673: Attempting to stop ‘ora.cssd’ on ‘testdb1’
CRS-2677: Stop of ‘ora.cssd’ on ‘testdb1’ succeeded
CRS-2673: Attempting to stop ‘ora.gipcd’ on ‘testdb1’
CRS-2677: Stop of ‘ora.gipcd’ on ‘testdb1’ succeeded
CRS-2673: Attempting to stop ‘ora.gpnpd’ on ‘testdb1’
CRS-2677: Stop of ‘ora.gpnpd’ on ‘testdb1’ succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on ‘testdb1’ has completed
CRS-4133: Oracle High Availability Services has been stopped. - Start all the clusterware services/ resources on specific node (including DB and listener) (run as root)
bash-4.3# ./crsctl start has
CRS-4123: Oracle High Availability Services has been started. - to stop csr services on all nodes of clusterware (run as root)
bash-4.3# ./crsctl stop cluster ñall - to start crs services on all nodes of clusterware (run as root)
bash-4.3# ./crsctl start cluster -all - to check if ohasd is running/ stopped (run as root)
bash-4.3# ./crsctl check has
CRS-4638: Oracle High Availability Services is online - enable Oracle High Availability Services autostart (run as root)
bash-4.3# ./crsctl enable has
CRS-4622: Oracle High Availability Services autostart is enabled. - disable Oracle High Availability Services autostart (run as root)
bash-4.3# ./crsctl disable has
CRS-4621: Oracle High Availability Services autostart is disabled. - check if Oracle High Availability Services autostart is enabled/ disabled (run
bash-4.3# ./crsctl config has
CRS-4622: Oracle High Availability Services autostart is enabled.
11.
Verifying scan status scan_listener
Run this through grid user.
bash-4.3$ ./cluvfy comp scan -verbose
Verifying scan
Checking Single Client Access Name (SCAN)…
SCAN Name Node Running? ListenerName Port Running?
—————- ———— ———— ———— ———— ————
scan-test.seha.ae testdb1 true LISTENER_SCAN1 1521 true
scan-test.seha.ae testdb2 true LISTENER_SCAN2 1521 true
scan-test.seha.ae testdb2 true LISTENER_SCAN3 1521 true
Checking TCP connectivity to SCAN Listeners…
Node ListenerName TCP connectivity?
———— ———————— ————————
testdb1 LISTENER_SCAN1 yes
testdb1 LISTENER_SCAN2 yes
testdb1 LISTENER_SCAN3 yes
TCP connectivity to SCAN Listeners exists on all cluster nodes
Checking name resolution setup for “scan-test.seha.ae”…
SCAN Name IP Address Status Comment
———— ———————— ———————— ———-
scan-test.seha.ae 10.105.22.133 passed
scan-test.seha.ae 10.105.22.132 passed
scan-test.seha.ae 10.105.22.131 passed
Verification of SCAN VIP and Listener setup passed
Verification of scan was successful.
- Verifying scan port
bash-4.3$ srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521
SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1521 - To check the status of services on all nodes
bash-4.3$ srvctl status nodeapps
VIP testdb1_vip is enabled
VIP testdb1_vip is running on node: testdb1
VIP 10.104.21.56 is enabled
VIP 10.104.21.57 is running on node: testdb2
Network is enabled
Network is running on node: testdb1
Network is running on node: testdb2
GSD is disabled
GSD is not running on node: testdb1
GSD is not running on node: testdb2
ONS is enabled
ONS daemon is running on node: testdb1
ONS daemon is running on node: testdb2 - stop all the clusterware services/ resources ON THAT NODE! (run as root)
bash-4.3# ./crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online - Check if Oracle High Availability Services autostart is enabled/ disabled (run as root)
bash-4.3# ./crsctl config has
CRS-4622: Oracle High Availability Services autostart is enabled.
How to Check Clusterware Version and Name
By JAGORACLE on Dec 14, 2011
To check the software versions on a single node. Software version is the lastest version installed in on an cluster.
You would use this option,When you do the rolling upgrade.
$ crsctl query crs softwareversion [hostname]
Active version is lowest version anywhere in the cluster. This is the command you would normally need to use
$ crsctl query crs activeversion
The version of oracle Clusterware must be always greater than the oracle products installed in the clusters
Permanently operating oracle Clusterware (software version vs active version) is not supported.
To check the cluster name use,
$ORA_CRS_HOME/bin/cemutlo -n
bash-4.3# ./crsctl query crs softwareversion testdb1
Oracle Clusterware version on node [testdb1] is [11.2.0.3.0]
bash-4.3# ./crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.3.0]
/u02/appl/product/grid/11.2.0/bin
bash-4.3# ./cemutlo -n
scan-test
How to Start 11g R2 RAC Cluster
There are 2 methods.
Method 1:
1).Start the HAS (High Availability Service) on each node.
$ crsctl start has
2).To Start the Cluster on both the nodes.
$ crsctl start cluster ñall
If OHASD is already running, you can start the Clusterware stack on any node from local node
Method 2:
1).Run the below command on each node. Starts both HAS and CRS
$ crsctl start crs
Noticed that just starting has also starts up the whole stack.
How to START and STOP Database services in Mount and Nomount mode.
[email protected] start database -d TEST -o mount
[email protected] start database -d TEST -o nomount
