instace oracle rac

thomasliju
thomasliju used Ask the Experts™
on
How we will find that instances are up in oracle rac..
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
The olsnodes command provides the list of nodes and other information for all nodes participating in the cluster.

http://docs.oracle.com/cd/E11882_01/rac.112/e41959/olsnodes.htm#CWADD91126
Commented:
$CRS_HOME or $GRID_HOME/bin/crs_stat -t

you will get something like this:
Name           Type           Target    State     Host
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    rhel1
ora....L1.lsnr application    ONLINE    ONLINE    rhel1
ora....L1.lsnr application    ONLINE    ONLINE    rhel1
ora.rhel1.gsd  application    ONLINE    ONLINE    rhel1
ora.rhel1.ons  application    ONLINE    ONLINE    rhel1
ora.rhel1.vip  application    ONLINE    ONLINE    rhel1
ora....SM2.asm application    ONLINE    ONLINE    rhel2
ora....L2.lsnr application    ONLINE    ONLINE    rhel2
ora....L2.lsnr application    ONLINE    ONLINE    rhel2
ora.rhel2.gsd  application    ONLINE    ONLINE    rhel2
ora.rhel2.ons  application    ONLINE    ONLINE    rhel2
ora.rhel2.vip  application    ONLINE    ONLINE    rhel2

or use srvctl
$GRID_HOME/bin/srvctl
Status of the database, all instances and all services.
srvctl status database -d ORACLE -v

Author

Commented:
Yes helped to find the instances are up,,,

Commented:
Hi,

select instance_name,HOST_NAME from gv$instance.


Br

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial