Friday, November 30, 2012

ORA-01565: error in identifying file '+DATA/...' Ora-17503 Ora-01031 Insufficient privileges

Got error at my Test 11gR2 grid infrastructure node 1

ORA-01565: error in identifying file '+DATA/...'
Ora-17503:   ksfdopn:2 Failes to open file
Ora-01031 Insufficient privileges


Cause:
          Mistakenly set SQLNET.AUTHENTICATION_SERVICES parameter in sqlnet.ora file, in $GRID_HOME/network/admin

Solution:
         Commented the line SQLNET.AUTHENTICATION_SERVICES in GRID_HOME/network/admin.

Note:
        This has to be done at GRID_HOME directory of 11g grid infrastructure not in ORACLE_HOME directory.

No comments:

Post a Comment