ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum IndexWebSphere Message Broker (ACE) SupportAccess Oracle v9.2 with WMQI 2.1 in AIX v5.2 with DB2 8.1.4

Post new topicReply to topic
Access Oracle v9.2 with WMQI 2.1 in AIX v5.2 with DB2 8.1.4 View previous topic :: View next topic
Author Message
miguelanselmo
PostPosted: Mon May 17, 2004 5:48 am Post subject: Access Oracle v9.2 with WMQI 2.1 in AIX v5.2 with DB2 8.1.4 Reply with quote

Novice

Joined: 28 Oct 2003
Posts: 15

Hi,
I have to access an Oracle v9.2 database with WMQI v2.1 that is installed on AIX v5.2 with DB2 v8.1.4.
I have read that I can use an ODBC driver that came with WMQI (UKOR818).
My question is, do I have to install any other software (any tool that came with the Oracle software) to accomplish this connection and/or configuration I have to do in “odbc.ini” file.

Any help would appreciated.
Back to top
View user's profile Send private message
JT
PostPosted: Mon May 17, 2004 6:34 am Post subject: Reply with quote

Padawan

Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.

Quote:
I can use an ODBC driver that came with WMQI (UKOR818)
That's correct.
Quote:
do I have to install any other software (any tool that came with the Oracle software)
Just the Oracle client.
Quote:
.....or configuration I have to do in “odbc.ini” file.
  • ensure tnsnames.ora has been configured properly
  • issue the mqsi_setupdatabase command
  • define the environment variables (i.e. LD_LIBRARY_PATH, ORACLE_HOME, ODBCINI, etc...)
  • establish a symbolic link, if XA coordination is a requirement
Additionally, the minimum configuration must be WMQI v.2.1.5 and MQ v5.3.4 to access Oracle v9.2 databases from AIX v5.2.
Back to top
View user's profile Send private message
miguelanselmo
PostPosted: Mon May 17, 2004 7:18 am Post subject: Reply with quote

Novice

Joined: 28 Oct 2003
Posts: 15

Thanks JT
Back to top
View user's profile Send private message
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexWebSphere Message Broker (ACE) SupportAccess Oracle v9.2 with WMQI 2.1 in AIX v5.2 with DB2 8.1.4
Jump to:



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP


Theme by Dustin Baccetti
Powered by phpBB 2001, 2002 phpBB Group

Copyright MQSeries.net. All rights reserved.