plsql连接异常问题
SLAMPERF =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ccmeph13.chn.hp.com)(PORT = 1531))
)
(CONNECT_DATA =
(SID = SLAMPERF)
)
)
SLAMPERF =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ccmeph13.chn.hp.com)(PORT = 1531))
)
(CONNECT_DATA =
(SID = SLAMPERF)
)
)
前者可以,后者SLAMPERF 有两个空格就有问题,所以要顶格写,汗。这个问题折磨人啊。 tnsnames.ora一定要主意格式,在linux/unix下还需要主意空格问题。
在网上找到的,原文属于 zhanyingle_1981 空格害死人啊~!