Home » Developer & Programmer » Warehouse Builder » owb integration with db2 (oracle 10g)
owb integration with db2 [message #313888] Tue, 15 April 2008 01:13
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

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


(ORACLE_HOME = E:\oracle\product\10.1.0\db_1)

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 =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(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

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: Tue Oct 25 09:41:11 CDT 2016

Total time taken to generate the page: 0.08529 seconds