Home » Server Options » RAC & Failsafe » Master node in oracle 9i rac
Master node in oracle 9i rac [message #579273] Mon, 11 March 2013 01:03 Go to next message
Nehpal Singh
Messages: 9
Registered: January 2013
Location: Delhi
Junior Member

How to find out which node is master node in oracle 9i RAC database.
Re: Master node in oracle 9i rac [message #579276 is a reply to message #579273] Mon, 11 March 2013 01:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is not a global master node, there are master nodes depending on the resource: V$GES_RESOURCE.MASTER_NODE.

Regards
Michel

[Updated on: Mon, 11 March 2013 01:44]

Report message to a moderator

Re: Master node in oracle 9i rac [message #579278 is a reply to message #579276] Mon, 11 March 2013 01:47 Go to previous messageGo to next message
Nehpal Singh
Messages: 9
Registered: January 2013
Location: Delhi
Junior Member

Thanks for the reply Michel ,
But V$GES_RESOURCE is not there in oracle 9i .
this is the oracle10g view, doesn't work in oracle 9i
Re: Master node in oracle 9i rac [message #579279 is a reply to message #579278] Mon, 11 March 2013 01:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As the link I posted proves it, it is in 9i view.

Regards
Michel
Re: Master node in oracle 9i rac [message #579282 is a reply to message #579279] Mon, 11 March 2013 02:09 Go to previous messageGo to next message
Nehpal Singh
Messages: 9
Registered: January 2013
Location: Delhi
Junior Member

Thanks Michel,
but it show near about 108528 record,
and V$GES_RESOURCE.MASTER_NODE show number 0,1,2,3
where as we have only 3 node rac database.

Is there any other easy way to find this thing.
Re: Master node in oracle 9i rac [message #579292 is a reply to message #579282] Mon, 11 March 2013 02:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What thing?

Regards
Michel
Re: Master node in oracle 9i rac [message #579299 is a reply to message #579292] Mon, 11 March 2013 02:51 Go to previous messageGo to next message
Nehpal Singh
Messages: 9
Registered: January 2013
Location: Delhi
Junior Member

Is there any other way to find out master node in oracle 9i
Re: Master node in oracle 9i rac [message #579301 is a reply to message #579299] Mon, 11 March 2013 02:52 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What kind of master node do you want?
As I said, there is NO global master node.

Regards
Michel
Previous Topic: Stopping Oracle 11g R2 Cluster Services in Windows 2008
Next Topic: Restart RAC DB
Goto Forum:
  


Current Time: Fri Mar 29 07:00:36 CDT 2024