insufficient prev [message #324193] |
Sat, 31 May 2008 08:06 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
seema.taunk
Messages: 96 Registered: October 2006
|
Member |
|
|
Dear all,
I am facing this error. what colud be issue??
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
oracle /home/oracle > sqlplus
SQL*Plus: Release 8.1.7.0.0 - Production on Sat May 31 18:31:00 2008
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SQL> shutdown immediate
ORA-01031: insufficient privileges
|
|
|
|
Re: insufficient prev [message #324378 is a reply to message #324193] |
Mon, 02 June 2008 04:30 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
msriram123
Messages: 11 Registered: May 2008 Location: Hyderabad
|
Junior Member |
|
|
I would usually do the follwing:
1. Login into OS as oracle
2. Set the environment variable ORACLE_SID to the SID of the database instance you want to shutdown.
2. prompt> sqlplus /nolog
3. SQL> connect / as sysdba
4. SQL> shutdown immediate
|
|
|