1 2 Previous Next 18 Replies Latest reply on Dec 27, 2011 2:03 PM by CKPT

    Unable to connect to Oracle using OS authentication (sqlplus / as sysdba)


      When I try to connect locally ,using OS authentication ( sqlplus / as sysdba ), on a Oracle database, I get "ORA-01031: insufficient privileges" error.

      OS: Windows XP
      Oracle Database 10g Enterprise Edition Release - Prod.
      connecting as sysdba using sys/pasword works.

      I have setup :
      -> Log on as a batch job
      -> Log on as a service
      I am also member of ORA_DBA group.

      I mention that connecting "/ as sysdba" worked many months after I've installed the Oracle database. But at some moment in time connecting "/ as sysdba" was no longer possible.

      C:\>sqlplus / as sysdba
      SQL*Plus: Release - Production on Wed May 23 11:08:52 2007
      Copyright (c) 1982, 2004, Oracle. All rights reserved.
      ORA-01031: insufficient privileges.

      Thank you for any suggestion.
        1 2 Previous Next