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@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


> 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 - 02:22:09 CST