TNSPing 03505 Error

From: <tim.pascoe_at_cciw.ca>
Date: 15 Aug 2005 13:44:21 -0700
Message-ID: <1124138661.467095.136330@g43g2000cwa.googlegroups.com>

I've looked through the archives of the group, and seen lots of posts on this, but none have solved my problem yet.

I have the Oracle 9i client installed on a machine, in order to provide connectivity to a SQL-Server box. I will be creating linked servers in SQL-Server to several different Oracle instances.

I originally installed the 10g client, but discovered that it will not connect to one of the legacy Oracle installations (8.1 I believe), so uninstalled it and installed 9i.

I am able to connect to the Oracle instances using the Net Manager just fine, but when I try and TNSPING to one of the TNSNAMES entries, I get the 035050 error. The Linked server in SQL-Server is also unable to make the cnnection, but provides very little in the way of usable error message.

The sqlnet and tnsnames files are below:

NAMES.DEFAULT_DOMAIN = ontario.int.ec.gc.ca

SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES) PYR =
   (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = frodo)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = frodo)(PORT = 1522))

    )
(CONNECT_DATA = (SERVICE_NAME = as03.pyr.ec.gc.ca))
   )
   (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = drake)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = drake)(PORT = 1522))

    )
(CONNECT_DATA = (SERVICE_NAME = as02.pyr.ec.gc.ca))
   )
 )

ACBIS =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 131.235.28.21)(PORT = 1521))     )
(CONNECT_DATA =

      (SID = ATST)
    )
  ) Received on Mon Aug 15 2005 - 15:44:21 CDT