|
先找到安裝文件中的ADMIN文件夾，如我的E:\oracle\app\oracle\product\10.2.0\server\NETWORK\ADMIN中有個(gè)tnsnames.ora ，該文件就是配置數(shù)據(jù)庫(kù)了。 初始：XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = WIN7U-20140628E)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) 可這樣建立：BMS_T = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.13.6.99)(PORT = 1522)) ) (CONNECT_DATA = (SERVICE_NAME = bms) ) ) BMS_ZS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.99.115)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = bms) ) )
|
|
|
