OraFAQ Forum: Server Administration » Using dbstart, getting error ORA-01031: insufficient privileges

Home » RDBMS Server » Server Administration » Using dbstart, getting error ORA-01031: insufficient privileges

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Using dbstart, getting error ORA-01031: insufficient privileges [message #251396]

Fri, 13 July 2007 08:02

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

Report message to a moderator

Re: Using dbstart, getting error ORA-01031: insufficient privileges [message #251399 is a reply to message #251396]

Fri, 13 July 2007 08:06

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

I believe you have to run it as oracle, not root, or su -c oracle.

Report message to a moderator

Re: Using dbstart, getting error ORA-01031: insufficient privileges [message #251410 is a reply to message #251399]

Fri, 13 July 2007 08:30

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

Report message to a moderator

Re: Using dbstart, getting error ORA-01031: insufficient privileges [message #251459 is a reply to message #251410]

Fri, 13 July 2007 12:20

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

check this

http://www.nyoug.org/Presentations/SIG/DBA/shutstart.PDF

Report message to a moderator

Re: Using dbstart, getting error ORA-01031: insufficient privileges [message #251583 is a reply to message #251459]

Sun, 15 July 2007 02:35

yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait

Senior Member

Can you connect sqlplus?

Report message to a moderator

Previous Topic:	buffer pool selection
Next Topic:	listener

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 22:49:21 CDT 2024