Re: Oracle Listener Stalling on Red Hat 7

We're having exactly the same problem on an Oracle 8.1.6 installation on Solaris 2.7.

Immediately after starting the listener on the db server, we can connect to the database from the client machines. However, after approx 30 - 60 seconds, the db instance "registers" itself with the listener. (The message in the listener log is "service_register".) After that, attempts to connect to the database from client machines fail with 12545. We can still connect from sqlplus running on the db server machine.

Does anyone know what causes this problem?

Thanks in advance for any help.

Tim Auckland

On Fri, 8 Dec 2000 03:27:38 -0800, "Matt Gross" <mattgross_at_yahoo.com> wrote:

>Hi everyone,
>
>I don't know if this is the best place to post this message, but I'm having
>a problem with oracle that I have loaded on my linux red hat 7. The
>listener is constantly hanging or stalling. When I try to access the
>database I keep getting oracle error 12545: ORA-12545: Connect failed
>because target host or object does not exist. However, if I bounce the
>listener (stop and restart) I have no problem connecting for a few minutes
>after, but if I wait to long then it stalls again. Does anyone know why
>this is happening?
>
>THanks,
>
>Matt
>
>
Received on Tue Jan 02 2001 - 09:50:31 CST