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.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading