ORA-12557

代码	说明
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.

1. Make sure the %ORACLE_HOME%/bin directory（即目录） is in your （环境变量）PATH.//即ORA-12557的出现有时候与ORACLE_HOME未设置或设置错误有关
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 install ed the protocol adapter.
4. 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），搞定