Solved

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

Posted on 2016-07-25
5
118 Views
Last Modified: 2016-07-28
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.
0
Comment
Question by:DarrenJackson
  • 3
  • 2
5 Comments
 
LVL 4

Expert Comment

by:Abhimanyu Suri
ID: 41729787
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
 

Author Comment

by:DarrenJackson
ID: 41731195
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
 
LVL 4

Accepted Solution

by:
Abhimanyu Suri earned 500 total points
ID: 41732236
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
 

Author Comment

by:DarrenJackson
ID: 41732487
Ill give it a go thanks
0
 

Author Comment

by:DarrenJackson
ID: 41733178
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

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
linux installs 6 49
How to learn Linux? 10 42
VMware Workstation 12 Player 16 36
Penetration Testing home based work 3 50
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now