Re: ORA-12545 Error...

I found that I have a short period can connect to Server in my situation. When the Oracle server is just Restart, within this period(about 10 seconds), I can connect to that from client. After this period, I can't connect again any more until I restart the database again.

If say my setting is wrong, it should ALWAYS reject my connection request. Now, I can SOMETIMES connect with it. It is very unstable.

Why so stranger?? What's wrong of my setting?

--
Best regards,
Diviner.




> On Thu, 31 May 2001 16:21:45 +0800, Diviner <diviner_at_hknet.com> wrote:

>

> >I am using Oracle8i 8.1.7 for NT and running on Windows 2000 Server,

> >NT4 Workstation for client machine and has a connection problem.

> >Hope someone can help me.

> >

> >The main problem is this error:

> >   "ORA-12545: Connect failed because target host or object does not

> >exist"

> >when I try to connect Oracle Server from client machine.

> >

> >Let me state my situation point by point:

> >- Oracle server is started up and work normally.

> >- Oracle client on the same machine(server machine) work well by

> >sqlplus.

> >   e.g.: sqlplus scott/tiger_at_prj1 (follow by successful connection)

> >- Oracle client on the other machine(client machine) can tnsping on both

> >

> >   alias and service_name successfully.

> >- ORA-12545 error occur when I use sqlplus to connect Oracle server from

> >

> >   client machine.

> >

> >Thank you very much.

>

> tnsping *only* guarantees there is a listener running on the host

> you're trying to connect to.

> There must be a mismatch between tnsnames.ora (on the client) and

> listener.ora on the server.

> It works on the server because you have ORACLE_SID set, and use IPC

> automatically.

>

> Check the tnsnames.ora on the client.

>

> Hth,

>

> Sybrand Bakker, Oracle DBA