Oracle | DBMS

Oracle DBMS_TNS Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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

Security Model Owned by SYS with EXECUTE granted to the DBA role

Source {ORACLE_HOME}/rdbms/admin/dbmstns.sql

Subprograms

RESOLVE_TNSNAME

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 VARCHAR2; PRAGMA SUPPLEMENTAL_LOG_DATA(resolve_tnsname, READ_ONLY);

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)))