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

From: <gbahut_at_ravenpack.com>
Date: Fri, 14 Dec 2007 02:42:25 -0800 (PST)
Message-ID: <66b5ea70-6a90-4e56-8abb-a91d7ef97549@s19g2000prg.googlegroups.com>

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. Received on Fri Dec 14 2007 - 04:42:25 CST