This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Dec 27, 2011 6:03 AM by CKPT RSS

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

alex.v Newbie
Currently Being Moderated
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