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

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

****************Got the opportunity to pen a Book on Database Cloud Services.......More details to follow.***************

Title : Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2020

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


My Cloud Certifications:

AWS Certified Solutions Architect Associate

Azure Certified Architect

Azure Certified Administrator

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: