| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Oracle as a remote (non-broker) DB |
« View previous topic :: View next topic » |
| Author |
Message
|
| duffMan |
 Posted: Wed Feb 26, 2003 6:15 am Post subject: Oracle as a remote (non-broker) DB |
 |
|
Voyager
Joined: 03 Jun 2002
Posts: 75
|
I'm running wmqi2.1 csd2 on AIX and am attempting to connect to a remote Oracle DB.
Is it necessary to install the Oracle Client for AIX SQL*Net and configure tnsnames.ora OR is the ODBC Merant driver UKor816.so suffice with the appropriate .odbc.ini entries? |
|
| Back to top |
|
 |
| alpya |
| Posted: Thu Feb 27, 2003 10:58 am Post subject: Oracle as a remote (non-broker) DB |
|
|
Newbie
Joined: 24 Apr 2002
Posts: 3
|
Hi Duffman,
In order to connect to a Remote Oracle DB you need to install Oracle Client. Here in your case its on AIX. After installation of Client define the tnsnames for the remote DB and update the .odbc.ini file for the broker with the Alias name.
Here is an Example on how you can define it in .odbc.ini
[SAMPLE]
Driver=/usr/opt/mqsi/merant/lib/UKor816.so
Description=Oracle8
ServerName=sample
EnableDescribeParam=1
OptimizePrepare=1
Also, you need to have symbolic links created for WMQI. This involves running of mqsi_setupdatabase. This whole process is explained in Chapter 3 of Install guide. In guide its explained for DB2, you have to run it for all the databases
After mqsi_setupdatabase is successfully executed verify under /var/wmqi/lib directory (ls -al) it should have softlinks to libclntsh.a |
|
| Back to top |
|
|
| duffMan |
| Posted: Thu Feb 27, 2003 1:38 pm Post subject: |
|
|
Voyager
Joined: 03 Jun 2002
Posts: 75
|
Thanks alpya, I have another question:
If the name of the entry in my tnsnames.ora file is "ABC" with the remote ip and port, then what goes in "ServerName" of the .odbc.ini entry.
When I ready "ServerName" I immediately thought ip and port, but now I'm guessing that is where I put "ABC"????
later. |
|
| Back to top |
|
|
| alpya |
| Posted: Thu Feb 27, 2003 1:57 pm Post subject: |
|
|
Newbie
Joined: 24 Apr 2002
Posts: 3
|
| yes at the servername put the alias name 'ABC' that you are referring to.. |
|
| Back to top |
|
|
| duffMan |
| Posted: Fri Feb 28, 2003 10:05 am Post subject: |
|
|
Voyager
Joined: 03 Jun 2002
Posts: 75
|
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
