OraFAQ Forum: RAC & Failsafe » Question on RAC database

Home » Server Options » RAC & Failsafe » Question on RAC database (Oracle 11.2.0.2.0 , Linux 5.7)

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

Question on RAC database [message #574613]

Mon, 14 January 2013 03:42

Jack14
Messages: 333
Registered: December 2011
Location: INDIA

Senior Member

Hi,

How to identify what kind of environment are we using it ... whether RAC database or
single database ?

Thank you

Report message to a moderator

Re: Question on RAC database [message #574618 is a reply to message #574613]

Mon, 14 January 2013 05:03

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

Senior Member
Account Moderator

show parameter cluster_database

Regards
Michel

Report message to a moderator

Re: Question on RAC database [message #574619 is a reply to message #574613]

Mon, 14 January 2013 05:10

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

Junior Member

select instance_number ,instance_name, host_name from gv$instance ;

if it show you one output the it's standalone database and if it show you more then one result the it is a RAC database. Smile

Report message to a moderator

Re: Question on RAC database [message #574639 is a reply to message #574619]

Mon, 14 January 2013 09:02

Jack14
Messages: 333
Registered: December 2011
Location: INDIA

Senior Member

Thank you for the answers.

Report message to a moderator

Previous Topic:	How to Implement a Non-RAC (Single Instance with Existing ASM-RAC as storage)
Next Topic:	Download Clusterware 11g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 25 02:58:02 CDT 2013

Total time taken to generate the page: 0.27095 seconds