OraFAQ Forum: RAC & Failsafe » Master node in oracle 9i rac

Home » Server Options » RAC & Failsafe » Master node in oracle 9i rac

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Master node in oracle 9i rac [message #579273]

Mon, 11 March 2013 01:03

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.

Report message to a moderator

Re: Master node in oracle 9i rac [message #579276 is a reply to message #579273]

Mon, 11 March 2013 01:42

Michel Cadot
Messages: 54702
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

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

Report message to a moderator

Re: Master node in oracle 9i rac [message #579279 is a reply to message #579278]

Mon, 11 March 2013 01:54

Michel Cadot
Messages: 54702
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

Report message to a moderator

Re: Master node in oracle 9i rac [message #579282 is a reply to message #579279]

Mon, 11 March 2013 02:09

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.

Report message to a moderator

Re: Master node in oracle 9i rac [message #579292 is a reply to message #579282]

Mon, 11 March 2013 02:38

Michel Cadot
Messages: 54702
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What thing?

Regards
Michel

Report message to a moderator

Re: Master node in oracle 9i rac [message #579299 is a reply to message #579292]

Mon, 11 March 2013 02:51

Nehpal Singh
Messages: 9
Registered: January 2013
Location: Delhi

Junior Member

Is there any other way to find out master node in oracle 9i

Report message to a moderator

Re: Master node in oracle 9i rac [message #579301 is a reply to message #579299]

Mon, 11 March 2013 02:52

Michel Cadot
Messages: 54702
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 19 07:46:53 CDT 2013

Total time taken to generate the page: 0.15716 seconds