Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't Shutdown with other "sysdba" users

Status
Not open for further replies.

FSM

IS-IT--Management
Jun 8, 2000
59
US
Need help guys, I can't shutdown my DB (only with the INTERNAL user) and I have given the "system" user privileges of SYSDBA and i can't do it, what could be the problem??? this is what happens:
SQL> CONNECT FSM AS SYSDBA
Enter password: ***
Connected.
SQL> shutdown
ORA-01031: insufficient privileges

and the same thing happens with the "system" user and "sys"
and also, i've checked the view "v$pwfile_users" and my users are there, so what can be wrong???
SQL> select * from v$pwfile_users;

USERNAME SYSDB SYSOP
------------------------------ ----- -----
INTERNAL TRUE TRUE
SYS TRUE TRUE
FSM TRUE FALSE
SYSTEM TRUE FALSE


Thanx!!!

 
You are apparently running into bug 2224184. For some reason, when you log into SQL*Plus and get prompted for a password, Oracle doesn't recognise that you have logged in with sysdba privileges. The work-around is to make sure that you type your password in the connect statement. Then your shutdown command should work.

CONNECT FSM/*** AS SYSDBA

I was able to reproduce this problem using the SYS id. Supplying a password on the connect statement does, indeed, fix the error.
 
Karluk, You are good man!!!!it work, im new in Oracle but let me tell you i have come across a lot of you tips here and they have help me a lot!!!

Thank you very much!!!

FSM
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top