Re: Listener issue

It is generally a good practice to start the Listener first, then the database instances..That way they can self-register with the listener and you do not need to edit the listener.ora file every time you add an instance - the initial listener.ora file can be very minimal with regards to services info , just the External Proc stuff AFAIK..

faisal_qasim_at_my-deja.com (Faisal Qasim) wrote:

>Thanks for the responses.
>
>Listener start is at the end of 'dbstart' script, so database should
>be up at that time. Further this problem occurs very rarely and
>listener log doesn't show any error for auto listener start.
>
>Is there anything else, I can check?
>
>Regards
>
>Karsten Farrell <kfarrell_at_medimpact.com> wrote in message news:<oaVt9.323$jg.28783971_at_newssvr13.news.prodigy.com>...
>> Faisal Qasim wrote:
>> > Dear All,
>> >
>> > Listener on Oracle 7.3 on AIX 4.3.3 sometimes doesn't work at boot up.
>> > Though listener process is started but listener refuses connection.
>> > Manual start of listener resolves the issues. As you can see in log
>> > below listener doesn't return any error.
>> >
>> > What is going wrong, what should I check? I will be grateful for any
>> > hints.
>> >
>>
>> It's hard to tickle those brain cells in my long-term memory where I
>> stored all that 7.3 stuff ... and I was on Solaris, not AIX. If I
>> remember correctly, we had to put "waits" in some of our boot scripts.
>> Sometimes databases and listeners start up more or less rapidly for any
>> given boot. Sometimes the database didn't shut down nicely and had to do
>> some automatic recovery when it came up, so the listener got started
>> before the database. If you manually start your listener, chances are
>> pretty good that you're a bit slower than your AIX box, so the database
>> is already started.
>>
>> You might compare the timestamps in your listener log against your alert
>> log to see if this might be happening.
>>
>> Like I said, it's been a very long time and my memory ain't what it used
>> to be (sung to the tune of 'Old Gray Mare').

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Fri Oct 25 2002 - 08:59:49 CDT