Re: Cannot AutoStart Oracle Listener (lsnrctl)

Two things to look for:

1. You put your command in "/usr/oracle/.bash_profile", this means it would be executed by user oracle, not root.

Also before this line, is $ORACLE_HOME already defined and exported?

2. You should put this line in a file (such as "S99oracle") in /etc/rc0.d directory, so it will gets executed automatically when system reboots (by root).

See oracle's installation doc for details.

HTH Guang

"Victor Lee" <nospam_at_newsranger.com> wrote in message news:JWFM6.4921$6j3.439686_at_www.newsranger.com...
> Dear sir/madam,
>
> I have just installed Oracle 8i on Slackware 7.1, and have a problem with
 the
> Oracle listener. I should appreciate for any help. The problem is this:
>
> The Oracle software installs successfully, and I can start the listner
 (using
> $ORACLE_HOME/bin/lsnrctl start) by logging in as the oracle user account.
 Then I
> want the listener to autostart on boot, so I run a script which contains
 the
> following lines:
>
> /usr/oracle/.bash_profile
> su - oracle -c "$ORACLE_HOME/bin/lsnrctl start".
>
> The second line fails with the following errors:
>
> TNS-01103: Protocol specific component of the address is incorrectly
 specified
> TNS-12541: TNS: no listener
> TNS-12560: TNS: protocol adaptor error
> TNS-00211: ...
>
> Please note that the script is run by the root user, and oracle is the
 user name
> who installs Oracle, and the .bash_profile file has established all Oracle
> environment variables ($ORACLE_HOME, $ORACLE_SID, etc.)
>
> Thank you for your kind help.
>
> Regards,
> Victor Lee
>
>
>
>
Received on Fri May 18 2001 - 23:01:29 CEST