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.
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "db_list_tns"
}
}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. |