Steps to Implement SOA Purging in 12c Fusion: Shutdown SOA 12c Fusion domain (please follow sequence Managed servers, Admin Server, and Node Manager)Login to SOA 12c Fusion database as SYS and execute the following NOTE: SOAINFRA schema name could be different to what I am referring here as “SOAINFRA” GRANT ALTER SESSION TO SOAINFRA Ensure …
Category Archives: purging
SOA Purging in Efficient Way
Problem Statement Using Oracle’s out of the box, purging of SOA instances was not deleting all the old and unwanted instances. The out of the box purging script only delete particular instances which are in 1, 3, 17, 19, 31, and 32 states. This problem leads to piling up of old unwanted instances which are …
