ORA-15045: ASM file name ‘+DATA’ is not in reference form

Error Message:

RMAN-06136: ORACLE error from auxiliary database: ORA-00200: control file could not be created
ORA-00202: control file: ‘+DATA’
ORA-15045: ASM file name ‘+DATA’ is not in reference form
ORA-17502: ksfdcre:5 Failed to create file +DATA
ORA-15081: failed to submit an I/O operation to a dis

Cause:

There are permissions problem.

Solution:

The following solution helped me, hope be the same for you.

[oracle@node2  ~] ls -la $ORACLE_HOME/bin/oracle

-r-sr-s–x 1 oracle oinstall  /u01/app/oracle/product/11.2.0/db_1/bin/oracle

[oracle@node2  ~] su –
Password:

[root@node2  ~] chown oracle:asmadmin  /u01/app/oracle/product/11.2.0/db_1/bin/oracle

[root@node2  ~] ls -la  /u01/app/oracle/product/11.2.0/db_1/bin/oracle

-r-xr-x–x 1 oracle asmadmin  /u01/app/oracle/product/11.2.0/db_1/bin/oracle

[root@node2  ~] chmod a+s  /u01/app/oracle/product/11.2.0/db_1/bin/oracle

[root@node2  ~] ls -la  /u01/app/oracle/product/11.2.0/db_1/bin/oracle

-r-sr-s–x 1 oracle asmadmin  /u01/app/oracle/product/11.2.0/db_1/bin/oracle

Note:

[root@node1 ~]# id oracle
uid=501(oracle) gid=500(oinstall) groups=500(oinstall),501(dba),503(asmdba),505(oper)
[root@node1 ~]# id grid
uid=500(grid) gid=500(oinstall) groups=500(oinstall),501(dba),502(asmadmin),503(asmdba),504(asmoper)

Oracle is oracle software owner and Grid user is grid software owner. So I have two different users.

Advertisement

About Mariami Kupatadze
Oracle Certified Master Linkedin: https://www.linkedin.com/in/mariami-kupatadze-01074722/

7 Responses to ORA-15045: ASM file name ‘+DATA’ is not in reference form

  1. ora_dba says:

    Your solving method is very nice. Technical person has understand very quickly. For nontechnical like student if we have to understand him can you have any another way?
    It’s very critical solution to change all path. But very nice.

  2. ora_dba says:

    Access rights on disk device files, are not 777. As the second 7 means access to group oinstall.
    If i change the access rights to 777.
    What you think it will work?.

    • dba010 says:

      I changed permission and it works. But my permissions are: rw-rw—-. As I think it is a default permission.

      brw-rw—- 1 grid asmadmin 8, 65 Sep 7 18:14 CRSVOL
      brw-rw—- 1 grid asmadmin 8, 17 Sep 7 18:14 DISK1
      brw-rw—- 1 grid asmadmin 8, 33 Sep 7 18:14 DISK2
      brw-rw—- 1 grid asmadmin 8, 49 Sep 7 18:14 DISK3

  3. ora_dba says:

    Yes it will work.

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 )

Facebook photo

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

Connecting to %s

%d bloggers like this: