Tuesday, March 7, 2017

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!

No comments:

Post a Comment