1. Upgrade Guide
  2. Set Up the Parametrized Submission Process
  3. Manually Start the Advanced Queue Process (If You Cloned a Database)

Manually Start the Advanced Queue Process (If You Cloned a Database)

If you cloned a database, manually restart the AQ process:

  1. Stop PSUB. See the Oracle Clinical Administrator's Guide for instructions.
  2. Log in as sysdba.
  3. Enter:
    EXEC DBMS_AQADM.STOP_QUEUE('RXC.PSUB_REPLY_QUEUE',TRUE,TRUE);
EXEC DBMS_AQADM.STOP_QUEUE('RXC.PSUB_SEND_QUEUE',TRUE,TRUE); 
EXEC DBMS_AQADM.START_QUEUE('RXC.PSUB_REPLY_QUEUE',TRUE,TRUE); 
EXEC DBMS_AQADM.START_QUEUE('RXC.PSUB_SEND_QUEUE',TRUE,TRUE);
  4. Start PSUB.

Parent topic: Set Up the Parametrized Submission Process