(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每行前面不能有空格。我删除之后,上面问题消失了。