DBMS_TNS package provides the RESOLVE_TNSNAME function to resolve a TNS name and return the corresponding Oracle Net8 connection string.When you connect locally to the server (no SQL*Net, no listener), the Oracle session inherits the client environment.   It is available on oracle 12.2 Release . The DBMS_TNS package contains one function, RESOLVE_TNSNAME, which returns the resolved connect string from configured sources that have been defined in the names.directory_path parameter in the sqlnet.ora file.

you can run it when connected to the database to see how the name is resolved

When we switch the container inside the CDB then it will show only container tns entry.

If we want to check all database links are going

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.