| Author |
Message
|
| Oracle_AQ |
 Posted: Thu Dec 06, 2007 9:38 am Post subject: MQ SetUp for Using with Oracle Messagin Gateway and AQ |
 |
|
Newbie
Joined: 06 Dec 2007
Posts: 3
|
Hello,
We are planning to use ORACLE AQ - Oracle Messaging Gateway - MQ JMS .
It is propagation of JMS text type message between AQ<->MQ(Inbound as well as Outbound Propagation)
Will be grateful if someone can please guide about the configuration / SET UP needed on MQ side. We have the MQ client on the same box as Oracle AQ BUT the MQ server is somewhere else .
Especially need to know the queues that need to be created on MQ servers, I am confused about the log queues(purpose and how to set up on MQ).
Thanks a million for your time.
Regards |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Fri Dec 07, 2007 12:11 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
Hi Oracle_AQ,
1. Setting up of MQ Server and MQ Client (Which OS)
2. Creating the queues
3. Creating Channel
4. Exporting Client Environment variables
5. How the application connects to the MQ Queue
I do suggest you to go through IBM Manuals, and come back with your doubts over here.
You Said:
MQ server is somewhere else (Where ?  )
Without knowing this, i dont know how you are going to configure and connect to the server.
figure out how many clients are going to connect with Server
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Fri Dec 07, 2007 4:07 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
You need to set up all the queues the Oracle Gateway manual asks for...
I believe that are inbound and outbound log queues and error queues?
You need to setup a svrconn channel on the qmgr.
You need to share the information about the svrconn chl with the person configuring the oracle MQ-AQ gateway ... (host, chl name, port) possibly qmgr name
It's pretty easy and straight forward ...
For req / reply we do something special...
Enjoy 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| Oracle_AQ |
| Posted: Fri Dec 07, 2007 8:06 am Post subject: |
|
|
Newbie
Joined: 06 Dec 2007
Posts: 3
|
Hello ,
Thanks a million for your replies.
I will like to elaborate on the scenario I described before (Please bear with me )
Our original problem was to send/receive JMS message to Websphere MQ ( which acts as a queue for web service - we have no control over MQ we just know the basic parameters for sending and receiving).
Since we had to send/receive a lot , we thought about using Oracle AQ and Websphere MQ propgation , where we enqueue and dequeue in AQ and messaging gateway taking care of MQ.
We do not have the permission to create additional queues on MQ , Can we implement the solution without using the Log Queues and other queues barring the standard sending and receiving queue that have been specified by the owner of MQ/Web Service.
Thanks a million for your time.
Regards |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Fri Dec 07, 2007 1:20 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
In order to work the AQ-MQ gateway requires some queues to be created on the MQ server it connects to.
If this is not possible you can always declare MQ as a foreign JMS provider to your Oracle J2EE app (no MQ-AQ gateway).
Enjoy 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Fri Dec 07, 2007 1:22 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| fjb_saper wrote: |
In order to work the AQ-MQ gateway requires some queues to be created on the MQ server it connects to.
If this is not possible you can always declare MQ as a foreign JMS provider to your Oracle J2EE app (no MQ-AQ gateway).
As an alternative you can setup an MQ Server as gateway to the MQ network and create an MQ-AQ gateway connected to your server.
Enjoy |
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| Oracle_AQ |
| Posted: Fri Dec 07, 2007 1:54 pm Post subject: |
|
|
Newbie
Joined: 06 Dec 2007
Posts: 3
|
Thanks a million for your reply. My application is not Oracle J2EE , it is a oracle based DWarehouse with ETL code in PL/ SQL . We need to perform lookup for dimension(is big) and that is where we plan to use AQ <-->MQ JMS message exchange. To send the id as request(AQ enqueue) and get the descriptive attributes back in return JMS message(AQ dequeue). JMS complinant requirement is MQ server to which we need to talk .
>>As an alternative you can setup an MQ Server as gateway to the MQ >>network and create an MQ-AQ gateway connected to your server.
Can you please elaborate it more.
If I understand correctly , the picture changes from
AQ -- Oracle MGW ------ MQ network
AQ -- Oracle MGW --MQ---- MQ network
I do not have the resources(constraints/bottlenecks) to makes changes to MQ network or have additional MQ server setup.
One thing that I thought abour was - As per my understanding Oracle AQ needs log queues on MQ for reliable message delivery(message only once as message oriented middleware suppose to do that). BUT My application requirements are not that critical, can I dispense away with log queue.
I do not have the infrastructure setup , we are in planning stage - so some of the questions that can be answered by proof of concept/prototypes are not feasible.
Thanks a million for your time.
Regards |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Fri Dec 07, 2007 3:06 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
What does the AQ-MQ gateway installation manual say? Create the queues, right?
So without queues no AQ-MQ gateway... 
Anyway the service provider will need to change his setup to accomodate you because he needs a default way back to you...to supply you with the response...
It's all give and take... 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| SAFraser |
| Posted: Fri Dec 07, 2007 4:11 pm Post subject: |
|
|
Shaman
Joined: 22 Oct 2003
Posts: 742
Location: Austin, Texas, USA
|
If you wish to implement AQ to MQ using the MGW, you must have objects created on an MQ server. The MGW is a client to MQ. As such, on the MQ server which is your destination, a destination queue must be created (a local queue to house the data or a remote queue to send the data to yet another queue manager). You must also create a server connection channel on the MQ server, as well as a log in and a log out queue.
You cannot just "use" MQ; it is more than just a network wire between two machines. The MGW is a client to MQ server in the same way that the Oracle client is a client to Oracle server, and must be setup for use.
These comments are based upon the manner in which my shop has implemented the MGW. Perhaps there are other configurations of which I am unaware.
Shirley |
|
| Back to top |
|
|
|
|
