How to find out all the nodes in an Oracle Cluster

 
Use the olsnodes command to find out all the nodes in an Oracle Cluster.

$ . oraenv
ORACLE_SID = [crs] ? crs
The Oracle base for ORACLE_HOME=/ora/fs0000/crs/oracle/product/clusterware is /ora/fs0000/s00/oracle

oracle : jamespogi1 : @crs : /ora/home
$ olsnodes
jamespogi1
jamespogi2
jamespogi3

If you need more help with database issues, feel free to send me an email (jimmycdo@yahoo.com) and I'll gladly help.

About Jimbart