ORA-12557错误的全称是“TNS: protocol adapter not loadable”,即“TNS:协议适配器不可加载”。这个错误通常表明Oracle客户端无法加载用于与Oracle数据库服务器进行通信的网络协议适配器。 二、ORA-12557错误可能的原因 环境变量设置错误:如ORACLE_HOME或PATH环境变量设置不正确,导致Oracle客户端无法找到正确的协议适配器...
今天restart DB server的时候,再次连接oracle通过SQL navigator工具的时候,出现如下的错误ORA-12557: TNS:protocol adapter not loadable 后来分析了一下原因以及之前在google上看到过类似的解决方法; 因为这台server上被开发人员装了oracle的客户端,原因就是SQL navigator的版本不支持直接连接oracle 11g,所以选择安装了另外...
ORA-12557:TNS:protocoladapternotloadable 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 ...
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 ...
ORA-12557: TNS:protocol adapter not loadable 环境背景:本机有多个oracle实例(11,9i),连接的服务器的oracle是9i 前因:我刚进公司,于是电脑域账号还在审批中没下来,用的以前那人的账号登录系统,一切正常。 后果:我的账号下来了,于是我换成我自己的账号登录电脑,所有配置重置,这时候一切的环境变量重新设置,当...
Oracle ODBC Driver - Version 11.2.0.1 and later: ORA-12557: TNS:protocol Adapter Not Loadable When Trying to Use the 32-bit Oracle ODBC Driver on 64-bit Windows
ORA-12557: TNS:protocol adapter not loadable 原因:lisntener所属的主目录在环境变量PATH里不是第一个ORACLE_HOME 如:lisntener是在11g的主目录下创建的,可path值如下 E:\app\oracle\product\10.2.0\db_1\bin;%JAVA_HOME%\bin;F:\app\Administrator\product\11.1.0\db_2\bin;C:\Perl64\site\bin... ...
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...
12557, 00000, "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 ...
Workflow Builder Fails: 1700: Could not connect with username/password 'apps/pwd@VIS' ('ORA-12557: TNS:protocol adapter not loadable') [ID 453241.1] In this Document Symptoms Cause Solution This document is being delivered to you via Oracle Support'sRapid Visibility(RaV) process, and therefore...