Q
Problem solve Get help with specific problems with your technologies, process and projects.

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."

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.

This error is telling you that your LDAP authentication server could not be reached. There are many places where you would need this LDAP server to be available.

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.

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close