Automatic startup of listener on Solaris 8 fails !

[oracle0]

I have oracle 8i R2 on Solaris 8 Intel. I have exact same problem by which, oracle database would start with dbora script but listener would not auto start.If I try with lsnrctl start on command prompt it does start.I think it give message of "No such file or directory"
when I do " su - oracle -c "$ORACLE_HOME/bin/lsnrctl start"

Can somebody tell me what I am missing ?

Thanks for help.

[pando]

have you looked messages in /var ?

[oracle0]

Yes I have, I don't see anything strange there too.

Pando, I searched the post just below this one. And I see jiong too had this problem crop up. You can gp through it to make some sense.

I have played with TNS_ADMIN, can it be ORA_NLS33 directory.

[marist89]

Most likely, your $ORACLE_HOME is not defined...

[oracle0]

It is defined. I checked it with echo too. It is as follows:

ORA_HOME=/opt/oracle/product/8.1.6
ORA_OWNER=oracle
if [ ! -f $ORA_HOME/bin/dbstart ]
then
echo "Oracle startup: cannot start"
exit
fi
case "$1" in
start)
su - $ORA_OWNER -c $ORA_HOME/bin/dbstart
su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start"
;;
stop)
su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop"
su - $ORA_OWNER -c $ORA_HOME/bin/dbshut
;;
esac

[oracle0]

Jeff, How-come database is starting with same ORA_HOME and not listener. If you guys can look at another post by jiong, he seems to have the same problem, which Nagesh fixed by adding entry into dbstart. I don't like his solution. I think it might be bug or something. I can start listener manually but not with my script.

Any ideas !!
Oracle0

[marist89]

If you can start the listener manually but not with your script, the problem is with your script.

What does the listener.log say on startup?
What does /var/adm/messages say on startup?

[stecal]

dbstart does not work with Oracle 8.1.6. You have to modify your script. See note 98418.1 on MetaLink. Here is the header of the note:

"dbstart" is a shellscript used on Unix platforms to start databases listed in the "oratab" file. It is often called from system startup scripts.

The "dbstart" script shipped with all versions of Oracle up to and including 8.1.6 does not start any 8.1.6 instances if they are down. "dbstart" will report "Database warm started" rather than starting the instance. This problem only affects 8.1.6 (or later) instances.

[oracle0]

I know the problem of dbstart. You have to change line 64 entry to /JServer. It works fine. I am talking of lsnrctl start as part of auto start script at run level 3.

[marist89]

If you're getting "No such file or directory", then most likely your shell can't find the lsnrctl program.