My Oracle Support Banner

Creating a tnsnames.ora File From OID Entries (Doc ID 580423.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Net Services - Version to [Release 9.2 to 11.1]
Generic UNIX


Two commands can be run to generate a tnsnames.ora file from data stored from within OID.
The first command is an ldapsearch command, and the second is a long string of Unix sed commands

If the commands are run on the same host as OID, the commands can be run by simply cutting/pasting them into a terminal window.

If the commands are run remotely, refer to the ldapsearch syntax (in the OID Admin Guide) to specify remote host and port flags.

There are some restrictions which will be itemized at the end of this document.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.