Brant,
It's been a while since we last spoke. BTW, there's a good possibility
that we're going to use Sungard for our D/R hot-site. I believe it's the
one out by you in Pennsylvannia. Anyway, I forwarded your notes to my
Oracle DBA. When I first spoke with IBM Level 2, they mentioned using
SQLNET, but then never really followed-up on it. Strange.
"Gutekunst, Brant"
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
UNGARD.COM> cc:
Sent by: MQSeries Subject: Re: MQ XA Oracle connect
problem
List
<[EMAIL PROTECTED]
.AC.AT>
04/20/2004 08:25
AM
Please respond to
MQSeries List
Hi Rick:
We had the same problem. We resolved it by using the SqlNet parameter
in the XAOpenString. (And update tnsnames.ora, etc.)
There was some finger pointing between IBM and Oracle at the time. I
don't recall the precise source of the problem. As I recall, it had
something to do with some changes Oracle made (to memory management?) at
version 9.
I don't know if there is a planned fix. The word we got was that the
documentation would be updated to say that SqlNet is a mandatory param
at 5.3.
-----Original Message-----
From: Rick Tsujimoto [mailto:[EMAIL PROTECTED]
Sent: Monday, April 19, 2004 11:28 AM
To: [EMAIL PROTECTED]
Subject: MQ XA Oracle connect problem
We're migrating from MQ V5.2 on AIX with XA Oracle8 to another RS/6000,
running MQ V5.3, CSD5 and Oracle9. The OS is at the same level on both
boxes. The MQ config info for Oracle9 on the new box is based on the
info
for Oracle8. The switch file was rebuilt under Oracle9, and the env
vars
are changed fas well. Everything seems to be ok, except when I start MQ
we
get AMQ7604. Based on the message, my guess is that for some reason, MQ
is
not finding the data base. My Oracle DBA says the DB is up and the
userid
and password we use are valid. But, we never get far enough for Oracle
to
record anything in its logs. Any ideas?
I also have a PMR open with IBM and they're going over the traces.
Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://vm.akh-wien.ac.at/MQSeries.archive
CONFIDENTIALITY NOTICE: This E-Mail transmission may contain confidential
or legally privileged information that is intended only for the
individual(s)or entity(ies) named in the E-Mail address. If you are not the
intended recipient, you are hereby notified that any disclosure, copying,
distribution, or reliance upon the contents of this E-Mail is strictly
prohibited. If you have received this E-Mail transmission in error, please
reply to the sender so that arrangements can be made for proper delivery,
after which please delete the message from your inbox. Thank you
Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://vm.akh-wien.ac.at/MQSeries.archive
Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://vm.akh-wien.ac.at/MQSeries.archive
