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.
Someone on Oracle forums (http://forums.oracle.com/forums/thread.jspa?messageID=1754301) told me: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>
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...
I found that password file really doesn't exist so I created it.Code:SQL> select * from v$pwfile_users;
ERROR:
ORA-00600: internal error code, arguments: [KSSRMP1], [], [], [], [], [], [],[]
no rows selected
SQL>
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.Code:C:\>orapwd file=PWDORCL.ORA password=password
Very very thx for help.