Skip to Main Content

SQL Developer

Announcement

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!

sqldeveloper 4.1.3 ora-12705

user927002May 24 2016 — edited May 24 2016

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

Comments

Shivashish Roy-Humana

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>

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 21 2016
Added on May 24 2016
1 comment
547 views