April 05, 2012

All RAC command without ASM

You can stop and start from node 1 or the other node

Stop Node apps
$ srvctl stop nodeapps -n node_name

Shutdown Instance database
srvctl stop instance -d database_name -i instance_name


Start nodeapps
$ srvctl start nodeapps -n hostname ==> Stop service cluster di node1

Start instance database
srvctl start nodeapps -n djoldb2


Check the cluster status
Cluster status
bash-3.00$ crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy

Database Status
srvctl status database -d instance_name

Check listener status
bash-3.00$ lsnrctl stat

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 13-APR-2011 18:13:02

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production
Start Date 13-APR-2011 13:27:24
Uptime 0 days 4 hr. 45 min. 38 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /oracle/rdbms/product/10.2/network/admin/listener.ora
Listener Log File /oracle/rdbms/product/10.2/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=djoldb1)(PORT=1521)))
Services Summary...
Service "djol" has 3 instance(s).
Instance "djol1", status READY, has 2 handler(s) for this service...
Instance "djol2", status READY, has 1 handler(s) for this service...
Instance "djol2", status READY, has 1 handler(s) for this service...
Service "djolXDB" has 3 instance(s).
Instance "djol1", status READY, has 1 handler(s) for this service...
Instance "djol2", status READY, has 1 handler(s) for this service...
Instance "djol2", status READY, has 1 handler(s) for this service...
Service "djol_XPT" has 3 instance(s).
Instance "djol1", status READY, has 2 handler(s) for this service...
Instance "djol2", status READY, has 1 handler(s) for this service...
Instance "djol2", status READY, has 1 handler(s) for this service...
The command completed successfully


Cek all cluster daemon
bash-3.00$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.djol.db application ONLINE ONLINE djoldb2
ora....l1.inst application ONLINE ONLINE djoldb1
ora....l2.inst application ONLINE ONLINE djoldb2
ora....B1.lsnr application ONLINE ONLINE djoldb1
ora....db1.gsd application ONLINE ONLINE djoldb1
ora....db1.ons application ONLINE ONLINE djoldb1
ora....db1.vip application ONLINE ONLINE djoldb1
ora....B2.lsnr application ONLINE ONLINE djoldb2
ora....db2.gsd application ONLINE ONLINE djoldb2
ora....db2.ons application ONLINE ONLINE djoldb2
ora....db2.vip application ONLINE ONLINE djoldb2


bash-3.00$ srvctl status nodeapps -n djoldb1
VIP is running on node: djoldb1
GSD is running on node: djoldb1
Listener is running on node: djoldb1
ONS daemon is running on node: djoldb1

bash-3.00$ srvctl status nodeapps -n djoldb1
VIP is running on node: djoldb1
GSD is running on node: djoldb1
Listener is running on node: djoldb1
ONS daemon is running on node: djoldb1

bash-3.00$ srvctl status nodeapps -n djoldb2
VIP is running on node: djoldb2
GSD is running on node: djoldb2
Listener is running on node: djoldb2
ONS daemon is running on node: djoldb2


Check all Crs
bash-3.00$ crsctl
Usage: crsctl check crs - checks the viability of the CRS stack
crsctl check cssd - checks the viability of CSS
crsctl check crsd - checks the viability of CRS
crsctl check evmd - checks the viability of EVM

bash-3.00$ crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy

Enjoy Sharing.. :)

No comments:

Post a Comment