We help IT Professionals succeed at work.
Get Started

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

407 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.
Comment
Watch Question
Database Engineer
CERTIFIED EXPERT
Top Expert 2016
Commented:
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE