Home » Developer & Programmer » Warehouse Builder » owb integration with db2 (oracle 10g)
owb integration with db2 [message #313888] Tue, 15 April 2008 01:13
aravindmech
Messages: 7
Registered: April 2008
Location: bangalore
Junior Member

can any body help me out how to solve this
is it necessary to keep the orck sid along with db2 sid in listener and tnsnames.ora files..

I have created a system dsn named : TB700IP1

And my INIT.ora file look like this: and i have named it as initTB700IP1

# 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 = TB700IP1
HS_FDS_TRACE_LEVEL = 0

#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>
And my Listener.ora file

# listener.ora Network Configuration File: E:\oracle\product\10.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENERTB700IP1 =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=ibexiHp21)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))

SID_LIST_LISTENERTB700IP1=
(SID_LIST=
(SID_DESC=
(SID_NAME=TB700IP1)
(ORACLE_HOME = E:\oracle\product\10.1.0\db_1)
(PROGRAM=hsodbc)
)
)

And my tnsnames.ora file look like:

# tnsnames.ora Network Configuration File: E:\oracle\product\10.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

TB700IP1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = TB700IP1)
)
(HS = OK)
)

so please let me know how to connect it ..
if you have any documents regarding this
please help out in this it has really taken my weeks time still not solved

regards
arvind
Previous Topic: Constraint not reflected in Match By Constraint pulldown
Next Topic: Connecting to db2 source from OWB through Generic connectivity
Goto Forum:
  


Current Time: Thu Apr 24 05:49:51 CDT 2014

Total time taken to generate the page: 0.16569 seconds