//
you're reading...
Oracle Database Toubleshooting

ORA-15045: ASM file name 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: ‘+TESTDBDATA’
ORA-15045: ASM file name ‘+TESTDBDATA’ is not in reference form
ORA-17502: ksfdcre:5 Failed to create file +TESTDBDATA
ORA-15081: failed to submit an I/O operation to a dis

Cause:

The permissions issue of the ‘oracle’ bin program is the cause of the problem.

Solution:

The following steps should solve this problem

[oracle@testnode1  #] ls -la $ORACLE_HOME/bin/oracle
-r-sr-s–x 1 oracle oinstall  /ora01/app/oracle/product/11.2.0.3/dbhome_1/bin/oracle

Switch to root user session

[oracle@testnode1  #] su - root
Password:

[root@testnode1  #] chown oracle:asmadmin  /ora01/app/oracle/product/11.2.0.3/dbhome_1/bin/oracle
[root@testnode1  #] ls -la  /ora01/app/oracle/product/11.2.0.3/dbhome_1/bin/oracle
-r-xr-x–x 1 oracle asmadmin  /ora01/app/oracle/product/11.2.0.3/dbhome_1/bin/oracle
[root@testnode1  #] chmod 6751  /ora01/app/oracle/product/11.2.0.3/dbhome_1/bin/oracle
[root@testnode1  #] ls -la  /ora01/app/oracle/product/11.2.0.3/dbhome_1/bin/oracle
-r-sr-s–x 1 oracle asmadmin  /ora01/app/oracle/product/11.2.0.3/dbhome_1/bin/oracle
Advertisements

About daviewning

I am an Oracle DBA

Discussion

No comments yet.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: