one stupid question [message #1034] |
Fri, 22 March 2002 12:54 |
Michael C
Messages: 10 Registered: March 2002
|
Junior Member |
|
|
I have a sysdba privilage in the database. When connect myself in sql> and doing the shutdown command it say I don't have the privileges, but when I use svrmgrl> and do the same thing I can be able to shutdown the database, why was that? Am I set something wrong in the database?
Thanks for the help in advance
---Michael
SQL> connect "username" as sysdba
Enter password:
Connected.
SQL> shutdown immediate;
ORA-01031: insufficient privileges
SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
C:>svrmgrl
Oracle Server Manager Release 3.1.6.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
SVRMGR> connect username as sysdba
Password:
Connected.
SVRMGR> shutdown immediate;
Database closed.
Database dismounted.
|
|
|
Re: one stupid question [message #1039 is a reply to message #1034] |
Sun, 24 March 2002 16:50 |
seng
Messages: 191 Registered: February 2002
|
Senior Member |
|
|
For your information, to shutdown database with SQLPLUS, you need to have dedicated server setting on your database. Hope this is helping. Thanks
|
|
|