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

Last updated on SEPTEMBER 13, 2010

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms