-
I cannot login as SYSDBA
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.
-
-
Originally Posted by davey23uk
call support
I haven't Oracle support :[
-
-
Please can you at least consider the core of the problem and think about it ? I'm not Oracle DBA. I'm in my new job exposed to administer Oracle Database server and I haven't much time to learn it so fast. Some things I cannot do without SYSDBA privilegies...
Thx
-
what happens when you use svrmgrl
svrmgr
connect internal
-
Code:
C:\>SVRMGR30.EXE
Oracle Server Manager Release 3.0.5.0.0 - Production
(c) Copyright 1997, Oracle Corporation. All Rights Reserved.
Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production
SVRMGR> connect internal
Password:
Connected.
SVRMGR>
Sorry, I don't know what does this tool. I promise I will learn it...
-
once connected via svrmgrl you can go ahead, change SYS password, shutdown database, etc.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
OK.
I will find out what is this tool for. Today I cannot remain in work too long. So tomorow I will inform you how it worked out.
Thanks very much...
-
was sqlplus "/ as sysdba" even valid for 8.0? no idea, dont think it was was.
anyway server manager is the way to go, you can do everything with that
you could also try sqlplus internal
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|