oracle 10g 2 node rac cluster 1 node wont start ora-15124 running on linux oel 5.2

Guys,

I have a test 2 node rac cluster using asm with omf enabled for storage with ocfs2 as my cluster config.

The problem I am having is I can start node1 up no problems but when I start up node 2 I get the error
ora-15124: ASM file name '+DATA/ifsl_rac/controlfile/current.1082.917777031. +DATA/ifsl_rac/controlfile/current.1007.917777371' contains an invalid alias name

my pfile points to the spfile exactly like it does in node1 so I cannot understand why this is trying to use this. Plus the controlfiles are not named like this. If I create a pfile and use that to open the instance it opens no problems.

Just to add I have restored this database and previously the controlfiles where named as above but they have been removed.

I cannot see where node2 is picking up this config from.

Any help would be very much appreciated.
DarrenJacksonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Abhimanyu SuriSr Database EngineerCommented:
As you have mentioned that previously controlfiles were mentioned with the same name.

In my opinion, problem could be with wrong spfile in ASM or

Can you please check if by any chance you have multiple spfiles using asmcmd ?
It could very well be in a folder named UNKNOWN for DB NAME.

Please set spfile path for database using
 srvctl modify database -d <db_unique_name>  -p <spfile>  

Since another node is coming up properly, we can safely assume that all required files are present and are in a good state.
0
DarrenJacksonAuthor Commented:
Hi, Thanks for replying.

Its baffling me as if I create a pfile from the spfile and startup the instance using this then all is good. but if my pfile is just a pointer that points to the asm spfile then I have the problem.

Even though my other instance starts up fine.

I will check the spfile file path via srvctl though as its worth a try

thanks
0
Abhimanyu SuriSr Database EngineerCommented:
Can you try recreating spfile by mentioning

control file as

*.control_files = '+DATA/ifsl_rac/controlfile/current.1082.917777031',
'+DATA/ifsl_rac/controlfile/current.1007.917777371'  

 #####  As per file mentioned in error statement it appears control file parameter is wrapped
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DarrenJacksonAuthor Commented:
Ill give it a go thanks
0
DarrenJacksonAuthor Commented:
I recreated the spfile on the other node and it is now working.

Still a bit baffled over this but the outcome is I can now have both nodes using spfile

Thanks for the help
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Linux

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.