Home » RDBMS Server » Server Administration » Using dbstart, getting error ORA-01031: insufficient privileges
Using dbstart, getting error ORA-01031: insufficient privileges [message #251396] Fri, 13 July 2007 08:02 Go to next message
vnapa
Messages: 2
Registered: July 2007
Junior Member
Hi EveryOne,

I am a newbie and have installed Oracle on Solaris platform. I am trying to start the server using dbstart and get the following error. ORA-01031: insufficient privileges.

# ./dbstart

SQL*Plus: Release 9.2.0.1.0 - Production on Fri Jul 13 08:40:51 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> ERROR:
ORA-01031: insufficient privileges


SQL> ORA-01031: insufficient privileges
SQL>
Database "testsid" warm started.

How can I solve this problem? I have no clue as to what is going wrong. I have tried re-installing as well and doesnt work. Can someone please suggest something. I am almost reaching my project deadline.

Thanks,
Vanitha
Re: Using dbstart, getting error ORA-01031: insufficient privileges [message #251399 is a reply to message #251396] Fri, 13 July 2007 08:06 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
I believe you have to run it as oracle, not root, or su -c oracle.
Re: Using dbstart, getting error ORA-01031: insufficient privileges [message #251410 is a reply to message #251399] Fri, 13 July 2007 08:30 Go to previous messageGo to next message
vnapa
Messages: 2
Registered: July 2007
Junior Member
I believe I am running as oracle. i.e I am trying to start as the unix user who installed oracle.

Thanks,
Vanitha
Re: Using dbstart, getting error ORA-01031: insufficient privileges [message #251459 is a reply to message #251410] Fri, 13 July 2007 12:20 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
check this

http://www.nyoug.org/Presentations/SIG/DBA/shutstart.PDF
Re: Using dbstart, getting error ORA-01031: insufficient privileges [message #251583 is a reply to message #251459] Sun, 15 July 2007 02:35 Go to previous message
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
Senior Member
Can you connect sqlplus?
Previous Topic: buffer pool selection
Next Topic: listener
Goto Forum:
  


Current Time: Sat Dec 03 12:27:24 CST 2016

Total time taken to generate the page: 0.04488 seconds