Release Sequence Lock Mediator - SOA 11g

SOA 11g, Oracle Mediator Resequencer which guarantees to maintain the desired message sequence in a reliable and robust manner.

You can implement the resequencer in Mediator by just selecting from the drop down box like below.

Now, coming to the topic. How to release the lock if there is any, 

1. Normally these mediator would have been implemented with fault policies such as Manual Recovery. In that case go to EM console, navigate to Faults and Rejected Messages and enable "Show only recoverable faults". Click on "Recovery" icon and retry the instance.
2. If suppose there isn't any Error handling techniques, search for the faulted instances and abort it.
3. If nothing works, directly login to the Database with SOAINFRA schema. And use the below queries to  unlock the sequence.

Select *  from mediator_group_status where status!=0;

Update mediator_group_status set status=0 where status!=0;

Select *  from SCFS2O_SOAINFRA.mediator_group_status where status!=0;

Update SCFS2O_SOAINFRA.mediator_group_status set status=0 where status != 0;

Credits:

http://prabhasoablog.blogspot.mx/2016/02/how-to-release-sequence-lock-in-mediator.html

APEX 5.0 images not showing in different environment - Solution

Hi guys!

A few days ago, I migrated an APEX 5.0.4 application. In it I have used static files (used .png files to make some banners).
I wanted to test deployment to different environment - the same APEX version, exported the application using Export Utility (preserved app ID), imported in the other environment using Import ... and everything went smooth. Static files were imported also. But when I run the application they are not showing up.

I’ve searched in the net and I’ve found the next link:
https://chefdba.com/2016/03/23/validate-your-ords-installation/

Solutions.

1.      Using the .war file

Navigate to the location where you have the war file you used to install or upgrade the ORDS. You you should execute:

java -jar ords.war validate apex_database

Write user sys and password of your database.

2.      Manual Method.

You can extract the scripts from the war file. Navigate to validate/core from scripts directory and you you should execute as sysdba:

SQL> @ords_manual_validate.sql /u01/ords/log

NOTE: In case than you don’t have ords.war file, too can execute apex.war which located in Apex installation folder. 
you should execute:
java -jar apex.war validate apex_database

Write user sys and password of your database.

The images should now be displayed.

Regards!