Dump OID tns Entries Into A TNSNAMES.ORA
Last updated on SEPTEMBER 13, 2010
Applies to:Oracle Net Services - Version: 18.104.22.168 to 22.214.171.124 - Release: 9.2 to 11.2
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms