Re: tns error: 03505...IT WORKS!! :)

From: pheonix1t <9090pheonix1t.at_at_earthlink.net909090.oio>
Date: Thu, 20 Mar 2003 04:47:27 GMT
Message-ID: <zJbea.10403$pK4.886596@newsread1.prod.itd.earthlink.net>

Hi Patrick and Sybrand,

After following Patrick's suggestions, tnsping now works on core_office!!

What I was trying to do is use the oracle HS service to connect to a unify 6.0 database so as to "mirror" the unify on the oracle. The reason for this is to centralize the data sources for reports/management use. Trying to connect to the unify for doing reports has been a pain in the ass to put it in a short and sweet manner! The strategy is to put everything on oracle so it will be easier for making reports/development for management....just one data source to connect to...

Core_office is setup as a system DSN on a win2k server running oracle 9i using an old unify ODBC driver. For version 6.0 unify, they only have a version 1.0 ODBC driver. Now that this works...we'll see about the performance. I'm very glad to get this working though!

My best regards to Patrick and Sybrand!!

Oskar

FYI this is a final post of the settings that made this thing work.....maybe this will help someone else in the future.

# 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_OFFICE
HS_FDS_TRACE_LEVEL = OFF

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

ODBCINI=C:\WINNT\ODBC.INI
ODBCINSTINI=C:\WINNT\ODBCINST.INI

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

# 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_OFFICE)
	(ORACLE_HOME = F:\oracle\ora92)
       	(GLOBAL_DBNAME = epione.net)
       	(ENVS=LD_LIBRARY_PATH=C:\winnt\system32)
      )
     (SID_DESC =
	(SID_NAME = PCN)
	(ORACLE_HOME = F:\oracle\ora92)


       (PROGRAM = hsodbc)


      )
     (SID_DESC =
	(SID_NAME = companyinfo)
	(ORACLE_HOME = F:\oracle\ora92)
       	(PROGRAM = hsodbc)
       	(ENVS=LD_LIBRARY_PATH=C:\winnt\system32)
      )

   )

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

# 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_OFFICE.EPIONE.LOCAL= (DESCRIPTION=

                      (ADDRESS=(PROTOCOL=tcp)
                               (HOST=Cleveland)
                               (PORT=1521)
                      )
                      (CONNECT_DATA=(SID=CORE_OFFICE)
                      )
                      (HS = OK)
               )
	)

PCN= (DESCRIPTION=
                      (ADDRESS=(PROTOCOL=tcp)
                               (HOST=Cleveland)
                               (PORT=1521)
                      )
                      (CONNECT_DATA=(SID=PCN)
                      )
                      (HS = OK)
               )
	)


COMPANYINFO= (DESCRIPTION=
                      (ADDRESS=(PROTOCOL=tcp)
                               (HOST=Cleveland)
                               (PORT=1521)
                      )
                      (CONNECT_DATA=(SID=COMPANYINFO)
                      )
                      (HS = OK)
               )
	)


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

# 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)

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

Received on Wed Mar 19 2003 - 22:47:27 CST