| Author |
Message
|
| wmqi_tx |
 Posted: Tue Oct 04, 2005 8:52 am Post subject: Broker to DB Connecting Problems .......... |
 |
|
Novice
Joined: 28 Sep 2005
Posts: 13
|
Hi all
I am getting the following error frequently with broker database......but when I check the database status .... database is still on (available). ....
Evrytime I get this error, I have to restart the broker to deploy ......and this has become a big issue now.
Problem is more visible when I issue mqsilist <BrokerName> -e <ExGroup> .... command hangs for like 3-4 mnts and starts throwing errors .... and ultimately outputs though..... But further deployment does not work.... until restarted.
I am using Oracle 9i for Broker database....... & Broker and DB in Solaris environment ....... WMQ5.3 and WMQI 2.1
here is my odbc.ini settings
| Quote: |
[ORACLEDB]
Driver=/opt/wmqi/merant/lib/UKor816.so
#Driver=/u01/app/oracle/lib32/libclntsh.so.9.0
WorkArounds=536870912
WorkArounds2=2
Description=Oracle8
ServerName=PWS2
EnableDescribeParam=1
OptimizePrepare=1 |
Here is the error ............
| Quote: |
Oct 4 10:50:42 iedaau003 WMQIv210[28982]: [ID 702911 user.error] (DEV_BROKER)[1]BIP2049E: The broker made an unsuccessful attempt to access its database while attempting to execute SQL syncpoint/rollback. : DEV_BROKER.agent:
Oct 4 10:50:42 iedaau003 WMQIv210[28982]: [ID 702911 user.error] (DEV_BROKER)[1]BIP2321E: Database error: ODBC return code '-1'. : DEV_BROKER.agent: /build/S210_BP/src/DataFlowEngine/ImbOdbc.cpp: 160: ImbOdbcHandle::checkRcInner: :
Oct 4 10:50:42 iedaau003 WMQIv210[28982]: [ID 702911 user.error] (DEV_BROKER)[1]BIP2322E: Database error: SQL State '08S01'; Native Error Code '3114'; Error Text '[MERANT][ODBC Oracle 8 driver][Oracle 8]ORA-03114: not connected to ORACLE '. : DEV_BROKER.agent: /build/S210_BP/src/DataFlowEngine/ImbOdbc.cpp: 286: ImbOdbcHandle::checkRcInner: :
Oct 4 10:50:42 iedaau003 WMQIv210[28982]: [ID 702911 user.error] (DEV_BROKER)[1]BIP2322E: Database error: SQL State '08S01'; Native Error Code '3114'; Error Text '[MERANT][ODBC Oracle 8 driver][Oracle 8]ORA-03114: not connected to ORACLE '. : DEV_BROKER.agent: /build/S210_BP/src/DataFlowEngine/ImbOdbc.cpp: 286: ImbOdbcHandle::checkRcInner: :
Oct 4 10:50:43 iedaau003 WMQIv210[28982]: [ID 702911 user.info] (DEV_BROKER)[1]BIP2092I: The broker has reconnected to its persistent store successfully. : DEV_BROKER.agent: /build/S210_BP/src/AdminAgent/ImbAdminAgent.cpp: 1558: ImbAdminAgent::receiveCMRequest: : |
|
|
| Back to top |
|
 |
| JT |
| Posted: Tue Oct 04, 2005 9:03 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
|
| Back to top |
|
|
| wmqi_tx |
| Posted: Tue Oct 04, 2005 10:50 am Post subject: |
|
|
Novice
Joined: 28 Sep 2005
Posts: 13
|
Thnks JT for the quick response.
Few points here,
I haven't seen any java core dump in the system.......(may be i am looking in wrong location .... where normally would it be dumped?)
the file system has enough space left and broker has got only 5 small flows and testing did not start. Also we did not use any nodes that hit the database. we are just deploying the system and hit the errors at first step.
i was thinking there is a mistake in my odbc.ini file. i'm sure it is correct but just want an expert confirmation. |
|
| Back to top |
|
|
| wmqi_tx |
| Posted: Tue Oct 04, 2005 2:32 pm Post subject: |
|
|
Novice
Joined: 28 Sep 2005
Posts: 13
|
i have the service user id defined as wmqi.
where do i include ORACLE_SID information for this user wmqi ??
do i have to include ORACLE_HOME info also ?? |
|
| Back to top |
|
|
| JT |
| Posted: Tue Oct 04, 2005 7:11 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Quote: |
| where do i include ORACLE_SID information for this user wmqi ?? |
PWS2 should be identified in /export/home/wmqi/.profile
| Quote: |
| do i have to include ORACLE_HOME info also ?? |
Yes. |
|
| Back to top |
|
|
| sieijish |
| Posted: Wed Oct 05, 2005 8:21 am Post subject: |
|
|
Acolyte
Joined: 29 Nov 2004
Posts: 67
Location: London
|
If this is an intermittent error, then it appears more like an oracle configuration issue than broker handling of oracle connections. We had many intermittent connectivity issues with Oracle and most of the things required putting additional information into tnsnames.ora file. It also depends on the type of oracle setup you have (we have 10g RAC on 64bit linux) and the server topology.
http://www.datadirect.com/developer/odbc/oracle_heterogeneous/index.ssp |
|
| Back to top |
|
|
|
|
