cannot shutdown database sqlplus
The database is running. I run in sqlplus :
> connect system/manager
> shutdown normal
Get message -
Ora-01031 Insufficient privileges
system doesnt have priveleges to shutdown a database as the message tells you, log in as a user with sysdba privelges
(sqlplus "/ as sysdba") or go find a real dba
connecting as sysdba gives the same error !
then obviously you havent connected as sysdba (and I dont mean sys)
Which O.S.?
If it is Windows NT or 2000, username (O.S. login) has to be as part of ORA_DBA group.
not if you have a password file, then you can log in with any username listed in that file
The database is running on the local machine.
I want to shutdown the database using sqlplus
OS - windows 98
Oracle 8i personal edition
init.ora : remote_login_passwordfile = exclusive
SQL> connect / as sysdba
ERROR:
ORA-01031: insufficient privileges
I also tried
SQL> connect sys/change_on_install
Connected.
SQL> shutdown normal
ORA-01031: insufficient privileges
i said sys wont work!
do
sqlplus internal
Goto command prompt.
then type
C:\>svrmgrl
Oracle Server Manager Release 3.1.5.0.0 - Production
(c) Copyright 1997, Oracle Corporation. All Rights Reserved.
Oracle8i Release 8.1.5.0.0 - Production
With the Java option
PL/SQL Release 8.1.5.0.0 - Production
SVRMGR> connect internal
Connected.
SVRMGR>shutdown normal;
This will shutdown the database properly.
Paresh
Connecting as "internal" worked
thanks davey
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
Bookmarks