Re: Problem connecting to db

could it be a timing problem?
After all services are up and running, all clients can start new connections, etc, etc, maybe your app simply times out too fast, and reports bogus. I have similar problems with some caching proxies - reload does the trick then, but that too is a timing problem.

hth, Frank

Dan wrote:

> 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 - 15:21:37 CDT