windows 上安装与数据库不同版本的客户端引起的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

上面其实告诉你这问题跟环境变量有关，仅此而已。具体情况具体分析：

环境：

    oracle 10.2.0.4 rac for windows 2003 sp2

 

问题现象：

     开发人员在数据库服务器上装了第2个oracle 10.2.0.1的客户端软件（事后才知道），dba在未知的情况下命令行敲sqlplus 出现10.2.0.1，在链接数据库的时候出现标题中错误；

 

问题分析：

    oracle 10201客户端在数据库升级后安装，导致环境变量中所记录的环境变量 客户端在数据库软件本身之前，dba在命令行进去后不管如何设置（set ORACLE_SID，ORACLE_HOME）其实都是对的，但是惘然；

 

问题解决：

    将数据库软件的环境变量提前（在我的电脑--属性--高级--环境变量--path）即解决问题；

 

这个问题对我这种想玩技术的屌丝是玩不转的，脑子没转到有人在“吭你”，沟通千百回才知道是这个情况，长记性吧，切记切记。

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

转载于:http://blog.itpub.net/22907091/viewspace-745920/