Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ORA-01031: insufficient privileges -- from user oracle running

ORA-01031: insufficient privileges -- from user oracle running

From: Guang Mei <gmei_at_incyte.com>
Date: Wed, 03 Sep 2003 18:29:26 -0800
Message-ID: <F001.005CEACF.20030903182926@fatcity.com>


Hi:

I have an Oracle 8173 db running on Solaris 2.8 box (called rex) and today I found something that I am trying to understand. When I login to the Unix box as user "oracle" (which I used to install oracle software), I can manaully run svrmgrl, then connect as "internal", I can do "startup" and "shutdown immediate" with no problem. I have been doing this for years.

But if I still log in as "oracle", at unix prompt I do:

rex$ which dbstart
/oracle/product/8.1.7/bin/dbstart

rex$ dbstart

SQL*Plus: Release 8.1.7.0.0 - Production on Wed Sep 3 20:57:16 2003

(c) Copyright 2000 Oracle Corporation. All rights reserved.

connect internalORA-01031: insufficient privileges connect internal
Database "YPD" warm started.
rex$ ps -ef|grep oracle
  oracle 2268 1 0 16:54:27 ? 0:00
/oracle/product/8.1.7/bin/tnslsnr LISTENER -inherit
  oracle 11195 11152 0 20:57:26 pts/2 0:00 grep oracle   oracle 11152 11150 0 20:56:19 pts/2 0:00 -sh

I know "dbstart" worked before because it was called by "auto start" script that I put in /etc/init.d/oracle and /etc/rc2.d/S99oracle last year.

I also checked /var/opt/oracle/oratab and environmental variables:

rex$ env|grep ORACLE

ORACLE_ADMIN=/oracle/admin
ORACLE_BASE=/oracle
ORACLE_HOME=/oracle/product/8.1.7
ORACLE_SID=YPD

And they seem working fine (again I can use svrmgrl without any problems).

Does anyone know where I should fix so I can start the instance by running script "dbstart"? TIA.

Guang

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Guang Mei
  INET: gmei_at_incyte.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Wed Sep 03 2003 - 21:29:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US