-
Recent Posts
Recent Comments
- yangtingkun on 非空字段空值对查询的影响
- Eric Zong on 非空字段空值对查询的影响
- Kamus on Oracle Ace Director
- 设置全局死锁优先级 | yangtingkun on RAC全局死锁检测时间
- ORA-600(krbounotread_noctx)错误 | yangtingkun on ORA-600(krboReadBitmap_badbitmap)错误
Archives
Categories
Meta
Tag Archives: space
TNSNAMES配置中空格导致的bug(二)
之前一直认为这是Oracle的一个bug,直到前一段时间通读网络服务参考手册时,才发现问题的真相。 TNSNAMES配置中空格导致的bug:http://yangtingkun.itpub.net/post/468/487506 当时测试发现,只要在SERVICE_NAME下面的一行缺少空格,就会导致错误的产生: TEST08 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.25.13.229)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = test08) ) ) 替换下划线的版本为: TEST08 = __(DESCRIPTION = ____(ADDRESS = (PROTOCOL = TCP)(HOST = 172.25.13.229)(PORT = 1521)) … Continue reading