Oracle 10g RAC Startup/Shutdown services on a single node (for maintenance)
Pre-checks
Oracle Home:
ORACLE_HOME=/oracle/app/oracle/product/10.2.0/db_1
CRS Home:
CRS_HOME=/oracle/crs/oracle/product/10/crs/
Executables Location:
/oracle/crs/oracle/product/10/crs/bin
Check the status of Cluster services:
/oracle/crs/oracle/product/10/crs/bin/crs_stat -t
Few commands to check the status of individual cluster services:
For example:
Server name is cd2-db-svr and cd2-db-svr-bck
Database name is TRAX
Instance name is TRAX01 and TRAX02
cd2-db-svr# srvctl status nodeapps -n cd2-db-svr
VIP is running on node: cd2-db-svr
GSD is running on node: cd2-db-svr
Listener is running on node: cd2-db-svr
ONS daemon is running on node: cd2-db-svr
cd2-db-svr# srvctl status asm -n cd2-db-svr
ASM instance +ASM1 is running on node cd2-db-svr
cd2-db-svr# srvctl status database -d TRAX
Instance TRAX01 is running on node cd2-db-svr
Instance TRAX02 is running on node cd2-db-svr-bck
cd2-db-svr# crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
cd2-db-svr# ps -ef|grep d.bin
root 4274 4004 0 Jul 10 ? 8993:18 /oracle/crs/oracle/product/10/crs/bin/crsd.bin reboot
oracle 4221 4217 0 Jul 10 ? 309:20 /oracle/crs/oracle/product/10/crs/bin/evmd.bin
root 4441 4285 0 Jul 10 ? 89:33 /oracle/crs/oracle/product/10/crs/bin/oprocd.bin run -t 1000 -m 500 -f
oracle 4510 4327 0 Jul 10 ? 2731:29 /oracle/crs/oracle/product/10/crs/bin/ocssd.bin
oracle 16846 22996 0 15:03:34 pts/5 0:00 grep d.bin
ps -ef|grep pmon
ps -ef|grep tns
Actual Steps to bring down the services on one node of Oracle 10G RAC cluster
Stop services on node 1(cd2-db-svr)
1. srvctl stop instance -d TRAX -i TRAX01
2. srvctl stop asm -n cd2-db-svr
3. srvctl stop nodeapps -n cd2-db-svr
4. crsctl stop crs
Start services on node 1(cd2-db-svr)
1. crsctl start crs (Ideally all services should come up automatically, if not issue the following steps to bring up the services)
2. srvctl start nodeapps -n cd2-db-svr
3. srvctl start asm -n cd2-db-svr
4. srvctl start instance -d TRAX -i TRAX01
No comments:
Post a Comment