This note explains how to create an alias in ASM. We will look at an example of creating an alias for SPFILE.

oracrs – +ASM1 >sqlplus

SQL*Plus: Release 12.1.0.2.0 Production on Tue Jan 28 09:26:46 2020

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Enter user-name: sys as sysasm

Enter password:

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production

With the Real Application Clusters and Automatic Storage Management options

SQL> alter diskgroup ORCL_DG ADD ALIAS ‘+ORCL_DG/ORCL/PARAMETERFILE/spfileORCL.ora’ for ‘+ORCL_DG/ORCL/PARAMETERFILE/spfile.277.1030872227’;

Diskgroup altered.

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production

With the Real Application Clusters and Automatic Storage Management option

oracrs – +ASM1 >asmcmd

ASMCMD> cd +ORCL_DG/ORCL/PARAMETERFILE/

ASMCMD> ls -ltr

WARNING:option ‘r’ is deprecated for ‘ls’

please use ‘reverse’

Type           Redund  Striped  Time             Sys  Name

PARAMETERFILE  UNPROT  COARSE   JAN 28 09:00:00  Y    spfile.277.1030872227

PARAMETERFILE  UNPROT  COARSE   JAN 28 09:00:00  N    spfileORCL.ora => +ORCL_DG/ORCL/PARAMETERFILE/spfile.277.1030872227

References:

Database spfile Parameter alias is not created in ASM Diskgroup and init<SID>.ora in $ORACLE_HOME/dbs refers to a non existing spfile alias in ASM diskgroup (Doc ID 1950769.1)