Re: Listener not starting up on boot in init script for 8i on Solaris 8

From: Max Sivkov <maxx_at_itprojects.net>
Date: Wed, 7 Mar 2001 10:22:09 +0200
Message-ID: <984r44$41j$1_at_hyppo.gu.net>


hi
i believe the problem is because environment variables does not set properly
may be you should use su $ORAUSER instead su - $ORAUSER, because you already set env,
my script looks like this:

cat K10oralsnrstart
#!/bin/sh
# script 4 starting/shutting oracle listener ORACLE_HOME=/usr/oracle/product/8.1.7
ORACLE_BASE=/usr/oracle
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/local/lib ORACLE_SID=ORASOL
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data NLS_LANG=RUSSIAN_UKRAINE.CL8MSWIN1251
ORACLE_OWNER=oracle
PATH=$PATH:$ORACLE_HOME/bin
LOGNAME=oracle
export ORACLE_HOME ORACLE_SID ORA_NLS33 PATH LD_LIBRARY_PATH ORACLE_BASE NLS_LANG LOGNAME
case "$1" in
'start')

        echo "Starting Oracle listener"
        if [ ! -f $ORACLE_HOME/bin/lsnrctl ]; then
                echo "could not find $ORACLE_HOME/bin/lsnrctl"
                exit
        fi
        /sbin/su  $ORACLE_OWNER -c  "$ORACLE_HOME/bin/lsnrctl start"
;;
'stop')
        echo "Stopping Oracle listener"
        if [ ! -f $ORACLE_HOME/bin/lsnrctl ]; then
                echo "could not find $ORACLE_HOME/bin/lsnrctl"
                exit
        fi
        /sbin/su $ORACLE_OWNER -c  "$ORACLE_HOME/bin/lsnrctl stop"
;;
esac

and it works fine.

--
Regards

MAXX4-RIPE
"Robert Banniza" <robert_at_rootprompt.net> wrote in message
news:ueYo6.32619$sD.2254012_at_e420r-sjo2.usenetserver.com...

> Guys,
> I need some help bad. I have a script which starts Oracle up on boot
but
[Quoted] > it does not start the Listener up via lsnrctl in the init script. Instead,
I
> have to log on as user 'oracle' and start it up manually. I get the
> following error when the script runs:
>
> ################################################################3
> LSNRCTL for Solaris: Version 8.1.7.0.0 - Production on 05-MAR-2001
20:27:24 >
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> Message 1070 not found; No message file for product=network,
> facility=TNSTNS-12545: Message 12545 not found; No message file for
> product=network, facility=TNS
> TNS-12560: Message 12560 not found; No message file for product=network,
> facility=TNS
> TNS-00515: Message 515 not found; No message file for product=network,
> facility=TNS
> Solaris Error: 2: No such file or directory
> ################################################################
>
> I have check everything that I know to check and the case 'start'
statement
> looks as so in my init script:
>
> ORA_HOME=/opt/u01/app/oracle/product/8.1.7
> ORA_OWNER=oracle
> su - $ORA_OWNER -c $ORA_HOME/bin/dbstart &
> su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start"
>
> Could someone PLEASE tell me what the hell I'm doing wrong as I have been
> struggling with this for a couple days now and it is killing me!! I looked
> through the Oracle Error Message books and found little that would help
me.
> The thing that is weird to me is that I can start this fine by sitting in
> BASH as the oracle user and running
> '/opt/u01/app/oracle/product/8.1.7/lsnrctl start' but it will not work
when
> booting up. BASH is the default shell for oracle. Any help would certainly
> be appreciated. Also, could you email me at robert_at_rootprompt.net? Thanks.
>
> Robert
>
> P.S. I'm running a patched Solaris 8 system with Oracle 8.1.7.
> > > >
Received on Wed Mar 07 2001 - 09:22:09 CET

Original text of this message