Re: oracle listener doesnot startup automatically

You can put the
su - database -c "/database/installation/bin/lsnrctl start" this command after you start the database or put a sleep between these 2 statements. if you have any questions, let me know.

Good Luck
Chandra
OCP DBA "Giorgos Tsiamitas" <gtsiam_at_gmx.net> wrote in message news:<a%2T6.136$8i.6476_at_nreader1.kpnqwest.net>...
> 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 - 07:24:20 CDT