我要用本地server连接总部server上的的oracle,防火墙已开DemoDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.demo.COM.CN)
(PROTOCOL = TCP)
(Host = DeH.demo.COM.CN)
(Port = 1521)
)
)
(CONNECT_DATA = (SERVICE_NAME = DeSer)
)
)本地 tns已经配置,可以通过pl/sql developer登录远程oracle但是我在cmd中输入命令
sqlplus usr/[email protected]
或者
sqlplus usr/[email protected]报错:ora-12154 tns:could not resolve service name
这个肿么回事
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.demo.COM.CN)
(PROTOCOL = TCP)
(Host = DeH.demo.COM.CN)
(Port = 1521)
)
)
(CONNECT_DATA = (SERVICE_NAME = DeSer)
)
)本地 tns已经配置,可以通过pl/sql developer登录远程oracle但是我在cmd中输入命令
sqlplus usr/[email protected]
或者
sqlplus usr/[email protected]报错:ora-12154 tns:could not resolve service name
这个肿么回事
sqlplus usr/pwd@DemoDB