Re: Listener issue

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'). Received on Thu Oct 24 2002 - 11:25:56 CDT