Create Database Link w/LDAP authentication
Problem. I need to create a DB link that authenticates via LDAP against a corporate directory server, however I have no access to the SQLNET.ora file, or any files on the DB.
The syntax I am listing below is wrong, and I'm hoping someone can help me correct it. Assume the values below for the physical server, ports & users are correct.
Thanks in advance.
CREATE DATABASE LINK "TEST_LINK"
CONNECT TO "MY_USER" IDENTIFIED BY VALUES 'abcde'
USING '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = LDAP)(DIRECTORY_SERVERS = dbldap.myserver.com:3060:3131,dbldap2.server.com:3060:3131)
(DEFAULT_ADMIN_CONTEXT = "dc=us,dc=mycompany,dc=com"))
)
(CONNECT_DATA =
(SERVICE_NAME = test.service.com)
)
)'