九乡新闻网进口宝马x1保养费:ORA-12557: TNS:protocol adapter not loadable
来源：百度文库 编辑：九乡新闻网 时间：2024/07/14 03:41:53
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
-------------------------环境是装了两个实例,一个9i,一个10G
SQL> conn sys/admin@c11 as sysdba;
ERROR:
ORA-12557: TNS:protocol adapter not loadable
------lsnrctl>status 报错
Message 1053 not found; No message file for product=NETWORK, facility=TNSTNS-12538: Message
12538 not found; No message file for product=NETWORK, facility=TNS
TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS
TNS-00508: Message 508 not found; No message file for product=NETWORK, facility=TNS
---------------
1、重新配置监听
2、echo %oracle_home% 查看所打开的实例是不是在这个目录下
如不是设set oracle_home=d:oracleora92
以上摘自：http://steve352.itpub.net/post/33251/306560
恰巧今天有个朋友同样装了9I跟10也出现了 ORA-12557，修改sid错误仍然，修改oracle_home为当前数据库的oracle_home以后，问题解决
说明：
1、ORACLE_HOME是Oracle所安装软件的根目录。Oracle根据这个根目录，可以相对定位其他相关的程序在哪
（ORACLE_HOME 如果不对的话，那么比如启动数据库或者登陆的时候找不到相关的程序会出错）
2、SID是建立一个数据库时，这个数据库的标识符
3、如果一个版本里有2个或多个instance那怎么设置sid？