-
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
|