ORA-15045: ASM file name ‘+DATA’ is not in reference form
September 10, 2012 7 Comments
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.
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.
Thank you “ora_dba” for your comment , I will try to simplify my post.
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?.
what do you mean in disk device files?
Do you mean this?
ls -la /dev/oracleasm/disks/
Yes.
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
Yes it will work.