tns error 03505, trying to get hsodbc to work

From: pheonix1t <9090pheonix1t.at_at_earthlink.net909090.oio>
Date: Tue, 18 Mar 2003 17:43:16 GMT
Message-ID: <UUIda.6956$pK4.666923@newsread1.prod.itd.earthlink.net>

hello,
I'be been trying to get hetero. services to work on a 9i for the past week or so during free time and I've been having trouble making it work. I've pasted the configs. from sqlnet.ora, listener.ora and tnsnames.ora. When I do a tnsping of localhost or epione it works fine, when I try to do a tnsping of core_office1 it times out and gets an error saying it can't resolve the name.
I've setup the odbc in the system DSN. I know it works through coldfusion but I need to make it work on oracle! I've also pasted the inithsodbc.ora file.

# SQLNET.ORA Network Configuration File: F:\oracle\ora92\network\admin\sqlnet.ora # Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = epione.local

SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

# LISTENER.ORA Network Configuration File: F:\oracle\ora92\network\admin\listener.ora # Generated by Oracle configuration tools.

LISTENER =
   (DESCRIPTION_LIST =

     (DESCRIPTION =


       (ADDRESS_LIST =

         (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
       )


       (ADDRESS_LIST =

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

   )

SID_LIST_LISTENER =
   (SID_LIST =

     (SID_DESC =


       (SID_NAME = PLSExtProc)

       (ORACLE_HOME = F:\oracle\ora92)

       (PROGRAM = extproc)

     )
     (SID_DESC =


       (GLOBAL_DBNAME = epione.net)

       (ORACLE_HOME = F:\oracle\ora92)

       (SID_NAME = epione)

     )
     (SID_DESC =
     (SID_NAME = CORE_OFFICE1)
     (ORACLE_HOME = F:\oracle\ora92)


       (PROGRAM = core_office1)


      )

   )

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

# TNSNAMES.ORA Network Configuration File: F:\oracle\ora92\network\admin\tnsnames.ora # Generated by Oracle configuration tools.

INST1_HTTP.EPIONE.LOCAL =
   (DESCRIPTION =

     (ADDRESS_LIST =


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

     )
     (CONNECT_DATA =


       (SERVER = SHARED)

       (SERVICE_NAME = MODOSE)

       (PRESENTATION = http://HRService)

     )

   )

EPIONE.EPIONE.LOCAL =
   (DESCRIPTION =

     (ADDRESS_LIST =


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

     )
     (CONNECT_DATA =


       (SERVER = DEDICATED)

       (SERVICE_NAME = epione.net)

     )

   )

EXTPROC_CONNECTION_DATA.EPIONE.LOCAL =
   (DESCRIPTION =

     (ADDRESS_LIST =


       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

     )
     (CONNECT_DATA =


       (SID = PLSExtProc)

       (PRESENTATION = RO)

     )

   )

CORE_OFFICE1= (DESCRIPTION=

                      (ADDRESS=(PROTOCOL=tcp)
                               (HOST=cleveland)
                               (PORT=1521)
                      )
                      (CONNECT_DATA=(SID=CORE_OFFICE1)
                      )
                      (HS = OK)
               )
     )

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

# This is a sample agent init file that contains the HS parameters that are # needed for an ODBC Agent.

#
# HS init parameters
#

HS_FDS_CONNECT_INFO = CORE_OFFICE1
HS_FDS_TRACE_LEVEL = ON

#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>

That's all I have, I've tried changing some things a few times.....looked on the newsgroup archives in google and set this up as close as possible to what others seemed to be sucessful with...but in my case so far no luck.

ps. I don't know if this would matter, but the odbc driver is an old unify 6.0 version 1. My next step would be to load a modern but generic driver to see if it can connect to unify. From what you guys see, am I on the right path?

Thanks!

Oskar Received on Tue Mar 18 2003 - 11:43:16 CST