Tuesday, June 21, 2016

ORA-15124: ASM file name contains an invalid alias name

SQL> startup nomount
ORA-15124: ASM file name '+DATA/QA/CONTROLFILE/control01.ctl,+DATA/QA/CONTROLFILE/control02.ctl' contains an invalid alias name


Solution:
Change Control_files Entry: Single Quote each control file name separately.
Original:
*.control_files='+DATA/CONTROLFILE/control01.ctl,+DATA/CONTROLFILE/control02.ctl'




Correct One:
*.control_files='+DATA/CONTROLFILE/control01.ctl','+DATA/CONTROLFILE/control02.ctl'

No comments:

Post a Comment