I had the following issue :
SQL> @crebase
CREATE DATABASE JJO
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-00200: control file could not be created
ORA-00202: control file: '+DATA'
ORA-17502: ksfdcre:4 Failed to create file +DATA
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-01031: insufficient privileges
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
https://dba010.wordpress.com/2012/09/10/ora-15045-asm-file-name-data-is-not-in-reference-form/