首先下个客户端,路径放在如下
D:\oracleDataBase\app\oracle\product\11.2.0\instantclient_10_2
然后,在D:\oracleDataBase\app\oracle\product\11.2.0\instantclient_10_2\network\ADMIN
该路径下,找到tnsnames.ora.bak.然后给你贴配置,不会只能说贴主low,下面是我几个数据库的配置,其中第一个是本地的
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)