Skip to Main Content

Create Database Link w/LDAP authentication

User720285-OracleMay 23 2013 — edited May 23 2013
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)
)
)'
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Jun 20 2013
Added on May 23 2013
3 comments
1,400 views