ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Intermittent ODBC error SQL STATE 08S01 using Oracle DB

Post new topic  Reply to topic
 Intermittent ODBC error SQL STATE 08S01 using Oracle DB « View previous topic :: View next topic » 
Author Message
MK8570
PostPosted: Mon Oct 19, 2009 10:36 am    Post subject: Intermittent ODBC error SQL STATE 08S01 using Oracle DB Reply with quote

Apprentice

Joined: 18 Jul 2007
Posts: 26
Location: PA, USA
We are getting intermittent ODBC errors as seen below in the syslog. Below errors are for 2 different Oracle DB. Once we retry the failed message flow, it works fine.

Our DBA is not able to see any issues on the Oracle DB and think's this could be a DataDirect issue.

Has anybody come across this error before ?


BIP2322E: Database error: SQL State '08S01'; Native Error Code '0'; Error Text '[IBM][ODBC Oracle Wire Protocol driver]Socket closed.'.


...

Database error: SQL State '08S01'; Native Error Code '0'; Error Text '[IBM][ODBC Oracle Wire Protocol driver]Connection refused. Verify Host Name and Port Number.'
Back to top
View user's profile Send private message
smdavies99
PostPosted: Mon Oct 19, 2009 10:46 am    Post subject: Reply with quote

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
Please tell us what version & patch level the Broker Runtime is.

However, I sorta think this is a network issue. As the problem is intermittent and if the DB is on a different server then I would guess that this is the problem. These sorts of things are very difficult to track down.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.
Back to top
View user's profile Send private message
MK8570
PostPosted: Mon Oct 19, 2009 10:55 am    Post subject: Inetrmittent ODBC Error Reply with quote

Apprentice

Joined: 18 Jul 2007
Posts: 26
Location: PA, USA
Hi,
Broker Environment is AIX 5.3 . Oracle User DB is 10g. Network guys are also don't see any issues during the time period as indicated in the syslog.


$ mqsiservice -v
BIPv610 en US
ucnv Console CCSID 819 dft ucnv CCSID 819
ICUW ISO-8859-1 ICUA ISO-8859-1

BIP8996I: Version: 6103
BIP8997I: Product: WebSphere Message Brokers
BIP8998I: CMVC Level: S610-FP03 DH610-L81015
BIP8999I: Build Type: Production

BIP8071I: Successful command completion.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Intermittent ODBC error SQL STATE 08S01 using Oracle DB
Jump to:  



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
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.