RE: identifying instance from shared spfile in RAC

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Thu, 4 Oct 2007 13:59:07 -0400
Message-ID: <D1DC33E67722D54A93F05F702C99E2A9016D15A4@usahm208.amer.corp.eds.com>

With RAC there is one spfile for the entire database (all instances).  

Since the spfile must be shared either Oracle is installed on a clustered file system or more likely the spfile is place on a clustered file system or raw partition and each instance will have an init.ora file that contains one entry which points to the shared spfile location.  

Within the spfile there are parameters which tie an instance name to an instance number etc....  

• Mark D Powell -- Phone (313) 592-5148

  ---

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of LS Cheng

	Sent: Thursday, October 04, 2007 9:02 AM
	To: hrishys_at_yahoo.co.uk
	Cc: oracle-l_at_freelists.org
	Subject: Re: identifying instance from shared spfile in RAC
	
	
	Hi
	
	What do you mean instance specific spfile is no longer there?
	
	If you go to $ORACLE_HOME/dbs there should a initSID.ora which

points to your spfile         

        ThanKs         

	--
	LSC
	
	
	On 10/4/07, hrishy <hrishys_at_yahoo.co.uk> wrote: 

		Hi
		
		In a single instance database when i issue the startup
		command the oracle software will read a
		instance specific init.ora file and bring up a
		instance
		
		what happens when there is shared spfile file with 
		entries like this in case of RAC
		
		rac1.instance_number=1
		rac2.instance_number=2
		
		and when i say
		
		srvctl start instance -i rac1 how will oracle know
		which instance is rac1 as the instance specific spfile 
		is no longer there only values seem to be there
		
		regards
		Hrishy
		
		
		
	
___________________________________________________________
		Want ideas for reducing your carbon footprint? Visit

Yahoo! For Good
http://uk.promotions.yahoo.com/forgood/environment.html

		--
		http://www.freelists.org/webpage/oracle-l 
		
		
		

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 04 2007 - 12:59:07 CDT