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@(protected)"

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