Re: Client connect gets ORA-12545: Connect failed for Oracle 8i listener

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Wed, 13 Mar 2002 05:41:05 GMT
Message-ID: <3c8ee4e4.2119137@news.saix.net>

timasmith_at_hotmail.com (Tim Smith) wrote:

>ORA-12545: Connect failed because target host or object does not exist
>
>6) tnsping new8i or tnsping80 new8i both come back with OK

tnsping simply checks the listener and port. It does not check if the database instance itself is up and reachable. So tnsping is pretty meaningless in checking anything beyond the availibility of the listener.

The above error can be caused when trying to talk to a database instance via the listener, about which the listener do not know anything about.

>new8i.org.com =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 90.0.0.1)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = new8i)
> )
> )

Replace the (SERVICE_NAME = new81) name entry with (SID = heat) and see if that does it.

--
Billy

Received on Tue Mar 12 2002 - 23:41:05 CST