Re: starting up lsnrctl from rc2.d...

In article <3151937B.6252_at_cnmw.com>, John Studarus <jstudaru_at_cnmw.com> writes:
|> I'm trying to get the listener to startup on boot
|> time on our SPARC Ultra 140 running Oracle 7. I added a line
|> to /etc/init.d/dbora to start it up with the following syntax:
|>
|> ORACLE_HOME=/export/oracle7/orahome
|> ORA_OWNER=oracle
|> [stuff deleted]
|> su $ORA_OWNER -c "$ORACLE_HOME/bin/dbstart" &
|> su $ORA_OWNER -c "$ORACLE_HOME/bin/lsnrctl start" &
|>
|> The script gets run out of /etc/rc2.d OK (all the
|> databases startup OK but the listener chokes). However if
|> I run dbora start by hand (as root) it runs OK! I can even
|> start lsnrctl without having the database running so the order
|> of running dbstart and then lsnrctl - or even both at the
|> same time doesn't seem to matter.
|> I wonder if it is because I don't have some of the
|> environment variables set... Anyone have a working dbora that
|> starts up the listener OK that he/she would care to share?...
|> I copied in all the environment variable but it still gave me the same
|> error message (on boot - running by hand works fine).
|>
|> Thanks,
|>
|> -John
|>
|>
|> The error message the lsnrctl returns is:
|>
|> LSNRCTL for SVR4: Version 2.2.3.0.0 - Production on 21-MAR-96 10:26:33
|>
|> Message 1070 not found; No message file for production=NETWORK,
|> facility=TNSTNS-12545: Message 1254 TNS-12560: Message 12560 not found;
|> No message file for product=NETWORK, facility=TNS TNS-00515: Message 515
|> not found; No message file for production=NETWORK, facility=TNS SVR4
|> Error: 2: No such file or directory

Try changing
su $ORA_OWNER -c "$ORACLE_HOME/bin/lsnrctl start" & to
su - $ORA_OWNER -c "$ORACLE_HOME/bin/lsnrctl start" &

That way you will get the ORACLE owners environment variables.

It works for me anyway.

Steve Received on Thu Mar 21 1996 - 00:00:00 CET