Re: TNS-12203 unable to connect to destination

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Tue, 10 Jan 2006 08:42:54 -0600
Message-ID: <buh7s15gf6gsva9j6pne0k42t1va5gj8kg@4ax.com>

"Pradeep" <agarwalp_at_eeism.com> wrote:

>I get the the above message whenever i try to connect to the database.
>below is my listener.ora & tnsnames.ora file
>Oracle 8.0, on Win 2000
>listener.ora-> Location C:\orant\NET80\ADMIN\listener.ora
>
>LISTENER=
> (DESCRIPTION =
>
> (ADDRESS=
> (PROTOCOL= TCP)
> (Host= musn0003)
> (Port= 1521)
> )
> )
>
>SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = MX2P)
>
> )
> )
>
>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)
> )
> )
>
>I tried the following:
>
>SQL> connect scott/tiger_at_MX2P.XYZ.com
>ERROR:
>ORA-12154: TNS:could not resolve service name
>
>SQL> connect / as sysdba
>ERROR:
>ORA-12203: TNS:unable to connect to destination
>
>Please help

Use

connect scott/tiger_at_MX2P Received on Tue Jan 10 2006 - 08:42:54 CST