Re: TNS-12203 unable to connect to destination

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 11 Jan 2006 20:41:20 +0100
Message-ID: <dq3mbp$t5f$1@news3.zwoll1.ov.home.nl>

Pradeep wrote:

> tnsnames.ora location-> C:\orant\NET80\ADMIN\listener.ora
>
> MX2P=
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = musn0003)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = MX2P.XYZ.com)
> )
> )
>

Make it:

     (CONNECT_DATA =
       (SID = MX2P)
     )

    )

8.0 did not use service_name

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Wed Jan 11 2006 - 13:41:20 CST