Re: MQ XA Oracle connect problem
Brant, I discovered the following in the readme file: WebSphere MQ System Administration Guide Chapter 11. Transactional support - In section "Scenario 1: Queue manager performs the coordination" subsection "Oracle configuration" Figure 12."Sample XAResourceManager entry for Oracle on UNIX platforms" on AIX only you MUST add +SqlNet=db_link to the XAOpenString. "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
Re: MQ XA Oracle connect problem
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
Re: MQ XA Oracle connect problem
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
Re: MQ XA Oracle connect problem
We had a similar issue and found the problem was with how our .odbc.ini was configured. Our shop uses v2.1, so I do not know if this is still the case with 5.x. If you have an environment that works and one that does not, I would compare these files. Sebastian>>> [EMAIL PROTECTED] 4/19/2004 11:27:35 AM >>> 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 bothboxes. The MQ config info for Oracle9 on the new box is based on the infofor Oracle8. The switch file was rebuilt under Oracle9, and the env varsare changed fas well. Everything seems to be ok, except when I start MQ weget AMQ7604. Based on the message, my guess is that for some reason, MQ isnot finding the data base. My Oracle DBA says the DB is up and the useridand password we use are valid. But, we never get far enough for Oracle torecord 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 inthe Listserv General Users Guide available at http://www.lsoft.comArchive: http://vm.akh-wien.ac.at/MQSeries.archive