SQL Developer 3.1EA1 / Windows :
TCPS (SSL) connection does not work as expected
With TNS and a Network Alias I am getting :
An error was encountered performing the requested operation
I/O Exception: sun.security.validator.ValidatorException: PKIX path building failed:
sun.security.provider.certpath.SunCertPathBuilderException:
unable to find valid certification path to requested Target
Vendor code 17002
Same with LDAP and a DB Service
As a workaround :
Connection type :
TNS
Connect Identifier: *(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=srv01)(PORT=1522))(CONNECT_DATA=(SID=DB01)))*
Verification
select sys_context('USERENV','NETWORK_PROTOCOL') from dual;
tcps
Edited by: Laurent Schneider on Nov 3, 2011 3:04 PM
tnsping / sqlplus works fine
PS> tnsping DB01
TNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production on 03-NOV-2011 14:45:22
Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
C:\app\oracle\product\11.1.0\client_1\network\admin\sqlnet.ora
Used LDAP adapter to resolve the alias
Attempting to contact (DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=srv01)(PORT=1522))
(CONNECT_DATA=(SID=DB01)))
OK (250 msec)