1 2 Previous Next 18 Replies Latest reply: Dec 27, 2011 8:03 AM by CKPT RSS

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

    Alex.V-Oracle
      Hello,

      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 10.2.0.1.0 - 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 10.1.0.3.0 - Production on Wed May 23 11:08:52 2007
      Copyright (c) 1982, 2004, Oracle. All rights reserved.
      ERROR:
      ORA-01031: insufficient privileges.

      Thank you for any suggestion.
        1 2 Previous Next