加载中…TNS-12533: TNS:illegal ADDRESS parameters
(2012-07-31 11:35:44)
标签：
tnspingtnsname.ora杂谈 |
分类： 数据库 |
[/u1/zliu/task/linux_porting/testing/conf]
(320)zliu@drdsux33#tnsping RDCB3107
TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 30-JUL-2012 23:34:35
Copyright (c) 1997, 2010, Oracle. All rights
reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mildba05.kenan.com)(PORT=1521))(CONNECT_DATA=(SID=RDCB3107))) CBS3001=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=milsyt09.kenan.com)(PORT=1521))(CONNECT_DATA=(SID=CBS3001))) CBS3002=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=milsyt09.kenan.com)(PORT=1521))(CONNECT_DATA=(SID=CBS3002))) CBS3003=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=milsyt09.kenan.com)(PORT=1521))(CONNECT_DATA=(SID=CBS3003))) CBS3004=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=milsyt09.kenan.com)(PORT=1521))(CONNECT_DATA=(SID=CBS3004))) CBS3005=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=milsyt09.kenan.com)(PORT=1521))(CONNECT_DATA=(SID=CBS3005))) CBS3006=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=milsyt09.kenan.com)(PORT=1521))(CONNECT_DATA=(SID=CBS3006))) CBS3007=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=milsyt09.kenan.com)(PORT=1521))(CONNECT_DATA=(SID=CBS3007))) CBS3008=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=milsyt09.kenan.com)(PORT=1521))(CONNECT_DATA=(SID=CBS3008))) CBS3009=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=milsyt09.kenan.com)(PORT=1521))(CONNECT_DATA=(SID=CBS3009))) CBS3010=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=milsyt09.kenan.com)(PORT=1521))(CONNECT_DATA=(SID=CBS3010))) CBS3011=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=milsyt09.kenan.com)(PORT=1521))(CONNECT_DATA=(SID=CBS3011)))
TNS-12533: TNS:illegal ADDRESS parameters
注意:tnsname.ora每行前面不能有空格。我删除之后，上面问题消失了。
TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 30-JUL-2012 23:34:35
Copyright (c) 1997, 2010, Oracle.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mildba05.kenan.com)(PORT=1521))(CONNECT_DATA=(SID=RDCB3107))) CBS3001=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=milsyt09.kenan.com)(PORT=1521))(CONNECT_DATA=(SID=CBS3001))) CBS3002=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=milsyt09.kenan.com)(PORT=1521))(CONNECT_DATA=(SID=CBS3002))) CBS3003=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=milsyt09.kenan.com)(PORT=1521))(CONNECT_DATA=(SID=CBS3003))) CBS3004=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=milsyt09.kenan.com)(PORT=1521))(CONNECT_DATA=(SID=CBS3004))) CBS3005=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=milsyt09.kenan.com)(PORT=1521))(CONNECT_DATA=(SID=CBS3005))) CBS3006=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=milsyt09.kenan.com)(PORT=1521))(CONNECT_DATA=(SID=CBS3006))) CBS3007=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=milsyt09.kenan.com)(PORT=1521))(CONNECT_DATA=(SID=CBS3007))) CBS3008=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=milsyt09.kenan.com)(PORT=1521))(CONNECT_DATA=(SID=CBS3008))) CBS3009=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=milsyt09.kenan.com)(PORT=1521))(CONNECT_DATA=(SID=CBS3009))) CBS3010=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=milsyt09.kenan.com)(PORT=1521))(CONNECT_DATA=(SID=CBS3010))) CBS3011=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=milsyt09.kenan.com)(PORT=1521))(CONNECT_DATA=(SID=CBS3011)))
TNS-12533: TNS:illegal ADDRESS parameters
注意:tnsname.ora每行前面不能有空格。我删除之后，上面问题消失了。
喜欢
0
赠金笔