本地為例
服務端配置
1、listener.ora 伺服器端監聽檔案
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl) -- 執行個體名稱
(ORACLE_HOME = F:\app\sen.qiao\product\11.2.0\dbhome_1) -- ORACLE_HOME
(SID_NAME = orcl) -- 執行個體名稱
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
2、用戶端配置,不常用 (既為服務端又為用戶端,才會配置這兩個檔案)
2.1 sqlnet.ora 輸入别名時判斷去哪裡擷取連接配接串
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)
2.2 tnsnames.ora 給連接配接串起别名
盡量寫為一行,避免無法識别 , joe即為别名
JOE =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL= TCP)(HOST = localhost)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME =orcl)))
2.3 配置之後檢驗:
C:\Users\sen.qiao>tnsping joe
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 04-11月-2021 14:28:57
Copyright (c) 1997, 2010, Oracle. All rights reserved.
已使用的參數檔案:
F:\app\sen.qiao\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
已使用 TNSNAMES 擴充卡來解析别名
嘗試連接配接 (DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL= TCP)(HOST = localhost)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME =orcl)))
OK (0 毫秒)
2.4 連接配接步驟
sqlplus sys/123456@joe
先去sqlnet.ora 找到連接配接模式 tnsname模式
然後在tnsname.ora檔案中找到字元串
3、tnsnames.ora 在plsql中應用
如下圖目錄中新增檔案
一個連接配接串寫一行