Home » Server Options » RAC & Failsafe » Cluster information - crs_stat -t
Cluster information - crs_stat -t [message #255697] Wed, 01 August 2007 09:09 Go to next message
sussudio
Messages: 30
Registered: March 2005
Location: London
Member
Hi guys

I'm trying to get a listing of all the database/instances on the cluster however, when I issue the $crs_stat -t command, it shows the database listings on one node only. For example.

[oracle@node1] crs_stat -t |grep node1
ora....11.inst application ONLINE ONLINE node1
ora....11.inst application ONLINE ONLINE node1
ora....SM1.asm application ONLINE ONLINE node1
ora....70.lsnr application ONLINE ONLINE node1
ora....ER.lsnr application ONLINE ONLINE node1
ora.node1.gsd application ONLINE ONLINE node1
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip application ONLINE ONLINE node1
[oracle@node1]

And when I issue the same command on the second node

[oracle@node1] crs_stat -t |grep node2
ora....12.inst application ONLINE ONLINE node2
ora.DBFST01.db application ONLINE ONLINE node2
ora....12.inst application ONLINE ONLINE node2
ora.DBSST01.db application ONLINE ONLINE node2
ora....SM2.asm application ONLINE ONLINE node2
ora....71.lsnr application ONLINE ONLINE node2
ora....ER.lsnr application ONLINE ONLINE node2
ora.node2.gsd application ONLINE ONLINE node2
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip application ONLINE ONLINE node2
[oracle@node1]

As you can see, the DB info is clearly listed on node2 but not node1. Does anybody know why?

Cheers.

Re: Cluster information - crs_stat -t [message #255726 is a reply to message #255697] Wed, 01 August 2007 10:38 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
check the status of ur db on node1.
Re: Cluster information - crs_stat -t [message #255736 is a reply to message #255726] Wed, 01 August 2007 11:04 Go to previous messageGo to next message
sussudio
Messages: 30
Registered: March 2005
Location: London
Member
The status is fine. There is nothing to suggest any sort of problem... This is why I don't undstand it.
Re: Cluster information - crs_stat -t [message #255914 is a reply to message #255697] Thu, 02 August 2007 06:15 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Since you have ONE database, the DB info is typically listed for the server that is node 0 only.
icon14.gif  Re: Cluster information - crs_stat -t [message #271206 is a reply to message #255697] Sun, 30 September 2007 18:00 Go to previous message
seethem
Messages: 41
Registered: September 2007
Member
As ebrian has said, this is fine.

Basically, you have 1 database and usually more than one instance.
The database is usually attached to one node logically by default.

Previous Topic: Changing ASM redundancy level
Next Topic: Scale up vs Scale out
Goto Forum:
  


Current Time: Sat Aug 30 19:55:59 CDT 2014

Total time taken to generate the page: 0.09235 seconds