Hi all.
I'm running Oracle 8i for Windows NT (8.0.5) on Windows Server 2000. Somewhere I read that I need to be in ora_dba group on Windows NT platform in order to login as sysdba to database. But I cannot find this group. When I try to login as sysdba as system/manager, login fails with ORA-01031: insufficient privileges. I need to execute startup and shutdown commands from SQL*Plus.
Code:
C:\>sqlplus /nolog

SQL*Plus: Release 8.0.5.0.0 - Production on Mon Mar 26 8:46:56 2007

(c) Copyright 1998 Oracle Corporation. All rights reserved.

SQL> connect USER_X/PASSWORD
Connected.

SQL> select * from user_role_privs;

USERNAME	GRANTED_ROLE	ADM DEF OS_
--------------- --------------- --- --- ---
USER_X		CONNECT		NO  YES NO
USER_X		DBA		NO  YES NO
USER_X		RESOURCE	NO  YES NO

SQL> connect USER_X/PASSWORD as sysdba
ERROR:
ORA-01031: insufficient privileges

Warning: You are no longer connected to ORACLE.

SQL> connect sys/change_on_install as sysdba;
ERROR:
ORA-01031: insufficient privileges

Warning: You are no longer connected to ORACLE.

SQL> connect sys/change_on_install
Connected.

SQL>
Someone on Oracle forums (http://forums.oracle.com/forums/thread.jspa?messageID=1754301) told me:
This type of errors comes only when u have forgotten uar password for sys.
So create a new password file ora%SID% and give some new password to this file and then connect as sysdba using that password only.
It will works...


Code:
SQL> select * from v$pwfile_users;
ERROR:
ORA-00600: internal error code, arguments: [KSSRMP1], [], [], [], [], [], [],[]

no rows selected

SQL>
I found that password file really doesn't exist so I created it.
Code:
C:\>orapwd file=PWDORCL.ORA password=password
But after restarting server (I cannot shutdown database as non-SYSDBA) that ORA-00600 remained. And I don't know how it could help in order to login as SYSDBA.
Very very thx for help.