Oracle Components in Toolbox are greyed out in Visual Studio 2005 Web Application Can I use the latest download of Oracle Developer Tools 11g with an Oracle 10g or Oracle 9i Create an environment variable TNS_ADMIN=D:\oracle\product\12.1.0\dbhome_1\network\admin Sqlplus reads TNS_ADMIN from Registry but ODP.NET Managed Driver does not read the registry. Install 64bit 10.2.03 upgrade - Select the correct Oracle Home.However, It is strongly recommended to upgrade to Oracle 11G Release 1 version of Client tools (Build: 188.8.131.52.0) asked 5 years ago viewed 8548 times active 5 years ago Get the weekly newsletter!
When you try to connect from this new Oracle home, none of your old connect aliases will exist in the new copy of TNSNAMES.ORA, therefore you get this error. Word for fake religious people Did Donald Trump say that "global warming was a hoax invented by the Chinese"? Re: ORA-12154: TNS:could not resolve the connect identifier specified orafad Jun 26, 2006 2:37 PM (in response to 509395) It's a shame so many people have to spend so much time See also the FAQ entry, can I use ODT 11g with an Oracle 10 or Oracle 9 database?
Left by Elisa on Jan 29, 2013 10:03 AM # re: ORA-12154:TNS:could not resolve the connect identifier specified I currently have same issue here and will try your solution. Cris E St Paul, MN Reply Debarchan - MSFT says: February 2, 2010 at 9:31 am Chris, I appreciate your insights on this, indeed if you can move/rename your client application Reply Saeed says: June 11, 2014 at 8:35 am Very simple solution find below, solutions-ever.blogspot.com/…/ora-06413.html Reply Jeremy Thompson says: October 7, 2015 at 11:13 pm Just start Visual Studio with short Like Show 0 Likes(0) Actions 47.
Thanks! tnsping db6 gives OK (10 msec) –Derek Dec 10 '15 at 16:24 | show 2 more comments 2 Answers 2 active oldest votes up vote 0 down vote accepted Wernfried's comment I set the system environment variable for OraClient10g_home2 to c:\oracle\product\10.2.0\client_2 and restarted - still only worked from the network\admin directory. Name: *And who are you?
I've installed Oracle 11.2 32-bit client on my machine. After hours of work, I can finally tnsping and sqlplus connect but no ODBC connection. I installed Oracle Client 10.2.04 64bit, then tried 10.2.01 32bit and although the Oracle-Connect- and ODBC-Test were successful (32+64bit), I couldn't connect via ODBC from MS Excel to the database. You get a ORA-12154 error when you attempt to connect.
Like Show 0 Likes(0) Actions 49. https://community.oracle.com/thread/269600?start=45&tstart=0 No other changes were performed. Ora-12154: Tns:could Not Resolve The Connect Identifier Specified Re: ORA-12154: TNS:could not resolve the connect identifier specified 531112 Aug 31, 2006 3:42 PM (in response to 495468) Hi, Were you able to solve this problem? I can't find it!
Tnsnames.ora and sqlnet.ora work "together", so the connect string entry above should have read CtxSumry.europe.delphiauto.net = ... this contact form Browse other questions tagged c# .net oracle odp.net or ask your own question. I found it. But I am still getting this error when try to create entity framwork using ADO.NET.
Solution: Yes, you can use the newest 11g version of Oracle Developer Tools while developing code that relies on ODP.NET version 10g or 9i. Where should a galactic capital be? ORA-12154: TNS:could not resolve the connect identifier specified Scenario: You just installed Oracle Developer Tools, and now you cannot connect to the database using a Oracle connect alias that has worked http://deftmag.com/could-not/ora-12154-tns-could-not-resolve-the-connect-identifier.html Is it bad form to write mysterious proofs without explaining what one intends to do?
Too many advisors Four Birds + One I'm too cold, turn up the temperature Would presence of MANPADS ground the entire airline industry? Posted 29-Jan-15 1:25am Am Gayathri1.8K Updated 29-Jan-15 2:40am Nelek111.5K v3 Add a Solution 1 solution Rate this: Please Sign up or sign in to vote. Have u got the solution Left by ttt on Jun 21, 2012 3:54 PM # re: ORA-12154:TNS:could not resolve the connect identifier specified I just happened to run into the same
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL) Top Experts Last 24hrsThis month OriginalGriff 135 Jochen Arndt 70 ppolymorphe Since this automatic code generation is typically done infrequently, this may not impact you if you are using a pre-existing code base where this code generation was done with earlier versions Instance "oracle10gr2", status READY, has 1 handler(s) for this service... How can I solve this problem?
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar. Re: ora-12154 error 522475 Jul 10, 2006 11:36 PM (in response to 508936) I had this same error over and over. Running sqlplus works. The female equivalent of "don't break my balls" Is a two-prime lens possible?
Not the answer you're looking for?
© Copyright 2017 deftmag.com. All rights reserved.