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 > > > > > [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
