Error Ora 12557 Tns Protocol Adapter Not Loadable
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this toad ora-12557: tns:protocol adapter not loadable site About Us Learn more about Stack Overflow the company Business Learn
Tns-00527: Protocol Adapter Not Loadable
more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x ora-12557 oracle 12c Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ORA-12557
Tns-12557: Tns:protocol Adapter Not Loadable Linux
TNS:protocol adapter not loadable up vote 6 down vote favorite I am trying to develop a C# Windows Forms Application targeting the .net 4 framework. The program will execute a stored procedure against an Oracle Database and I get the following error when I try to open the connection to the database. ORA-12557 TNS:protocol adapter not loadable I am developing this in Visual Studio ora 12557 pl sql developer 2012 and have managed to make the Server Explorer connect to the database successfully, however I keep getting this error through my application. I have two Oracle 11g clients on my machine. One is 32bit and the other is 64bit. I do need both for different applications so it is not possible to remove one. I have also tried changing the order of the Oracle home directories in the PATH variable. Currently I have the 64bit one first which is the one I would like to connect with. I am connecting my application to the Database using ODP.NET and have referenced the dll from the 64bit application. As far as I can tell I have done what has been suggested and have not managed to get it working. If anyone could help it would be appreciated. c# database oracle visual-studio c#-4.0 share|improve this question asked Jan 29 '14 at 9:28 James Randles 98117 add a comment| 3 Answers 3 active oldest votes up vote 7 down vote accepted The ORA-12577 error is related to Windows Environment or Oracle Home PATH because sqlplus command works smoothly when I execute it in
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it
Ora-12557: Tns:protocol Adapter Not Loadable C#
enabled. Please turn JavaScript back on and reload this page.
Ora-12557 Odbc
Please enter a title. You can not post a blank message. Please type your message tns-12557 tns-12560 tns-00527 and try again. More discussions in Business Intelligence Suite Enterprise Edition All PlacesBusiness IntelligenceBusiness Intelligence FoundationBusiness Intelligence Suite Enterprise Edition This discussion is archived http://stackoverflow.com/questions/21426915/ora-12557-tnsprotocol-adapter-not-loadable 7 Replies Latest reply on Jul 21, 2014 10:29 AM by DelliBI Oracle ORA-12557: TNS:protocol adapter not loadable-OBIEE 10g user1668671 Jul 17, 2014 8:02 AM Hi,We are using OBIEE 10g. We have both 32 bit and 64 bit oracle clients in the macine.When we set ORACLE_HOME to 32 bit client https://community.oracle.com/thread/3585230 we are getting the error "Oracle ORA-12557: TNS:protocol adapter not loadable" when we are trying to import tables from database.When we set ORACLE_HOME to 64 bit client we are getting the error "[nQSError: 17003] Oracle gateway error: OCIEnvNlsCreate or OCIEnvInit failed to initialize environment". We are able to import the tables from databse. But while updating row count/ view data or in analytics reports we are getting that error.First let me know which is the correct oracle client either 32 bit or 64 bit.Any solution.Thanks. I have the same question Show 0 Likes(0) 17258Views Tags: none (add) 10gContent tagged with 10g, adapterContent tagged with adapter, loadableContent tagged with loadable, notContent tagged with not, obieeContent tagged with obiee, ora-12557Content tagged with ora-12557, protocolContent tagged with protocol, tns:Content tagged with tns: This content has been marked as final. Show 7 replies 1. Re: Oracle ORA-12557: TNS:protocol adapter not
using sqlplus of 11g I could not connect to Oracle database 10g. http://exploreoracle.blogspot.com/2009/03/ora-12557-tnsprotocol-adapter-not.html Below is an example,With 10.2g sqlplus I can connect to 10g database.C:\>e:\oracle\product\10.2.0\db_1\bin\BIN\sqlplus.exe shaik/a@192.168.100.160/tigerSQL*Plus: Release 10.2.0.1.0 - Production on Mon Jan 26 01:54:10 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsWith 11g sqlplus I could not protocol adapter connect to oracle database 10g. It returns error message, ORA-12557: TNS:protocol adapter not loadable.C:\>d:\app\oracle\BIN\sqlplus.exe shaik/a@192.168.100.160/tigerSQL*Plus: Release 11.1.0.6.0 - Production on Mon Jan 26 01:55:00 2009Copyright (c) 1982, 2007, Oracle. All rights reserved.ERROR:ORA-12557: TNS:protocol adapter not loadableCause of the ProblemThe problem happens because of two ORACLE_HOME are installed on your system. As after protocol adapter not 10g you hav e installed 11g so whenever you write sqlplus by default new 11g binaries are selected and raises ORA-12557. But working with old home 10g works fine.Simply sqlplus does not work but 10g home location sqlplus (e:\oracle\product\10.2.0\db_1\bin\BIN\sqlplus.exe ) works.C:\>sqlplus.exe shaik/a@192.168.100.160/tigerSQL*Plus: Release 11.1.0.6.0 - Production on Mon Jan 26 22:47:08 2009Copyright (c) 1982, 2007, Oracle. All rights reserved.ERROR:ORA-12557: TNS:protocol adapter not loadableConnecting to old oracle database using new binaries are not supported in oracle and error will return.Solution of the ProblemOnly setting ORACLE_HOME is not sufficient on windows environment. Because the location is taken from windows registry. So either uninstall newer oracle home or explicitly pointing to old oracle binaries will solve the problem.Here using pointing to old home,C:\>e:\oracle\product\10.2.0\db_1\bin\BIN\sqlplus.exe shaik/a@192.168.100.160/tigerSQL*Plus: Release 10.2.0.1.0 - Production on Mon Jan 26 01:54:10 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Minin