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!

Vendor code 17002 with LDAP

Using SQL Developer 18.1 and a connection that used to work is not working any more.  The Oracle DB has had MVDC added to it.  I'm getting this error when I Load the LDAP definitions and choose mine:

"An error was encountered performing the requested operation: IO Error: The Network Adapter could not establish the connection"

The LDAP connect string has:

(DESCRIPTION=(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=1)(ADDRESS_LIST=(LOAD_BALANCE=ON)(FAILOVER=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=scan-prd-001)(PORT=1541))(ADDRESS=(PROTOCOL=TCP)(HOST=scan-prd-002)(PORT=1541)))(CONNECT_DATA=(SERVICE_NAME=SVRPRD)(SERVER=DEDICATED)))

scan-prd-072 should work with service_name=SVRPRD

scan-prd-073 should work with service_name=SVRPRD_RO

The Connection Details in SQL Developer says:

RO_USER@//scan-prd-001:1541/SVRPRD

But it fails.

But if I do a basic connection to scan-prd-001 on port 1541 with service-name=SVRPRD it works. 

This problem appears to be limited to SQL Developer.

Comments
Post Details
Added on Nov 8 2018
0 comments
1,535 views