My Oracle Support Banner

Dump OID tns Entries Into A TNSNAMES.ORA (Doc ID 1205344.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Net Services - Version 9.2.0.8 to 11.2.0.1 [Release 9.2 to 11.2]
Other UNIX

Goal


THIS IS NOT AN ORACLE PRODUCT.  SERVICE REQUESTS CANNOT BE RAISED ON QUESTIONS OR PROBLEMS WITH THIS SCRIPT.  THIS SCRIPT WAS CREATED AS A PERSONAL SIDE-PROJECT AND IS PROVIDED TO CUSTOMERS AS-IS.  SERVICE REQUESTS CANNOT BE LOGGED REGARDING THIS SCRIPT.


Export TNS entries stored in Oracle Internet Directory into a working tnsnames.ora file.

This script will gather every TNS entry stored in OID.  If only a subset is needed,  the -b flag can be used to specify a base, or a text editor can quickly remove or keep various entries.

Solution

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
Goal
Solution

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