Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

****************I am authoring a Book on Oracle Database Cloud Services.......More details to follow.***************

Title : Oracle Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2019

**********************************************************************************


Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]


My Cloud Certifications:

AWS Certified Solutions Architect Associate

Oracle Cloud Infrastructure 2018 Certified Architect Associate.

Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.

Oracle Database Cloud Administrator Certified Professional.

Oracle Database Cloud Service Operations Certified Associate.

Search This Blog

Tuesday, August 11, 2015

ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 486 with ORA-15124: ASM file name contains an invalid alias name

If you use any of the below syntax you will get the below mentioned error, instead try the suggested fix.



Using dot here "."

ASMCMD> cp /home/oracle/sshaik/tt_temp_sales.319.887131035 .
or


Using just path here "+DATA/prod1/daatfile"
cp /home/oracle/sshaik/tt_temp_sales.319.887131035 '+DATA2/prod1/datafile/'

or
 Using just first two letters of the file name with no quotes here "+DATA2/prod1/datafile/tt"
cp /home/oracle/sshaik/tt_temp_sales.319.887131035 +DATA2/prod1/datafile/tt*

or

Using just first two letters of the file name with quotes here "+DATA2/prod1/datafile/tt"

cp /home/oracle/sshaik/tt_temp_sales.319.887131035 '+DATA2/prod1/datafile/tt*'

or
Using complete file name with quotes here "+DATA2/prod1/datafile/tt_temp_sales.319.887131035'
 
cp /home/oracle/sshaik/tt_temp_sales.319.887131035 '+DATA2/prod1/datafile/tt_temp_sales.319.887131035'

copying /home/oracle/sshaik/tt_temp_sales.319.887131035 -> +DATA2/prod1/datafile/tt*
ASMCMD-8016: copy source '/home/oracle/sshaik/tt_temp_sales.319.887131035' and target '+DATA2/prod1/datafile/tt*' failed
ORA-15124: ASM file name '+DATA2/prod1/datafile/tt*' contains an invalid alias name
ORA-15124: ASM file name '+DATA2/prod1/datafile/tt*' contains an invalid alias name
ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 486
ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute)


Workaround:
==========

ASMCMD> cp /home/oracle/sshaik/tt_temp_sales.319.887131035 '+DATA2/prod1/datafile/tt_temp_sales'
copying /home/oracle/sshaik/tt_temp_sales.319.887131035 -> +DATA2/prod1/datafile/tt_temp_sales

Since ASM will automatically append file/incarnation pair to ensure uniqueness, you will have give the name except the incarnation number….

No comments: