所有配置文件位於 `$ORACLE_HOME/network/admin/`,掌握它們的職責鏈路,是解決 90% 連接問題的鑰匙。
| 文件 | 角色 | 類比 | 關鍵參數 |
|---|---|---|---|
sqlnet.ora | 客戶端名稱解析策略 | Linux `/etc/nsswitch.conf` | `NAMES.DIRECTORY_PATH` |
tnsnames.ora | TNS 別名 → 連接描述符映射 | Linux `/etc/hosts` | 服務名、協議、主機、端口 |
listener.ora | 監聽器服務註冊與監聽端點 | Web Server `nginx.conf` | `LISTENER`、`SID_LIST_LISTENER` |
SQLNET.AUTHENTICATION_SERVICES = (NTS)
NAMES.DIRECTORY_PATH = (TNSNAMES, HOSTNAME, EZCONNECT)
當客戶端執行 `sqlplus sys/oracle@orcl` 時:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED) -- 專用服務器模式
(SERVICE_NAME = orcl) -- 對應服務端 service_names 參數
)
)
SALES =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
(CONNECT_DATA =
(SERVER = SHARED) -- 共享服務器模式
(SERVICE_NAME = sales)
)
)
關鍵點:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /u01/app/oracle/product/19c/dbhome_1)
(SID_NAME = orcl)
)
)
動態註冊 vs 靜態註冊:
「客戶端解析 → 監聽器接管 → 服務端註冊匹配」三階段鏈路清晰後,連接問題本質上是配置不一致。建議將三個文件納入版本控制,變更走審批流程,杜絕「改完就好」的運維陋習。