ORA-19504 & ORA-15046 when using DBMS_STREAMS_TABLESPACE_ADM or DBMS_FILE

ORA-19504 & ORA-15046 when using DBMS_STREAMS_TABLESPACE_ADM or DBMS_FILE_TRANSFER (Doc ID 566561.1)

Last updated on MAY 13, 2013

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.6 - Release: 10.2 to 11.1
Information in this document applies to any platform.

Symptoms

Database files stored in ASM using Oracle Managed Files (OMF) format
Packages DBMS_FILE_TRANSFER or DBMS_STREAMS_TABLESPACE_ADM used to move files from/to another ASM diskgroup.
Reported Errors ORA-19504, ORA-17502, ORA-15046 and ORA-6512
On the destination database, files will be stored in ASM and the provided name was in OMF format.

Example when using dbms_file_transfer:

ERROR at line 1:
ORA-19504: failed to create file "+testred/test1.3300.653394733"
ORA-17502: ksfdcre:4 Failed to create file +testred/test1.3300.653394733
ORA-15046: ASM file name '+testred/test1.3300.653394733' is not in single-file
creation form
ORA-06512: at "SYS.DBMS_FILE_TRANSFER", line 84
ORA-06512: at "SYS.DBMS_FILE_TRANSFER", line 193
ORA-06512: at line 2

Example when using DBMS_STREAMS_TABLESPACE_ADM:

ORA-19504: failed to create file "+DG_NORMAL/test1.3353.653315111"
ORA-17502: ksfdcre:4 Failed to create file +DG_NORMAL/test1.3353.653315111
ORA-15046: ASM file name '+DG_NORMAL/.3353.653315111' is not in single-file creation form
ORA-06512: at "SYS.DBMS_STREAMS_TABLESPACE_ADM", line 2355
ORA-06512: at line 11

Cause

	Sign In with your My Oracle Support account
	Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms

Applies to:

Symptoms

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started