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

OK, I found the problem. It was due to Bug Number 923077 (see metalink Doc ID: Note:110901.1).

Guang

On Wed, 3 Sep 2003, Dave Hau wrote:

> Make sure you have the sticky bit set for the oracle executable:
>
> chmod u+s $ORACLE_HOME/bin/oracle
>
> HTH,
> Dave
>
>
>
>
> gmei_at_incyte.com wrote:
> > 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: Dave Hau
> INET: davehau123_at_netscape.net
>
> 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).
>

-- 
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).