Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.
COURSE of the MONTH
7 days, 22 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
oracle 10g 2 node rac cluster 1 node wont start ora-15124 running on linux oel 5.2
Posted on 2016-07-25
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/controlfil
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.
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/controlfil
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.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
3
2
5 Comments
Active 6 days ago
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.
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.
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
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
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This post first appeared at Oracleinaction (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself).
I will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Fine Tune your automatic Updates for Ubuntu / Debian
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Suggested Courses
Course of the Month7 days, 22 hours left to enroll
765 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.