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 » remote databse connection

Post new topic  Reply to topic
 remote databse connection « View previous topic :: View next topic » 
Author Message
AkankshA
PostPosted: Tue Sep 09, 2008 6:40 am    Post subject: remote databse connection Reply with quote

Grand Master

Joined: 12 Jan 2006
Posts: 1494
Location: Singapore

Guys,

I have a msg flow which is making remote Db inserts and procedure executions

My odbc.ini looks like

Quote:
[FIN1DB]
Driver=/MessageBroker/IBM/mqsi/6.0/merant/lib/UKor820.so
Description=DataDirect 5.0 Oracle
EnableDescribeParam=1
OptimizePrepare=1
ServerName=FIN1DB
WorkArounds=536870912
ProcedureRetResults=1



My tnsnames.ora looks like
Quote:
FIN1DB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = IPAddress)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = FIN1DB)
)
)




I get following error in my trace

Quote:
See the following messages for details of the error.
2008-09-09 19:40:54.016765 8242 DatabaseException BIP2321E: Database error: ODBC return code ''-1''.
The message broker encountered an error whilst executing a database operation. The ODBC return code was ''-1''. See th
e following messages for information obtained from the database pertaining to this error.
Use the following messages to determine the cause of the error. This is likely to be such things as incorrect datasour
ce or table names. Then correct either the database or message broker configuration.
2008-09-09 19:40:54.016773 8242 DatabaseException BIP2322E: Database error: SQL State ''82''; Native Error Code ''0''; Error Text ''523 80''.
The error has the following diagnostic information: SQL State ''82'' SQL Native Error Code ''0''
SQL Error Text ''523 80''




Now everything seems fine but whats the issue

one doubt i have is how does the broker know from where it should pick the tnsnames.ora file ?? in this case i ahve 2 files and how will it know where to look for..


Also i have oracle 10g Administrator client installed
_________________
Cheers
Back to top
View user's profile Send private message Visit poster's website
elvis_gn
PostPosted: Tue Sep 09, 2008 6:52 am    Post subject: Reply with quote

Padawan

Joined: 08 Oct 2004
Posts: 1905
Location: Dubai

Hi AkankshA,

First of all triple posts....very bad.

Secondly, you mention that everything seems fine...do you mean that things are working in the flow ? Is this a random behaviour ?

Look into your .profile (assuming ur on Unix) the tnsnames.ora path should be specified there...thats the one the Broker or any other application will use. Also check if the broker userId has permissions to access it.

Regards.
Back to top
View user's profile Send private message Send e-mail
AkankshA
PostPosted: Tue Sep 09, 2008 7:58 pm    Post subject: Reply with quote

Grand Master

Joined: 12 Jan 2006
Posts: 1494
Location: Singapore

i still have that click and mutiple post problem.. so

by seems fine i meant appears fine

no the code is not working.. its giving the odbc connection error

yes i have set ORACLE_HOME variable..

i have executed mqsisetdbparms for connection attributes

broker user id has permissions to access tnsnames.ora file
_________________
Cheers
Back to top
View user's profile Send private message Visit poster's website
fjb_saper
PostPosted: Tue Sep 09, 2008 8:28 pm    Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

Can you connect using SQLPlus (PL/SQL) ??
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
AkankshA
PostPosted: Tue Sep 09, 2008 8:49 pm    Post subject: Reply with quote

Grand Master

Joined: 12 Jan 2006
Posts: 1494
Location: Singapore

yes i can
_________________
Cheers
Back to top
View user's profile Send private message Visit poster's website
AkankshA
PostPosted: Wed Sep 10, 2008 12:42 am    Post subject: Reply with quote

Grand Master

Joined: 12 Jan 2006
Posts: 1494
Location: Singapore

i have also set the

SHLIB_PATH=/oracle/client10g/lib32

but still no luck..
_________________
Cheers
Back to top
View user's profile Send private message Visit poster's website
fjb_saper
PostPosted: Wed Sep 10, 2008 2:12 am    Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

Does your broker's userId source some of the Oracle userId's environment initialization stuff (. ~orauser/.profile)?
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
Tibor
PostPosted: Wed Sep 10, 2008 2:52 am    Post subject: Reply with quote

Grand Master

Joined: 20 May 2001
Posts: 1033
Location: Hungary

Is there exist the sqlnet.log file in your home directory? It should contain the real Oracle error.
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 » remote databse connection
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.