OraFAQ Forum: RAC & Failsafe » problem about spfile

Home » Server Options » RAC & Failsafe » problem about spfile (RAC 10G Windows 2003)

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

problem about spfile [message #428655]

Thu, 29 October 2009 05:21

mamingui
Messages: 83
Registered: July 2006

Member

Hi All,

I've RAC DB with 2 nodes and the both nodes are UP.
My problem is with the spfile. the first node are using spfile and the second node are using nothing ?
I mean that when I type this "show parameter spfile" I get value in node1 but the column is null in node2.

How to make that Node2 use the same spfile than node1 ?

Please help me.

Regards

Report message to a moderator

Re: problem about spfile [message #428661 is a reply to message #428655]

Thu, 29 October 2009 06:00

Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Post your session. Give us something to see.
As said in other post, check if your init.ora in all local nodes are pointing to spfile in shared area.

Report message to a moderator

Re: problem about spfile [message #428663 is a reply to message #428655]

Thu, 29 October 2009 06:17

mamingui
Messages: 83
Registered: July 2006

Member

Thank you for your help,

how to check it please ?

Regards

Report message to a moderator

Re: problem about spfile [message #428664 is a reply to message #428663]

Thu, 29 October 2009 06:29

Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://www.orafaq.com/forum/m/428359/42800/#msg_428454

Report message to a moderator

Previous Topic:	RMAN ARCHIVING
Next Topic:	Suggestion to store clusterware files

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Mar 25 10:06:52 CDT 2023