今天搞oracle远程连接弄了一天,一个字,伤!
开始用oracle客户端配置连接,测试成功,但是用plsql登陆或者用sql Plus连接始终是失败,查了无数资料和实验无数次,重新装oracle客户端无数次,无果,最后发现
CDMQ =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 198.10.10.111)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)(原来没这行代码,添加上这行代码就没问题了)
(SERVICE_NAME = cdmq)
)
)
伤心!