Tuesday, December 23, 2008

ORA-17503: ksfdopn:2 Failed to open file ... ORA-01031: insufficient privileges


If use "SQLNET.AUTHENTICATION_SERVICES=(NTS)" on sqlnet.ora, perhaps you will find bellow Errors on alert log.


Tue Dec 23 16:00:45 2008
Unexpected communication failure with ASM instance:
 error 1031 (ORA-01031: insufficient privileges
)
Unexpected communication failure with ASM instance:
 error 1031 (ORA-01031: insufficient privileges
)
Errors in file ORACLE_BASE/diag/rdbms/db/db1/trace/db1_arc0_2089.trc:
ORA-00313: open failed for members of log group 5 of thread 2
ORA-00312: online log 5 thread 2: '+DATA2/db/onlinelog/group_5.394.673269475'
ORA-17503: ksfdopn:2 Failed to open file +DATA2/db/onlinelog/group_5.394.673269475
ORA-01031: insufficient privileges
ORA-00312: online log 5 thread 2: '+DATA1/db/onlinelog/group_5.271.673269473'
ORA-17503: ksfdopn:2 Failed to open file +DATA1/db/onlinelog/group_5.271.673269473
ORA-01031: insufficient privileges
Errors in file ORACLE_BASE/diag/rdbms/db/db1/trace/db1_arc0_2089.trc:
ORA-00313: open failed for members of log group 5 of thread 2
ORA-00312: online log 5 thread 2: '+DATA2/db/onlinelog/group_5.394.673269475'
ORA-17503: ksfdopn:2 Failed to open file +DATA2/db/onlinelog/group_5.394.673269475
ORA-01031: insufficient privileges
ORA-00312: online log 5 thread 2: '+DATA1/db/onlinelog/group_5.271.673269473'
ORA-17503: ksfdopn:2 Failed to open file +DATA1/db/onlinelog/group_5.271.673269473
ORA-01031: insufficient privileges
Unexpected communication failure with ASM instance:
 error 1031 (ORA-01031: insufficient privileges
)
Unexpected communication failure with ASM instance:
 error 1031 (ORA-01031: insufficient privileges
)
Errors in file ORACLE_BASE/diag/rdbms/db/db1/trace/db1_arc0_2089.trc:
ORA-00313: open failed for members of log group 6 of thread 2
ORA-00312: online log 6 thread 2: '+DATA2/db/onlinelog/group_6.396.673269493'
ORA-17503: ksfdopn:2 Failed to open file +DATA2/db/onlinelog/group_6.396.673269493
ORA-01031: insufficient privileges
ORA-00312: online log 6 thread 2: '+DATA1/db/onlinelog/group_6.272.673269491'
ORA-17503: ksfdopn:2 Failed to open file +DATA1/db/onlinelog/group_6.272.673269491
ORA-01031: insufficient privileges
Errors in file ORACLE_BASE/diag/rdbms/db/db1/trace/db1_arc0_2089.trc:
ORA-00313: open failed for members of log group 6 of thread 2
ORA-00312: online log 6 thread 2: '+DATA2/db/onlinelog/group_6.396.673269493'
ORA-17503: ksfdopn:2 Failed to open file +DATA2/db/onlinelog/group_6.396.673269493
ORA-01031: insufficient privileges
ORA-00312: online log 6 thread 2: '+DATA1/db/onlinelog/group_6.272.673269491'
ORA-17503: ksfdopn:2 Failed to open file +DATA1/db/onlinelog/group_6.272.673269491
ORA-01031: insufficient privileges

This problem, we should comment "SQLNET.AUTHENTICATION_SERVICES=(NTS)" on sqlnet.ora file, and then login by sysdba

 $ sqlplus / as sysdba

SQL> alter system archive log current;
System altered.

and check alert log.
kcrrdmx: Successful archiving of previously failed ORL
If this article can't help, maybe should check trace file as well.

No comments: