-
Heterogeneous Services on 11g
Hello -
I've been trying to configure Heterogeneous Services to create a connection between an Oracle 11g database & an ODBC based database. I did the following:
1) Created a System DSN to the ODBC based database. The DSN connects to the database successfully when tested. The DSN name is HSTEST.
2) Creating initHSTEST.ora (in C:\app\me\product\11.1.0\db_1\hs\admin) as follow:
# This is a sample agent init file that contains the HS parameters that are
# needed for the Database Gateway for ODBC
#
# HS init parameters
#
HS_FDS_CONNECT_INFO = HSTEST
HS_FDS_TRACE_LEVEL = off
#
# Environment variables required for the non-Oracle system
#
#set =
3) Changed listener.ora as follow:
# listener.ora Network Configuration File: C:\app\me\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=HSTEST)
(ORACLE_HOME=C:\app\me\product\11.1.0\db_1)
(PROGRAM=dg4odbc)
)
)
4) Changed Tnsnames.ora as follow
# tnsnames.ora Network Configuration File: C:\app\me\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
HSTEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip scrubbed)(PORT = port scrubbed))
(CONNECT_DATA = (SID = HSTEST)
)
(HS = OK)
)
5) restarted the listener
6) pinged hstest and got the following error
C:\Documents and Settings\me>tnsping hstest
TNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production on 07-JUL-2009 15:59:26
Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
C:\app\me\product\11.1.0\db_1\network\admin\sqlnet.ora
TNS-03505: Failed to resolve name
C:\Documents and Settings\me>
Pls Advice
Txs
Shaf
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|