| Author |
Message
|
| EricCox |
 Posted: Wed Jan 09, 2013 9:10 am Post subject: Configure Broker 7.0 and 8.0 for Remote Access to Oracle RAC |
 |
|
Master
Joined: 08 Apr 2011
Posts: 292
|
To all,
I am migrating WMB 6.0.0.8 Message Flow projects first to WMB 7.0 and then to WMB 8.0 once I have it working in 7.0.
Target Environment for WMB 7.0 and WMB 8.0:
AIX 7.1 Server
Message Flow with Compute Nodes
using ODBC Data Source
Oracle RAC Server
10g
An administrator has tried to set up the ODBC connectivity but we are getting the following error when trying to connect to Oracle during run time of the service.
<faultstring>BIP3113E: Exception detected in message flow iaSOAPRateServiceFlow (broker BKRD711) </faultstring>
<faultactor>http://localhost:7080/iaBrokerRateService</faultactor>
<detail><text>Exception. BIP2230E: Error detected whilst processing a message in node 'iaSOAPRateServiceFlow.BusinessCreditRatesProcess'. : /build/S700_P/src/DataFlowEngine/ImbComputeNode.cpp: 489: ImbComputeNode::evaluate: ComIbmComputeNode: iaSOAPRateServiceFlow#FCMComposite_1_8
BIP2393E: Database error: ODBC return code '-1' from data source ''WMQIPRDB'' using ODBC driver manager ''libbipodbc.a(odbc.so)''. : /build/S700_P/src/DataFlowEngine/ImbOdbc.cpp: 341: ImbOdbcHandle::checkRcInner: :
BIP2322E: Database error: SQL State ''08001''; Native Error Code '1034'; Error Text ''[IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist IBM AIX RISC System/6000 Error: 2: No such file or directory''. : /build/S700_P/src/DataFlowEngine/ImbOdbc.cpp: 480: ImbOdbcHandle::checkRcInner: : </text></detail>
This error is reported by WMB 7.0 Test Client calling the service.
Is there an instruction on how to setup WMB 7.0 drivers and ODBC configuration for remote access to an Oracle RAC Server DB instance?
The administrator has said he is complete with the configuration, but it doesn't work. Hmmmm?
As always thanks for your great help.
Eric |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Wed Jan 09, 2013 9:24 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
mqsicvp is a useful utility to help configure database connectivity. Your sys admin needs to acquire the knowledge for configuring same. If he is a great reader, knowing how to use Google, the information is in the InfoCentre.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| EricCox |
| Posted: Wed Jan 09, 2013 9:42 am Post subject: Reading |
|
|
Master
Joined: 08 Apr 2011
Posts: 292
|
He is trying to read and work it out. But he can't give up until it works.
I don't have access to the box, so I can't do it for myself.
All I can do is research the errors I'm seeing at run time.
Grrrr |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Jan 09, 2013 9:48 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Can you get him to send you the ODBC configuration, and post it here?
Is Broker running on windows, or Unix? |
|
| Back to top |
|
|
| EricCox |
| Posted: Wed Jan 09, 2013 9:53 am Post subject: Broker and Config |
|
|
Master
Joined: 08 Apr 2011
Posts: 292
|
I've asked for the ODBC configuration.
WMB 7.0 and WMB 8.0 are running on the same AIX 7.1 machine. |
|
| Back to top |
|
|
| EricCox |
| Posted: Wed Jan 09, 2013 10:29 am Post subject: ODBC Config |
|
|
Master
Joined: 08 Apr 2011
Posts: 292
|
Here is the ODBC config for one of the data sources.
| Code: |
[WMQIPRDB]
Driver=/opt/IBM/mqsi/8.0.0.0/ODBC/V6.0/lib/UKora24.so
Description=DataDirect 6.0 ODBC Oracle RAC Wire Protocol
HostName=10.31.21.151
PortNumber=1521
ServiceName=prosbpdv
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0
|
|
|
| Back to top |
|
|
| EricCox |
| Posted: Wed Jan 09, 2013 11:04 am Post subject: Good Admins? |
|
|
Master
Joined: 08 Apr 2011
Posts: 292
|
The admin configured the ODBC to a server that isn't running the database included.
This error means that the database configured doesn't exist.
I wish it would just say that. Normal Oracle stuff. |
|
| Back to top |
|
|
|
|
