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!

SQL Developer wont work via SSL (TCPS)

user8222475Nov 6 2008 — edited Nov 7 2008
I am trying to get SQL Developer (1.5.1) to connect to our Oracle database using SSL (tcps -- port 2484) and am getting a very generic error. (I have no error connecting to the same database over the unencrypted port -- 1521).

Status: Failue - Test failed: Io exception: The Network Adapter could not establish the connection.

I personally think that the connection is timing out, but all logging/debuggig features I can find do not prove anything either way. I have successfully connected to the database via SSL using tnsping and sqlplus. I have also successfully imported the certificate from the database server into the cacerts file in sqldeveloper/jdk/jre/lib/security This error is the same whether I use my TNSNAMES file or a custom JDBC url.

Please reply if you have questions/ideas/solutions.

Thanks, Dan

block from TNSNAMES.ora

TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname.fqdn)(PORT = 1521))
)
(CONNECT_DATA =
(SID = test)
)
)

TEST_SSL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCPS)(HOST = hostname.fqdn)(PORT = 2484))
)
(CONNECT_DATA =
(SID = test)
)
(SECURITY =
(SSL_SERVER_CERT_DN="CN=hostname.fqdn, OU=My Unit, O=My University, L=City, ST=State, C=US")
)
)


contents of sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES= (BEQ, TCPS, NTS)

SSL_VERSION = 0

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

SSL_CLIENT_AUTHENTICATION = FALSE

WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = C:\oracle\certs)
)
)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 5 2008
Added on Nov 6 2008
4 comments
9,689 views