我下载了DBArtisan并且安装了。当我Use Tns Names Alia 没有选项.
我所以问了同事,我就装了oracle instant client 。
配置了环境变量,
ORACLE_HOME=E:\Oralce\instantclient_11_2
PATH=...;%ORACLE_HOME%
LD_LIBRARY_PATH=%ORACLE_HOME%
TNS_ADMIN=%ORACLE_HOME%
然后配置了tnsnames.ora
详细内容是:
ZHDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.80.16)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ZHDB)
)
)# ep29/realbow
realbow_test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.80.249)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = devdb102)
)
)
HZDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 115.238.88.242)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ZHDB)
)
)upload =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.80.16)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
) 按我搜索来的资料,这样做之后 作者连接成功,我问题依旧, 依旧Use Tns Names Alia 没有选项
我所以问了同事,我就装了oracle instant client 。
配置了环境变量,
ORACLE_HOME=E:\Oralce\instantclient_11_2
PATH=...;%ORACLE_HOME%
LD_LIBRARY_PATH=%ORACLE_HOME%
TNS_ADMIN=%ORACLE_HOME%
然后配置了tnsnames.ora
详细内容是:
ZHDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.80.16)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ZHDB)
)
)# ep29/realbow
realbow_test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.80.249)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = devdb102)
)
)
HZDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 115.238.88.242)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ZHDB)
)
)upload =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.80.16)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
) 按我搜索来的资料,这样做之后 作者连接成功,我问题依旧, 依旧Use Tns Names Alia 没有选项
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货