Author |
Message
|
AkankshA |
Posted: Tue Sep 09, 2008 6:40 am Post subject: remote databse connection |
|
|
 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 |
|
 |
elvis_gn |
Posted: Tue Sep 09, 2008 6:52 am Post subject: |
|
|
 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 |
|
 |
AkankshA |
Posted: Tue Sep 09, 2008 7:58 pm Post subject: |
|
|
 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 |
|
 |
fjb_saper |
Posted: Tue Sep 09, 2008 8:28 pm Post subject: |
|
|
 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 |
|
 |
AkankshA |
Posted: Tue Sep 09, 2008 8:49 pm Post subject: |
|
|
 Grand Master
Joined: 12 Jan 2006 Posts: 1494 Location: Singapore
|
yes i can _________________ Cheers |
|
Back to top |
|
 |
AkankshA |
Posted: Wed Sep 10, 2008 12:42 am Post subject: |
|
|
 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 |
|
 |
fjb_saper |
Posted: Wed Sep 10, 2008 2:12 am Post subject: |
|
|
 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 |
|
 |
Tibor |
Posted: Wed Sep 10, 2008 2:52 am Post subject: |
|
|
 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 |
|
 |
|