TNS-12557错误解决-CSDN博客

本文详细介绍了ORA-12557错误的成因，包括客户端SID和oracle_home变量未设置的问题，并提供了针对性的解决步骤。包括确保ORACLE_HOME/bin目录在PATH中，正确指定协议类型，安装所需协议适配器等措施。

错误描述：C:>tnsping 192.168.1.6

TNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production on 11-SEP-2
012 22:08:42

Message 3511 not found; No message file for product=NETWORK, facility=TNSMessage
3512 not found; No message file for product=NETWORK, facility=TNSAttempting to
contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=
192.168.1.6)(PORT=1521)))
TNS-12557: Message 12557 not found; No message file for product=NETWORK, facilit
y=TNS

原因：client端sid和oracle_home变量没有设置：

ORA-12557的解决过程

ORA-12557:	TNS:protocol adapter not loadable
Cause:	On some platforms (such as OS/2) protocol adapters are loaded at run-time. If the shared library (or DLL) for the protocol adapter is missing or one of its supporting libraries is missing then this error is returned.
Action:	For further details, turn on tracing and reexecute the operation. The trace file will include the name of the shared library (or DLL) that could not be loaded.

1. Make sure the %ORACLE_HOME%/bin directory is in your PATH.
2. Make sure the protocol is typed/specified correctly in your
tnsnames.ora file or whatever source you're using to resolve service
names.
3. TCP is the default protocol and is installed by default. If
you're using something different (like SPX) make sure you installed the
protocol adapter.
4. Make sure TOAD is using the correct oracle home if you have
multiple homes installed

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27784356/viewspace-1059404/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27784356/viewspace-1059404/