| Author |
Message
|
| jlalbor |
 Posted: Thu Aug 25, 2005 3:19 pm Post subject: Setting up ODBC for a remote Oracle database connection |
 |
|
Apprentice
Joined: 18 Feb 2003
Posts: 38
|
We have the following environment:
AIX 5.1
WMQBI v 5.0 CSD 5
WMQ 5.3 CSD 8
DB2 8.1 fixpack 4
We need to update some data in a table in a remote Oracle database (AIX also),
so we are trying to define an ODBC connection to the database in the ODBC.ini file. We found in the documentation that we need to define the $ORACLE_HOME environment variable, and that in the ODBC.ini we need to set the ServerName property to a tns orecle file.
The question here is, do we must install the oracle client in the broker machine? If the answer is yes, why do we need the oracle client for if the Broker comes with the Merant Driver for Oracle,
why is this driver for if we need to install the oracle client?.
I would like to think that the driver should be all we need to create the ODBC connection.
Reading the broker documentation i can not find an example to set up a ODBC to a remote oracle database, all i found about oracle is assuming that Oracle Database is installed in the Broker machine.
Where in the documentation explains that i need to install the Oracle Client?
Hope anyone can help me on this.
Thanks. |
|
| Back to top |
|
 |
| JT |
| Posted: Thu Aug 25, 2005 7:19 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
An excerpt from the documentation titled Defining an ODBC connection on UNIX systems
| Quote: |
If you are going to access Oracle databases on AIX or Solaris, you must set up symbolic links:- On AIX:
ln -s <ORACLE_INSTALL_DIR>/lib/libclntsh.a /usr/lib/libclntsh.so
- On Solaris:
ln -s <ORACLE_INSTALL_DIR>/lib/libclntsh.so /usr/lib/libclntsh.a
(where <ORACLE_INSTALL_DIR> is the directory in which Oracle is installed on your system). |
Also, without the client, how would the Data Source name located in the .odbc.ini file resolve to the name/ipaddress of the server that houses the remote Oracle databases ? This is accomlished through the use of the tnsnames.ora file, which is included in the Oracle client. |
|
| Back to top |
|
|
| Ian |
| Posted: Fri Aug 26, 2005 2:55 am Post subject: |
|
|
Disciple
Joined: 22 Nov 2002
Posts: 152
Location: London, UK
|
I am not aware of any WBIMB v5 topics, SOE requirements or README notes that explicitly state that the broker must have a database client installed which is local to the broker.
If you read all the WBIMB v5 docs which related to database configuartion then this point is implicit.
In answer to your question, yes, you must install an Oracle client local to the broker if you wish to acess a remote Oracle server.
In these Broker environments, our statement of support for databases refers to the database client.
It is possible to have an application access a remote Oracle server without the need for a local Oracle client. However, the WBIMB v5 broker uses the DataDirect ODBC 4.1 Oracle drivers to access Oracle and these require an Oracle client to be installed. You must then configure the client and server connections as per the Oracle requirements.
The points made by JT are applicable as well.
_________________
Regards, Ian |
|
| Back to top |
|
|
| jlalbor |
| Posted: Fri Aug 26, 2005 7:55 am Post subject: Thanks |
|
|
Apprentice
Joined: 18 Feb 2003
Posts: 38
|
Thank you very much for the orientation on this.
We will then install the Oracle Client in the broker´s machine.
I was thinking that maybe because the oracle Driver was form Merant, it included all needed in order to establish a connection with an Oracle database, like the Sybase driver also included with the broker.
Thanks for your support. |
|
| Back to top |
|
|
| JT |
| Posted: Fri Aug 26, 2005 8:27 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
Just in case you weren't aware:
| Quote: |
The Broker is a 32-bit application and interacts with 32-bit database libraries. In these Broker environments, our statement of support for databases refers to the database client.
The Broker supports connecting to a 32-bit database client which connects to a 64-bit server.
The Broker does not support connecting to a 64-bit database client. This restriction is imposed by both the Broker and the DataDirect drivers.
Oracle 9i installs both 64-bit and 32-bit libraries, with the 64-bit libraries as the default. For example, the 64-bit libraries are installed in the ${ORACLE_HOME}/lib directory and the 32-bit libraries are installed in the /lib32 directory. The customer must configure the Broker environment to use the 32-bit libraries (using mqsi_setupdatabase) |
|
|
| Back to top |
|
|
| jlalbor |
| Posted: Fri Aug 26, 2005 8:56 am Post subject: Oracle Client Version |
|
|
Apprentice
Joined: 18 Feb 2003
Posts: 38
|
Thanks JT for the hint, thats an important thing to consider.
Do you know if the broker works with the 10g Oracle client version? |
|
| Back to top |
|
|
| JT |
| Posted: Fri Aug 26, 2005 9:02 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
Currently, Oracle 10G is only supported on the Linux platform.
We're all hoping V6 extends this support to the remaining platforms. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Aug 26, 2005 9:07 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| JT wrote: |
Currently, Oracle 10G is only supported on the Linux platform.
We're all hoping V6 extends this support to the remaining platforms. |
I'm sure, given previous statements that this support is "in lifecycle testing", that some FP level of v6 will. And possibly/probably a similarly timed FP of v5 will.
Whether or not this will happen in time for the GA of v6 is a different story.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| cross_worlds |
| Posted: Sun Oct 09, 2005 10:13 am Post subject: |
|
|
Apprentice
Joined: 29 Dec 2004
Posts: 27
|
we already have wbimb broker v5 created and i used mqsi_setupdatabase during intial broker set up with oracle db.
but i did not point it /lib32 directory .... instead pointed it just the ORACLE_HOME directory.
i have this lib32 path info included into the LD_LIBRARY_PATH of profile.sol (dont feel correct doing this)
my concerns are,
do i need to change this ld-library-path and remove it and
how would i change the broker to use 32-bit libraries ?? |
|
| Back to top |
|
|
| Ian |
| Posted: Mon Oct 10, 2005 8:20 am Post subject: |
|
|
Disciple
Joined: 22 Nov 2002
Posts: 152
Location: London, UK
|
Oracle 9i installs both 64-bit and 32-bit libraries, with the 64-bit libraries as the default.
For example, the 64-bit libraries are installed in the ${ORACLE_HOME}/lib directory and the 32-bit libraries are installed in the /lib32 directory.
You must configure the Broker environment to use the 32-bit libraries (using mqsi_setupdatabase)
Effectively the /lib32/ must appear before the /lib/ library ensuring the 32-bit libraries are found first.
_________________
Regards, Ian |
|
| Back to top |
|
|
| cross_worlds |
| Posted: Mon Oct 10, 2005 8:38 am Post subject: |
|
|
Apprentice
Joined: 29 Dec 2004
Posts: 27
|
Ian
I came to know your point from earlier postings in this thread.
I should have restated my question clearly,
1) can I run the mqsi_setupdatabase command on a broker which is already created pointing to /lib32 folder ?
2) before creating the broker- i included the Oracle's /lib32 path info for the LD_LIBRARY_PATH parameter in the profile.sol.... should I remove that or leave it as such ?
3) In general, should I include lib32 information in profile.sol file for LD_LIBRARY_PATH ?
this is wbimb5 environment running on Solaris connecting to a remote oracle server 9i using oracle client ....... |
|
| Back to top |
|
|
| johnnymac |
| Posted: Wed Jan 18, 2006 9:12 am Post subject: |
|
|
Newbie
Joined: 18 Jan 2006
Posts: 2
|
Oracle 10g also has 32bit libraries and I haven't seen a solid reason as to why it will not work other than the library issue.
Can anyone clarify. |
|
| Back to top |
|
|
| JT |
| Posted: Wed Jan 18, 2006 1:22 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| In this thread, Ian wrote: |
3. WBIMBv5.0 uses the DataDirect 4.1 Oracle driver which does not support Oracle 10g
4. It is my understanding that in Oracle 10g they have changed the way LOB datatypes are defined/returned to the driver manager and hence the ORA-01008 error |
|
|
| Back to top |
|
|
| johnnymac |
| Posted: Thu Jan 19, 2006 1:19 am Post subject: |
|
|
Newbie
Joined: 18 Jan 2006
Posts: 2
|
Thanks for the response JT. In actuall fact what i'm really asking isn't if there is compatability with a 10g database but using a 10g client (with ld_library_path pointing to lib32) being used to connect to a 9i database.
Any reason why this set up wouldn't work? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Jan 19, 2006 5:03 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I don't think WBIMB can use any part of Oracle 10g - client or server.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
