手工編輯 `$ORACLE_HOME/network/admin/tnsnames.ora` 最快,但新手易漏括號。Oracle 提供 **Net8 Configuration Assistant** 圖形化精靈,逐步引導零錯誤。
MYDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db-server)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
藍色部分為安裝時錄入資訊,請依實際環境修改。
C:\> tnsping MYDB
TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 20-OCT-2024 10:30:00
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
C:\Oracle\Ora92\network\admin\sqlnet.ora
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = db-server)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = orcl)))
OK (10 msec)
出現 `OK (xx msec)` 即表示 **Listener 可達、Service Name 正確、網路暢通**。
| 代碼 | 原因 | 對策 |
|---|---|---|
| TNS-12541: TNS:no listener | Listener 未啟動或 Port 錯誤 | Server 端 `lsnrctl status/start`、防火牆開 1521 |
| TNS-12514: Listener does not currently know of service requested | Service Name 不匹配 | 核對 `listener.ora` `SID_LIST`、`tnsnames.ora` `SERVICE_NAME` |
| TNS-12545: Connect failed because target host or object does not exist | Hostname 無法解析 | `/etc/hosts` 或 DNS 加入對應、或直接用 IP |