The queue needs to be restarted.
cd $AR_TOP/patch/115/sql
For Windows NT customer, please replace $AR_TOP with the proper path
Start SQL*Plus
sqlplus apps/apps
Run the script to start the queue: @arstque.sql
In some cases the queue will fail to start. If that happens then enter the
following:
sqlplus apps/apps
exec
dbms_aqadm.stop_queue(queue_name => 'AR.AR_REV_REC_Q');
exec
dbms_aqadm.drop_queue(queue_name =>'AR.AR_REV_REC_Q',
auto_commit=>TRUE);
exec dbms_aqadm.drop_queue_table(queue_table=>'AR.AR_REV_REC_QT',
force=>TRUE);
@arcquet.sql
@arstque.sql
This comment has been removed by a blog administrator.
ReplyDelete