Using dblink to access a different server
I was trying to use dblink to access a different server. I created a dblink and then I tried to run the insert into a table command (trying to add rows to the remote server). I got the following error: "ORA-28030: Server encountered problems accessing LDAP directory service."
Is there something that I am missing? What is it that I have to do to overcome this problem? Your help would be highly appreciated.
If you create a database link with the following command:
CREATE DATABASE LINK db_link CONNECT TO CURRENT_USER USING 'tns_alias';and the current user uses LDAP for authentication, then you will need the LDAP server to be available for the database link to work correctly. One way around this is to authenticate the dblink user with Oracle authentication.
If you use Oracle's Internet Directory (OiD) or other LDAP server to resolve your TNS alias in your dblink definition, then you will need that LDAP server to be available as well. Define the TNS alias in a local TNSNAMES.ORA config file instead.