Wednesday, April 26, 2017

Rebuild WorkFlow queues

Backup
=======
sqlplus apps/<apps_passwd> @$FND_TOP/sql/wfaqback.sql WF_DEFERRED

Drop DEFERRED Queues
====================

-bash-4.1$ sqlplus apps/<apps_passwd> @$FND_TOP/patch/115/sql/wfevqued.sql applsys <apps_passwd> WF_DEFERRED

Drop Indexes
=============
-bash-4.1$ sqlplus applsys/<apps_passwd>
 drop index WF_ERROR_N1;
 drop index WF_JAVA_ERROR_N1;
 drop index WF_DEFERRED_N1;
 drop index WF_JAVA_DEFERRED_N1;

Utlrp on DB node
================
SQL> @?/rdbms/admin/utlrp.sql

Create the (deleted) queues
===========================

-bash-4.1$ sqlplus apps/<apps_passwd> @$FND_TOP/patch/115/sql/wfevquc2.sql applsys <apps_passwd> WF_DEFERRED apps 5 3600 86400

Create subscribers
==================
sqlplus apps/<apps_passwd> @$FND_TOP/patch/115/sql/wfbesqsubc.sql applsys <apps_passwd>

Re-enqueue backed up messages
=============================
-bash-4.1$ sqlplus apps/<apps_passwd> @$FND_TOP/sql/wfaqrenq.sql WF_DEFERRED

backup
======
sqlplus apps/<apps_passwd> @$FND_TOP/sql/wfaqback.sql WF_JAVA_ERROR

Drop DEFERRED Queues
====================

-bash-4.1$ sqlplus apps/<apps_passwd> @$FND_TOP/patch/115/sql/wfevqued.sql applsys <apps_passwd> WF_JAVA_ERROR

Create the (deleted) queues
===========================

-bash-4.1$ sqlplus apps/<apps_passwd> @$FND_TOP/patch/115/sql/wfjmsqc2.sql applsys <apps_passwd>
sqlplus apps/<apps_passwd> @$FND_TOP/patch/115/sql/wfbesqc.sql applsys <apps_passwd>

Create subscribers
==================
sqlplus apps/<apps_passwd> @$FND_TOP/patch/115/sql/wfbesqsubc.sql applsys <apps_passwd>

Re-enqueue backed up messages
=============================
-bash-4.1$ sqlplus apps/<apps_passwd> @$FND_TOP/sql/wfaqrenq.sql WF_JAVA_ERROR

backup
======
sqlplus apps/<apps_passwd> @$FND_TOP/sql/wfaqback.sql WF_ERROR

Drop DEFERRED Queues
====================

-bash-4.1$ sqlplus apps/<apps_passwd> @$FND_TOP/patch/115/sql/wfevqued.sql applsys <apps_passwd> WF_ERROR

Create the (deleted) queues
===========================

-bash-4.1$ sqlplus apps/<apps_passwd> @$FND_TOP/patch/115/sql/wfevquc2.sql applsys <apps_passwd> WF_ERROR apps 5 3600 86400

Create subscribers
==================
sqlplus apps/<apps_passwd> @$FND_TOP/patch/115/sql/wfbesqsubc.sql applsys <apps_passwd>

Re-enqueue backed up messages
=============================
-bash-4.1$ sqlplus apps/<apps_passwd> @$FND_TOP/sql/wfaqrenq.sql WF_ERROR

backup
======
sqlplus apps/<apps_passwd> @$FND_TOP/sql/wfaqback.sql WF_JAVA_DEFERRED

Drop DEFERRED Queues
====================

-bash-4.1$ sqlplus apps/<apps_passwd> @$FND_TOP/patch/115/sql/wfevqued.sql applsys <apps_passwd> WF_JAVA_DEFERRED

Create the (deleted) queues
===========================

-bash-4.1$ sqlplus apps/<apps_passwd> @$FND_TOP/patch/115/sql/wfbesqc.sql applsys <apps_passwd>

Create subscribers
==================
sqlplus apps/<apps_passwd> @$FND_TOP/patch/115/sql/wfbesqsubc.sql applsys <apps_passwd>

Re-enqueue backed up messages
=============================
-bash-4.1$ sqlplus apps/<apps_passwd> @$FND_TOP/sql/wfaqrenq.sql WF_JAVA_DEFERRED


Create index on corrid
======================

-bash-4.1$ sqlplus apps/<apps_passwd> @$FND_TOP/patch/115/sql/wfbesqidxc.sql applsys <apps_passwd> APPS_TS_QUEUES

Gather table statistics
=======================

-bash-4.1$ sqlplus apps/<apps_passwd> @$FND_TOP/patch/115/sql/wfhistc.sql applsys


Creates grants/synonyms
=======================

-bash-4.1$ sqlplus apps/<apps_passwd> @$FND_TOP/patch/115/sql/afwfqgnt.sql APPS <apps_passwd> APPLSYS <apps_passwd>


No comments:

Post a Comment