Oracle DBMS_TNS
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Provides the RESOLVE_TNSNAME function to resolve a TNS name and return the corresponding Oracle Net8 connection string.
AUTHID DEFINER
Dependencies
DBMS_TNS_LIB    
Documented No
First Available 12.2.0.1
Security Model Owned by SYS with EXECUTE granted to the DBA role
Source {ORACLE_HOME}/rdbms/admin/dbmstns.sql
Subprograms
 
RESOLVE_TNSNAME (new 12.2)
Returns the resolved connect string from any configured source (tnsnames, LDAP, Easy Connect) as indicated in the sqlnet.ora names.directory_path parameter) dbms_tns.resolve_tnsname(
tns_name IN VARCHAR2)
RETURN   IN VARCHAR2;
SELECT db_link, dbms_tns.resolve_tnsname(host)
FROM dba_db_links;

DB_LINK DBMS_TNS.RESOLVE_TNSNAME(HOST)
------- ---------------------------------------------------------------------------------------
PDBPROD (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
        (CONNECT_DATA = (SERVICE_NAME = pdbprod)))

Related Topics
Net Services
Packages
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved