| 代码 | 说明 |
| ORA-12557: | TNS:protocol adapter not loadable |
| Cause: | On some platforms (such as OS/2) protocol adapters are loadedat run-time. If the shared library (or DLL) for the protocoladapter is missing or one of its supporting libraries is missingthen this error is returned. |
| Action: | For further details, turn on tracing and reexecute theoperation. The trace file will include the name of the sharedlibrary (or DLL) that could not be loaded. |
- Make sure the
%ORACLE_HOME%/bindirectory（即目录） is in your （环境变量）PATH.//即ORA-12557的出现有时候与ORACLE_HOME未设置或设置错误有关 - Make sure the protocol is typed/specified correctly in your
tnsnames.ora file or whatever source you’re using to resolve service names. - TCP is the default protocol and is installed by default.If you’re using something different (like SPX) make sure you install ed the protocol adapter.
- Make sure TOAD is using the correct oracle_home if you have multiple homes installed
plsql中的帮助—>支持信息，看到Preferences中的OCI Library用的11g的oci.dll，一目了然。 于是打开Preference Files中的2个Default.ini文件查看，把OCIFile改掉成9i的路径（OCIFile=D:\Oracle9i\ora90\BIN\oci.dll），搞定
