Connecting SYS@<SID> as SYSDBA returns ORA-01031: insufficient privileges

gba...@ravenpack.com

unread,

Dec 14, 2007, 5:42:25 AM12/14/07

to

Hi,

After upgrading an Oracle 10gR2 10.2.0.1 database to 10.2.0.3 I found
the following connection issue:

Log into the database server as OS user "oracle" that belongs to dba,
oper and oinstall groups. The system is using OS authentication.
Environment variables $ORACLE_HOME and $ORACLE_SID are set correctly:

> sqlplus sys as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Fri Dec 14 10:22:19 2007

Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
Production
With the Partitioning, OLAP and Data Mining options

SQL> exit

Now, if I specify the database SID in the connection I get:

> sqlplus sys@<SID> as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Fri Dec 14 10:23:46 2007

Enter password:
ERROR:
ORA-01031: insufficient privileges

Recall that I am not using password file. Does anyone have a clue of
why is this happening?

Best Regards.

gbahut.

gba...@ravenpack.com

unread,

Dec 14, 2007, 6:09:36 AM12/14/07

to

OS system is Red Hat Enterprise Linux AS release 4 (Nahant Update 5).

gba...@ravenpack.com

unread,

Dec 14, 2007, 7:16:59 AM12/14/07

to

For some reason, the orapwd file under $ORACLE_HOME/dbs was removed
after patching the database.
Shutting down the database and creating a password file resolve the
problem.

Issue resolved.