I'm trying to solve this Problem under Oracle 10.2.0.4
with sqldeveloper Version 1.5.4, Build MAIN-5940.
In sqldeveloper Preferences already installed:
The JDBC Driver ojdbc14.jar and oraclepki.jar and ojpse.jar.
The SSL Connect via SQLPLUS SSL is OK, but the Connect from sqldeveloper on an client doesn't hit.
My JDBC URL from inside the sqldeveloper is an advanced JDBC URL:
(HOST="the FQN-Hostname" )(PORT=1522))
The Errormessage says: Required property 'hostname' is not set on the Database Provider.
But inside the URL the FQN Hostname is correct and from host pingable.
Thanks in Advance for any Suggestions.
Have you tried putting your descriptor into the tnsnames.ora and using it from there ?
If it's in the tnsnames.ora, you can pick it from the drop list which will still use the thin driver. Or enter the name into the Connection Identifier text field will will then use the thick driver.
and you think you have the full URL correct.
I'm not sure if you're including the quotes as an example or you have the hostname correctly set. I'm using the advanced setting successfully.
(ADDRESS = (PROTOCOL = TCP)(HOST = sueharperlaptop.uk.oracle.com)(PORT = 1521))
(SID = dev11gr1)
I am not using the same jdbc drivers, so not giving you an accurate comparison, but it's worth starting with the URL.
Yes - the connections work fine when I put them in tnsnames.ora. This used to work when I was running Windows XP, Vista, and OpenSUSE Linux, but no longer works under Windows 7 x64. I suspect some Java/os compatibility issue going on here.