下面是网上贴来的:
TNS-12533: TNS:illegal ADDRESS parameters
Cause: An illegal set of protocol adapter parameters was specified. In some cases, this error is returned when a connection cannot be made to the protocol transport.
Action: Verify that the destination can be reached using the specified protocol. Check the parameters within the ADDRESS section of TNSNAMES.ORA. Legal ADDRESS parameter formats may be found in the Oracle operating system specific documentation for your platform. Protocols that resolve names at the transport layer (such as DECnet object names) are vulnerable to this error if not properly configured or names are misspelled.
实际上是tnsnames.ora文件中,在写address时候,不小心在名字前面多个个空格还是其他字符。
对比以前的配置,没有发现一个错误。
实在搞不懂为啥,干脆删掉以后把正确的配置复制下来粘贴上去后仪TNSPING OK!
TNS-12533: TNS:illegal ADDRESS parameters
Cause: An illegal set of protocol adapter parameters was specified. In some cases, this error is returned when a connection cannot be made to the protocol transport.
Action: Verify that the destination can be reached using the specified protocol. Check the parameters within the ADDRESS section of TNSNAMES.ORA. Legal ADDRESS parameter formats may be found in the Oracle operating system specific documentation for your platform. Protocols that resolve names at the transport layer (such as DECnet object names) are vulnerable to this error if not properly configured or names are misspelled.
实际上是tnsnames.ora文件中,在写address时候,不小心在名字前面多个个空格还是其他字符。
对比以前的配置,没有发现一个错误。
实在搞不懂为啥,干脆删掉以后把正确的配置复制下来粘贴上去后仪TNSPING OK!
编辑回复