sys lost sysdba priv?

From: Aragon, Gabriel (GE Commercial Finance) <gabriel.aragon_at_ge.com>
Date: Thu, 17 Mar 2005 11:49:09 -0500
Message-ID: <8CABE4F0A4D9B54BBF735922A381BD0E03E35202@CINMLVEM05.e2k.ad.ge.com>

Hi list Oracle 9.2.0.4 Win2k, this is a weird situation it seems to be = that sys lost its sysdba priv:

---

D:\Oracle\Ora9i\database>del pwdproddb.ora D:\Oracle\Ora9i\database>orapwd file=3DPWDPRODDB.ora password=3Dxxxxx = entries=3D10
D:\Oracle\Ora9i\database>sqlplus "sys_at_testing as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Thu Mar 17 10:38:45 2005 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter password:
Connected to an idle instance.

ERROR at line 1:
ORA-01034: ORACLE not available

SQL> startup
ORA-01031: insufficient privileges

D:\Oracle\Ora9i\database>oradim -startup -sid proddb -usrpwd xxxxx ORA-01031: insufficient privileges

D:\Oracle\Ora9i\database>sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Thu Mar 17 10:43:00 2005 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SP2-0640: Not connected
SQL> connect / as sysdba;
ERROR:
ORA-01031: insufficient privileges

SQL> connect sys as sysdba;
Enter password:
Connected to an idle instance.
SQL>
SQL> startup
ORA-01031: insufficient privileges

---

My windows user is at Administrator and ORA_DBA group, I've been = searching metalink w/o luck. What am I doing wrong? Though this is a = testing instance, I dont want to recreate the instance. Any suggestions? =

TIA,
GAP

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 17 2005 - 11:54:11 CST