ORA-17502: ksfdcre:4 Failed to create file, ORA-15046: ASM file name is not in single-file creation form

Issue:

While recreating the controlfile in an Oracle Database, below issue has been cropped in

SQL> @SIT1_ora_11129.trc
CREATE CONTROLFILE SET DATABASE “SIT” RESETLOGS NOARCHIVELOG
*

ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed
ORA-00200: control file could not be created
ORA-00202: control file: ‘+DATA_SIT/SIT/CONTROLFILE/current.456.928241937’
ORA-17502: ksfdcre:4 Failed to create file
+DATA_SIT/SIT/CONTROLFILE/current.456.928241937
ORA-15046: ASM file name ‘+DATA_SIT/SIT/CONTROLFILE/current.456.928241937’ is
not in single-file creation form

Cause:

The name of the Controlfile may be too long to create the file

Resolution:

Change the name of the controlfile in Pfile (or spfile) with simple name and recreate the controlfile

From:

SQL> sho parameter control

NAME TYPE VALUE
———————————— ———– ——————————
control_file_record_keep_time integer 45
control_files string +DATA_SIT/SIT/CONTROLFILE/cu
rrent.456.928241937, +DATA_GBI
D/SIT/CONTROLFILE/current.455
.928241937
control_management_pack_access string DIAGNOSTIC+TUNING

To:

SQL> sho parameter control

NAME TYPE VALUE
———————————— ———– ——————————
control_file_record_keep_time integer 45
control_files string +DATA_SIT/SIT/CONTROLFILE/control01.ctl, +DATA_GBI
D/SIT/CONTROLFILE/control01.ctl
control_management_pack_access string DIAGNOSTIC+TUNING

Advertisements
This entry was posted in Oracle Database, Oracle Database Clone Issues. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s