Re: ORA-12545 Error...

From: Diviner <diviner_at_hknet.com>
Date: Fri, 01 Jun 2001 11:54:30 +0800
Message-ID: <3B1711F6.53C290C5@hknet.com>

I tried to modified the listener.ora on server side. I got success to connect it
by several time. But I don't know why, after a day, it has error again! My listener.ora like this:
# LISTENER.ORA Network Configuration File: c:\oracle\ora81\network\admin\listener.ora # Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = cpnt2ksrv2)(PORT = 1521))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\oracle\ora81)
(PROGRAM = extproc)

    )
  )

I can ping "cpnt2ksrv2" from server side ITSELF, the result is correct. I have also
changed HOST to a host name which can ping from client side, but still not work.
(for example, I set "prj1" host name in HOSTS file on both server and client side
to point to the server IP and then change the HOST parameter in listener.ora to "prj1"
and restart the listener service).

My "tnsnames.ora" like this:
# TNSNAMES.ORA Network Configuration File: D:\Oracle\Ora81\NETWORK\ADMIN\tnsnames.ora # Generated by Oracle configuration tools.

PRJ1.CYBERPROJECT.NET =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = prj1)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = prj1.cyberproject.net)
    )
  )

On try and error stage(connect Server from Client by SQLPLUS for many and many times),
I strange to say that why meet the error for just 3 times: "TNS-12514 TNS:listener could not resolve SERVICE_NAME given in connect descriptor"

I have no make any changes on anything. I keep in try SQLPLUS and then I got the old error
again(at lease this error may be more properly): "ORA-12545: Connect failed because target host or object does not exist"

Now, I still get rid for this ORA-12545 error. Would you tell me more about this and
the trouble-shooting approach?

Thank you very much.

--
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

Received on Thu May 31 2001 - 22:54:30 CDT