Unable to connect to Oracle using OS authentication (sqlplus / as sysdba)
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.