路徑:$ORACLE_HOME/network/admin/(Windows 同理)。
SID_NAME、GLOBAL_DBNAME。SERVICE_NAME 或 SID。範例 tnsnames.ora:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)
SQL> SHOW PARAMETER SERVICE_NAME; -- 或 SQL> SELECT INSTANCE_NAME FROM V$INSTANCE;