Re: oracle listener doesnot startup automatically

comments embedded

"Sunil Dua" <sdua_at_solutionsny.com> wrote in message news:bc03ebd5.0106042033.553d93e9_at_posting.google.com...
> Hello,
>
> Thanks for the reply, Well my problem is when i execute it by giving
> the command
>
> $/etc/init.d/lsnrstart
>
> from the command line after login as root it runs successfully..

try testing from the command line as the "database" user as in your /etc/init.d/lsnrstart script. If this doesnt work and you cannot resolve it, then - since you test as root and works - change /etc/init.d/lsnrstart as

    /database/installation/bin/lsnrctl start instead of

    su - database -c "/database/installation/bin/lsnrctl start"

Beware that running commands at boot time, it is assumed that these commands do not ask for input from the terminal. So, a possible reason for the failure of your script could be that you have set a password for the listener. (The listener doesnt ask for the password when you run it interactively or at boot time as the oracle software owner).

> what I could work out after seeing this is that when it goes for starting
> the listener it does not find a database.... as the database is in the
> process of startup..

Usually it doesnt matter if the database is up or down; the listener can start regardless of the database status. Listener and database are distinct and independent components. The only case where the sequence of startup matters is in multi-threaded server configuration.

>
> Is it posible? as I am starting oracle as S97Oracle and listener
> after it as S98Listnr....

Yes, it is possible: it could be a bug (or misconception?). Normally you should have just 1 script for all oracle related startup tasks. It's more manageable. Though, if you have multiple Oracle products, then you should have 1 script per product.

> second, I donot know where it keeps the log of boot time... so pls.
> suggest how to extract the log for futher investigation.

Listener keeps a log in $ORACLE_HOME/network/log/listener.log Listener trace (if enabled) is in $ORACLE_HOME/network/trace/listener.trc Solaris log is in /var/log/syslog

> thanks & regards
> Sunil Dua
>

Regards,
Giorgos Received on Tue Jun 05 2001 - 06:02:30 CDT