Message queue terminated as DB was terminated unexpectedly. Once db is up, MQ won't start with following error.
No new LOG is genrating while restarting MQ.
1. Shutdown Message Queue
2. Check for invalid packages -
3. Recompile any invalid objects. Either run UTLRP.SQL or recompile individually.
The dbms_mgwadm and mgwi_amdin packages should be valid.
4. If the Messaging Gateway shutdown still does not work, then issue the following to cleanup the gateway -
This runs recovery tasks that set the gateway to a known state when the gateway agent has crashed or some other abnormal event occurs so that the gateway cannot be started.
NOTE: This command will only work if a previous shutdown command has been attempted otherwise error messages will be displayed.