| Author |
Message
|
| kumaranand10 |
 Posted: Tue Oct 14, 2008 7:32 am Post subject: Error: Procedural Gateway for WebSphere MQ verification scri |
 |
|
Novice
Joined: 01 Jul 2008
Posts: 10
|
Hi All I am getting following Error message,
SQL> @/appl/app/oracle/product/pga/pg4mq/sample/test.sql
message put on queue = 10203040506070809000
Error: Procedural Gateway for WebSphere MQ verification script failed.
ORA-29400: data cartridge error
MQI MQCONNX failed. completion code=2, reason
code=2035 HH.MI.SSXFF AM TZR
PL/SQL procedure successfully completed.
I am using MQ v 6 .0.2.2 on solaris 10, My MQ is trying to connect to Oracle 10.2.0.3.0 , while connecting to procedural gateway my oracle Team running script sql.test so They are getting the above error
Procedural Gateway for WebSphere MQ verification script fail
Please suggest me the possible solution as earliest as possible |
|
| Back to top |
|
 |
| ranganathan |
| Posted: Tue Oct 14, 2008 8:21 am Post subject: |
|
|
Centurion
Joined: 03 Jul 2008
Posts: 104
|
|
| Back to top |
|
|
| SAFraser |
| Posted: Tue Oct 14, 2008 10:54 am Post subject: |
|
|
Shaman
Joined: 22 Oct 2003
Posts: 742
Location: Austin, Texas, USA
|
|
| Back to top |
|
|
| ranganathan |
| Posted: Wed Oct 15, 2008 7:12 am Post subject: |
|
|
Centurion
Joined: 03 Jul 2008
Posts: 104
|
| SAFraser wrote: |
| I think this is the correct forum. |
Intially question was posed in Challanges Forum.. somebody moved it here without notification.. 
Thanks for the link.. pardon me for being too hasty..  |
|
| Back to top |
|
|
| SAFraser |
| Posted: Wed Oct 15, 2008 7:18 am Post subject: |
|
|
Shaman
Joined: 22 Oct 2003
Posts: 742
Location: Austin, Texas, USA
|
Ranga,
I thought it was odd that you'd make that comment about the right forum, I should have guessed it had been moved. Sorry!
The poster's question is really not very clear. I think the most typical approach is for Oracle to connect to MQ as a client, but the original question implies (to me) that this is an app on an MQ server. All very murky at this point! |
|
| Back to top |
|
|
| exerk |
| Posted: Wed Oct 15, 2008 7:19 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
Oracle AQ perhaps?
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys. |
|
| Back to top |
|
|
| SAFraser |
| Posted: Wed Oct 15, 2008 7:26 am Post subject: |
|
|
Shaman
Joined: 22 Oct 2003
Posts: 742
Location: Austin, Texas, USA
|
From what I've read, I believe this is the 10g version of what had been previously called the Oracle Messaging Gateway. And yes, the Oracle AQ is the Oracle subsystem that interacts with the gateway to/from MQ.
I am not an expert on this, by any means, even though I am expounding upon it as though I am! |
|
| Back to top |
|
|
| exerk |
| Posted: Wed Oct 15, 2008 7:34 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
| SAFraser wrote: |
| I am not an expert on this, by any means, even though I am expounding upon it as though I am! |
Then we are of the same stock! I did partake in a proof-of-concept tie up of WMQ to Oracle using Oracle AQ but do not remember which flavour of Oracle (was 10g in existence 2.5 years ago?).
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys. |
|
| Back to top |
|
|
| SAFraser |
| Posted: Wed Oct 15, 2008 7:47 am Post subject: |
|
|
Shaman
Joined: 22 Oct 2003
Posts: 742
Location: Austin, Texas, USA
|
| We ran a message gateway for about five years here, on Oracle 8 and then 9. The app that used it has been replaced, so we didn't have to migrate to 10. |
|
| Back to top |
|
|
| PeterPotkay |
| Posted: Wed Oct 15, 2008 9:30 am Post subject: |
|
|
Poobah
Joined: 15 May 2001
Posts: 7722
|
Double post locked. Any further comments should be added to the other post.
_________________
Peter Potkay
Keep Calm and MQ On |
|
| Back to top |
|
|
|
|
