This content has been marked as final. Show 4 replies
The queues will be up when your database is up.
You need to check the username and password held in the adapter.ini file for your AQ Adapter.
Usual causes are bad encrypted passwords not copied into the adapter.ini file correctly.
I don't have an example AQ Adapter.ini file to hand, but where you see the entries for
change this entry and put the password in the clear for now (so at least you can say whether or not it is a username / password problem).
From this entry, drop the "encrypted_" part, leaving the rest.
Now change the encrypted passed to the "proper" password.
Stop and restart the adapter, and see if you are still getting the same message.
of course it is possible in theory that the queue is not running. You can start a queue using the package dbms_aqadm (to use you need AQ privileges which are not included in dba privileges). These package has fuctions start_queue(<queue_name>) and stop_queue(<queue_name>). But if your queues are started and you shutdown and startup your database queues will always be started again.
But because of the error message you get this is not your problem. You should control your adapter.ini if the aq_bridge_username=b2b, password is encrypted correctly and the connection parameters for database really contains the data for b2b repository. By the way, don't forget to set aq_bridge_consumer_name=b2buser. Otherwise you could connect but not work with the IP_IN_QUEUE.
Yes, I got the resolution..
First the adapter entry was not proper, I also run procedure to start the queue...that worked & adapter started but still the issue remained unsiolved...then I imported the old dump which caused iStudio to run...
So both adapter entries as well as metadata was currropted I guess.
thnx as lot for the help.
The password of aquser in the database must be the same as the password of AQ Application that was stored in AQApp/aq_bridge_password. You can use oraclewallet command line to see the password of AQApp/aq_bridge_password and re-assign this password to the aquser in the database.