This content has been marked as final. Show 6 replies
SQL> startup mount;The parameter control_files in pfile/spfile should have value as '+DAT/prds/controlfile/current.913.794712357','+FRA/prds/controlfile/current.5616.794712357'
ORA-15124: ASM file name '+DAT/prds/controlfile/current.913.794712357, +FRA/prds/controlfile/current.5616.794712357' contains an invalid alias name
It looks like you have missed out the adding quotes to each controlfile path and you have specified both the files under one quote.
*ORA-15124: ASM file name '+DAT/prds/controlfile/current.913.794712357, +FRA/prds/controlfile/current.5616.794712357'*
Would check the control file
- go to asmcmd
- asmcmd> ls +FRA/prds/controlfile
Make sure your control is the correct one.
It looks issue not with controlfile location as of now, because you have issue even in startup of instance.
So probabaly it may be issue with file locations.
If you are using SPFILE, then create prime from SPFILE.
And then check exact locations from ASMCMD, then specify control file in PFILE as below.
Then start in nomount, if you able to start then mount standby instance.
Ensure file locations are correct.
I found out it is the problem of other issue. still debugging it now. THank you guys.
Somehow the problem was the netmask it changed by OS folks did not change in node 2.
may be you created a alias for your control file in asm or your control file location is in correct in pfile/spfile with asm location. if u created a alias then remove alias from asm otherwise put the exact location of asm control file in pfile.