| Author |
Message
|
| Qadeer_824 |
 Posted: Tue Dec 22, 2009 3:44 am Post subject: WMB Flow Connecting to a remote Oracle Instance |
 |
|
Acolyte
Joined: 04 Oct 2007
Posts: 59
|
Hi,
I am trying to run a sample message flow that has a Database Node with a datasource name configured as TEST1. This DSN name has been defined in the .odbc.ini file with the following configuration
| Code: |
[TEST1]
Driver=/opt/ibm/mqsi/S/6.0/merant/lib/UKor820.so
Description=DataDirect 5.0 Oracle
ServerName=<Ip address of remote system>
PortNumber=<Port number for Oracle listener service>
LogonID=<User-id>
Password=<Password>
SID=<DatabaseName>
|
I DO NOT have Oracle client/server installed on the Message Broker 6.0.0.1 server. Though the message flow gets deployed successfully, it throws a sql exception
| Code: |
user:err|error WebSphere Broker v6001[1028252]: (MQBRKXXX.OTHERS)[10036]BIP2322E: Database error: SQL State 'IM003'; Native Error Code '0'; Error Text '[DataDirect][ODBC lib] Specified driver could not be loaded'. : MQBRKXXX.b4d90662-0c01-0000-0080-e311f157e38e: /build/S600_P/src/DataFlowEngine/ImbOdbc.cpp: 355: ImbOdbcHandle::checkRcInner: :
|
Can someone please let me know the reason for this. Is this because i have not setup a dsn service using the mqsisetdbparms command?
Please advice.
Thanks,
Qadeer |
|
| Back to top |
|
 |
| fschofer |
| Posted: Tue Dec 22, 2009 4:23 am Post subject: |
|
|
Knight
Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany
|
Hi,
have you checked the location of the odbc driver file ?
I would expect to find it below
/opt/IBM/mqsi/6.0/merant/lib
rather than
/opt/ibm/mqsi/S/6.0/merant/lib
I would also recommend to install a recent fixpack, 6.0.0.1 is rather old.
Greetings
Frank |
|
| Back to top |
|
|
| Qadeer_824 |
| Posted: Tue Dec 22, 2009 6:28 am Post subject: |
|
|
Acolyte
Joined: 04 Oct 2007
Posts: 59
|
Hi,
Yes i have checked the directory and it is correct. We will be upgrading to 6.1 soon, but would take some time and i have hard timelines.
I have configured a DSN service using mqsisetdbparms but it still doesnt' seem to load the driver successfully.
While googling, i could find that the driver UKor820.so requires the Oracle client to be present on the box. Is this true?
Note: In this test, broker is running on an AIX 5.3 box. I ran the command ldd UKor820.so and here's the result:
| Code: |
$ ldd /opt/ibm/mqsi/S/6.0/merant/lib/UKor820.so
/opt/ibm/mqsi/S/6.0/merant/lib/UKor820.so needs:
/usr/lib/libc.a(shr.o)
/opt/ibm/mqsi/S/6.0/merant/lib/libUKicu20.a(UKicu20.so)
/usr/lib/libpthreads.a(shr_xpg5.o)
/usr/lib/libC.a(shr.o)
/usr/lib/libC.a(ansi_32.o)
Cannot find /usr/lib/libdl.a(shr.o)
/unix
/usr/lib/libcrypt.a(shr.o)
/usr/lib/libpthread.a(shr_xpg5.o)
/usr/lib/libC.a(shr2.o)
/usr/lib/libpthreads.a(shr_comm.o)
/usr/lib/libC.a(ansicore_32.o)
/usr/lib/libC.a(shrcore.o)
/usr/lib/libC.a(shr3.o)
|
Thanks,
Qadeer |
|
| Back to top |
|
|
| fschofer |
| Posted: Tue Dec 22, 2009 6:43 am Post subject: |
|
|
Knight
Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany
|
|
| Back to top |
|
|
| Qadeer_824 |
| Posted: Tue Dec 22, 2009 7:16 am Post subject: |
|
|
Acolyte
Joined: 04 Oct 2007
Posts: 59
|
I guess i need to make it a bit more clear that i need to access a remote Oracle database to run some queries from my message flow.
i.e I need to connect to a remote oracle database which is just a User database.
The Broker database (DB2) is already installed on the server where Message Broker is installed.
The link given by you only gives the restrictions for a Broker database. How about the restrictions for connecting to a remote User database ? I am sure that the same rules would apply but i'm over my head now and not trusting myself  .
Am i in the right direction?
Thanks,
Qadeer |
|
| Back to top |
|
|
| fschofer |
| Posted: Tue Dec 22, 2009 7:32 am Post subject: |
|
|
Knight
Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany
|
Hi,
from the linked site:
| Quote: |
| You can also create user databases to be accessed from message flows; database support is the same as that defined for brokers except where specifically stated. Some data types supported by these databases are not supported by WebSphere Message Broker; for details, see Data types of values from external sources. |
Last time I accessed Oracle databases from the broker i was still working with version 2.1 and there was the requirement to have a Oracle client installed on the server where the broker is running.
By the way with version 6.1 the client seems not to be required in same cases
http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r0m0/topic/com.ibm.etools.mft.doc/ah10030_.htm
| Quote: |
If you install the Oracle Database Server on 32-bit systems, or on mixed mode systems on which you plan to create 32-bit execution groups, you must also install the Oracle Runtime Client.
|
Greetings
Frank |
|
| Back to top |
|
|
|
|
