Hardware

Fortunately, I was able to resolve the issue and found that when ORDS Admin is configured via SQL developer it leaves the WORKSPACE id ="" which caused the URL mapping not to work and connect to DB for APEX to launch.  additionally the "updated=######### " was also missing.  so I deleted the URL mapping XML file from the config folder and re-created via command line

java -jar ords.war map-url --type regex http://trn-.* training

I was able to make it work as desired using the REGEX expression . see below

old configuration  1

<?xml version="1.0" encoding="UTF-8"?>
<pool-config xmlns="http://xmlns.oracle.com/apex/pool-config">
<pool name="training" uri-pattern="http://trn-.*" workspace-id=""/>
<pool name="test" uri-pattern="http://tst-.*" workspace-id=""/>
</pool-config>

old configuration  2

<?xml version="1.0" encoding="UTF-8"?>
<pool-config xmlns="http://xmlns.oracle.com/apex/pool-config">
<pool name="training" uri-pattern="http://trn/http://trn-.*"/>
<pool name="test" uri-pattern="http://tst/http://tst-.*"/>
</pool-config>

both the above old configuration didn't work

new configuration

<?xml version="1.0" encoding="UTF-8"?>
<pool-config xmlns="http://xmlns.oracle.com/apex/pool-config">
<pool name="training" uri-pattern="http://trn-.*" updated="2016-10-27T15:39:38.527Z"/>
<pool name="test" uri-pattern="http://tst-.*" updated="2016-10-27T15:39:38.527Z"/>
</pool-config>