windows64系統安裝plsql遠端連接配接工具參考:https://www.allroundautomations.com/registered/plsqldev.html
第一步:下載下傳安裝下載下傳位址:https://www.allroundautomations.com/registered/plsqldev.html
第二步:安裝配置instantclientAPPORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 115.28.**.**)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = corcl)
)
)
注:
APPORCL為連接配接名
HOST指向遠端連接配接的資料庫的IP位址
SERVICE_NAME表示是資料庫名(對應jdbc:oracle:thin:@10...**:1521:corcl)。
參考位址:https://blog.csdn.net/zhige_j/article/details/80832654
第三步:配置Oracle Home 和 OCI庫安裝後,先不登入,直接進入頁面,在tools->preferences->connection(工具–首選項–連接配接)中配置Oracle Home(Oracle 主目錄)和OCI library(OCI庫)
第四步:配置環境變量變量名:NLS_LANG
變量值:AMERICAN_AMERICA.AL32UTF8
或 SIMPLIFIED CHINESE_CHINA.ZHS16GBK
變量名:TNS_ADMIN
變量值:D:\instantclient_11\network\admin