Re: ora-12545

In our last gripping episode "/dev/null" <bitbucket0611_at_hotmail.com> wrote:
> Grasshopper :-P
>
> Just some thoughts :
> - is the server behind some sort of a firewall?
> - are you using MTS (Multi Threaded server)?
>
> > i am able to connect
> > successfully immediately after the listener is started, but if i
> > disconnect and wait a minute or so then attempt to connect again i
 get
> > ORA-12545
> On the same machine, the server or a client?
>

A client machine, as was stated in the original post:

'i have set up a new 8i database on solaris 2.7 and i am having difficulty connecting from a client machine.'

> > nttbnd2addr: port resolved to 37561
> > nttbnd2addr: looking up IP addr for host: thrash.maxor.com
> > nttbnd2addr: *** hostname lookup failure! ***
> Clearly indicates that it's some sort of a network problem. Do you
 have the
> same problems on the server using sql*net?
> #>sqlplus un/pw_at_sid
>
> Try pinging thrash.maxor.com from the client, maybe it is a DNS
 problem.
>

This is not likely, since the IP address (which requires no DNS translation) is used in both the listener.ora and tnsnames.ora files.

> More questions than answers but it might give you a hint. Good luck.
>
> Rob.
>
>

I agree, however, that it appears to be a network issue, not an Oracle listener issue. I would have the network checked.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/