Oracle10g客戶端鏈接服務端配置
Oracle10g客戶端工具plsql鏈接服務端配置
Oracle10g客戶端工具比如plsql,在網路中鏈接服務端問題比較多中國菜刀,經常出現很多莫名其妙的問題。實際上不是plsql的配置,問題還是出在客戶端配置上面,網上有很多的解決辦法,並非真正的湊效,下面說一下有效的解決辦法:
安裝客戶端為企業管理器,默認方式安裝吧。
安裝後需要配置,這個位置位置在:D:oracleproduct10.2.0client_1NETWORKADMIN
有兩個文件需要配置:
sqlnet.ora
tnsnames.ora
先看tns:
# tnsnames.ora Network Configuration File: d:oracleproduct10.2.0client_1
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
KFCS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.87.30.44)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.87.30.45)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.87.30.46)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.87.30.47)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = KFCS)
)
)
紅色部分為伺服器端配置的tns,服務名為KFCS
這下注意了,還有個網路服務文件也需要配置:
# sqlnet.ora Network Configuration File: D:oracleproduct10.2.0db_1
etworkadminsqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES= (KFCS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
上面的紅色服務名要和tns文件中的配置保持一致,否則會有問題。(默認的不對)
默認安裝客戶端的時候不對。
只要有了這兩項配置,你就可以正確的通過plsql鏈接資料庫了。
-----------------------------------------------------------
特別說明下:通過sqlplus命令行鏈接資料庫可能和這個配置無關,具體我試過,感覺sqlplus可以鏈接成功,就是plsql不成功。感覺sqlplus鏈接的方式可能不一樣。
TAG:千鋒JAVA開發學院 |