OID (Oracle Internet Directory)

Many of customers are using now an Oracle Internet Directory (OID) to store the tnsnames.ora entries in order to avoid a rollout to every client workstation, if a tnsnames.ora entry has been changed, deleted or added..

What service name are we connecting to?  To find out where the name connects, we can do tnsping.

In client system

ldap.ora  ( $ORACLE_HOME/ldap/admin )

contents of ldap.ora.  ldap should be first in the order, and ldap.ora should be:

DEFAULT_ADMIN_CONTEXT = "dc=kci,dc=com"

DIRECTORY_SERVERS = (OIDPRD:80:443)

DIRECTORY_SERVER_TYPE = OID

 OID ldap server where centralized tns names given .To check the TNS entries we can use below SQL query in ODI database .

 select substr(rdn,4,15) || '=' || ATTRVAL
FROM ods.CT_DN C, ods.ds_attrStore D
WHERE C.ENTRYID = D.ENTRYID
and attrname='orclnetdescstring'
order by rdn
/

 sqlnet.ora  ($ORACLE_HOME/network/admin )

NAMES.DIRECTORY_PATH=(LDAP,TNSNAMES)  in sqlnet.ora file then information required to  connecting the  database need to be added LDAP server

  ldap.ora and SQLNET.ORA files will force the connections to go to new OID environment first and then to local tnsnames.ora file