Home » RDBMS Server » Server Administration » insufficient prev (oracle 8i on unix)
insufficient prev [message #324193] Sat, 31 May 2008 08:06 Go to next message
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

Report message to a moderator

Re: insufficient prev [message #324195 is a reply to message #324193] Sat, 31 May 2008 08:19 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
You can directly stop the oracle services through net OS command.
cmd> net stop OracleServiceSID
and
Recreate the password file and try.


Regards
Taj

Report message to a moderator

Re: insufficient prev [message #324378 is a reply to message #324193] Mon, 02 June 2008 04:30 Go to previous message
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

Report message to a moderator

Previous Topic: Archives
Next Topic: deleting data files
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 00:39:16 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.