Home » Server Options » RAC & Failsafe » Question on RAC database (Oracle 11.2.0.2.0 , Linux 5.7)
Question on RAC database [message #574613] Mon, 14 January 2013 03:42 Go to next message
Jack14
Messages: 497
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
Re: Question on RAC database [message #574618 is a reply to message #574613] Mon, 14 January 2013 05:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
show parameter cluster_database

Regards
Michel
Re: Question on RAC database [message #574619 is a reply to message #574613] Mon, 14 January 2013 05:10 Go to previous messageGo to next message
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
Re: Question on RAC database [message #574639 is a reply to message #574619] Mon, 14 January 2013 09:02 Go to previous message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Thank you for the answers.
Previous Topic: How to Implement a Non-RAC (Single Instance with Existing ASM-RAC as storage)
Next Topic: Download Clusterware 11g
Goto Forum:
  


Current Time: Thu Mar 28 19:23:47 CDT 2024