Re: Problem connecting to db

A little more info...

TNSPing from the client machine *does* work.

Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=tatooine)(PORT=1521)) OK (140 msec)

I also changed tnsnames.ora on the client machine to use the actual IP address, but that didn't do the trick.

An additional piece of info... there are multiple databases running on the server. But that doesn't explain why I'm able to connect immediately after starting the listener but not moments afterward.

Dan wrote:

> Thanks in advance for your help.
>
> I'm experiencing the following strange problem:
>
> Immediately after starting up the listener, I am able to connect to my
> database from another machine on the network using either SQL*PLUS or
> JDBC. However, after a minute or so, I cannot form new database
> connections, instead getting
>
> ORA-12545: Connect failed because target host or object does not exist
>
> Then I must restart the listener to form new connections, and again
> after less than a minute, I am no longer able to form new connections,
> again getting ORA-12545.
>
> Any help you can give is greatly appreciated.
>
> Regards,
> Dan Hess
Received on Mon Oct 02 2000 - 13:29:11 CDT