先找到安装文件中的ADMIN文件夹，如我的E:\oracle\app\oracle\product\10.2.0\server\NETWORK\ADMIN中有个tnsnames.ora ，该文件就是配置数据库了。
初始：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)
)
)
本站仅提供存储服务，所有内容均由用户发布，如发现有害或侵权内容，请
点击举报。
