Home » RDBMS Server » Networking and Gateways » Connecting to db2 source from OWB through Generic connectivity (oracle 10g 10.1,OWB 10.1,DB2 v9.1 express edition)
Connecting to db2 source from OWB through Generic connectivity [message #314329] Wed, 16 April 2008 06:31 Go to next message
aravindmech
Messages: 7
Registered: April 2008
Location: bangalore
Junior Member
Sad
I am using db2 V9.1 express edition and OWB 10.1 on Windows. I am able to connect OWB to a Oracle data source. However, when I try to connect to a db2 datasource from OWB, I get the following errors

I have created a System dsn named TB700IP1

My INITTB700IP1.ora file ........

# 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 = off


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

My Listener.ora file.....
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.1.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = PNPKEY))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ibexiHp21.ibexi.com)(PORT = 1521))
)
)
)

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

My Tnsnames.ora file......
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ibexiHp21.ibexi.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = PNPKEY))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)


TB700IP1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ibexiHp21.ibexi.com)(PORT = 1521))
)
(CONNECT_DATA =
(SID = TB700IP1)
)
(HS = OK)
)



LISTENERTB700IP1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = PNPKEY))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ibexiHp21.ibexi.com)(PORT = 1521))
)
)
)




What have I missed? Please help.
Re: Connecting to db2 source from OWB through Generic connectivity [message #314347 is a reply to message #314329] Wed, 16 April 2008 07:30 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
> I get the following errors
OK, I am old & going blind.
Errors? What errors? Which errors did I not see?
Re: Connecting to db2 source from OWB through Generic connectivity [message #314501 is a reply to message #314347] Wed, 16 April 2008 23:26 Go to previous messageGo to next message
aravindmech
Messages: 7
Registered: April 2008
Location: bangalore
Junior Member
Hi
the error that i am getting is Failed to resolve tnsnames...
Can you please help me out in this..

LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias listenerTB700IP1
Version TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Produ
ction
Start Date 17-APR-2008 09:51:17
Uptime 0 days 0 hr. 3 min. 10 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File E:\oracle\product\10.1.0\db_1\network\admin\listener.o
ra
Listener Log File E:\oracle\product\10.1.0\db_1\network\log\listenertb70
0ip1.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\PNPKEYipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ibexiHp21.ibexi.com)(PORT=1521)))
Services Summary...
Service "TB700IP1" has 1 instance(s).
Instance "TB700IP1", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> exit

C:\>tnsping TB700IP1

TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 17-APR-2
008 09:55:30

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:

TNS-03505: Failed to resolve name

C:\>

Regards arvind...
Re: Connecting to db2 source from OWB through Generic connectivity [message #314515 is a reply to message #314501] Thu, 17 April 2008 00:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
TNS-03505: Failed to resolve name
 *Cause:  The service name you provided could not be found in TNSNAMES.ORA,
          an Oracle Names server, or a native naming service.
 *Action: Verify that you entered the service name correctly.  You may need
          to ensure that the name was entered correctly into the network
          configuration.

Regards
Michel
Re: Connecting to db2 source from OWB through Generic connectivity [message #314518 is a reply to message #314515] Thu, 17 April 2008 00:57 Go to previous message
aravindmech
Messages: 7
Registered: April 2008
Location: bangalore
Junior Member
Hi,

I have sent you my TNSnames.ora file and listener.ora file and inithsodbc.ora files.. along with my post ..
i have mentioned the name in my tnsnames.ora file..
is their any other place where i have to check for this apart from oracle_home/network/admin..
in my sqlnet.ora file the entries are like ..

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

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
do you want me to check anything else...
i am not able to resolve can you breif me more about this in detail....
checked my telnet connectivity it is working fine.. my odbc connection is working fine...
so what measure can i take now..

thanking you
arvind..

Previous Topic: owb integration with db2
Next Topic: OID Setup
Goto Forum:
  


Current Time: Sun Dec 04 15:05:02 CST 2016

Total time taken to generate the page: 0.14667 seconds