For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
I had installed sqldeveloper 4.1.3.20 with jre 1.8.0_91 and don´t work. Issue ora-12705
I have other machine with sqldeveloper 4.1.1.19 and the same version of jre and work fine.
In both pc unclick nsl option in Preference -> DataBase -> NLS
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>