List TNS aliases from tnsnames.ora
db_list_tnsParse local tnsnames.ora files from standard locations or a specific path to retrieve all available TNS alias names.
Instructions
Read and parse the local tnsnames.ora file, returning all available TNS alias names.
Searches in order: TNS_ADMIN directory → ORACLE_HOME/network/admin → current directory.
Args:
file_path (string, optional): Explicit path to tnsnames.ora.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | No | Optional: explicit path to a tnsnames.ora file. If omitted, auto-searches TNS_ADMIN and ORACLE_HOME/network/admin. |