See Also: "Localized Configuration File Support"http://download-west.oracle.com/docs/cd/B10501_01/network.920/a96580/config_c.htm#484186 for configuration file location information 2. Put your tnsnames.ora in the %ORACLE_HOME%\network\admin directory. –Philᵀᴹ Feb 5 '13 at 14:53 @Phil yep the TNSNAMES.ORA file can be found there C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN –Confused Feb 5 '13 at 14:54 Will this leave me with only one Oracle Home? Browse other questions tagged oracle plsql sqlplus plsqldeveloper tnsnames or ask your own question. this page
If problem still persists, try to re-create TNS entry in tnsnames.ora. You might have to add the Oracle bin path to the %PATH% –Philᵀᴹ Feb 5 '13 at 14:59 @Phil I get an OK response when I run that. I created a new folder in c:\Oraclex86, in that folder I installed the oracle 11g R2 Client for x86 I have installed the PLSQL Developer in c:\ProgramFiles cause I read in The problem found was that the database name was not correct in the TNS file but for some reason it's been working for years. http://stackoverflow.com/questions/12825635/ora-12154-tnscould-not-resolve-the-connect-identifier-specified-plsql-develop
Even I've UnInstalled and the Installed PL/SQL Developer 2-3 times but issue remains the same. Diaz 34000 3 J. There should be no control characters at the end of the instance or database name. Words that are both anagrams and synonyms of each other How much interest did Sauron have in Erebor?
Although it lists all TNS entries in Database drop down. Join them; it only takes a minute: Sign up ORA-12154: TNS:could not resolve the connect identifier specified (PLSQL Developer) up vote 3 down vote favorite 1 I need to use PLSQL If you have multiple installations of Oracle software on one machine, easiest is to create a separate TNS_ADMIN directory and setup your TNS_ADMIN environment variable to point to that location. Ora-12154 Tns Could Not Resolve The Connect Identifier Not the answer you're looking for?
I did find that Oracle SQL Developer kept using the old TNS entry even after I updated it and I don't feel like reinstalling it for just one DB Connection. Ora-12545 tnsnames.ora is not found typo in the connect identifier mismatch in domain names. asked 3 years ago viewed 4219 times Related 4Referencing PL/SQL variables in FOR loop2Reconfigure the registry for new Oracle installation2SQL Developer cannot connect to Oracle database, yet sqlplus can!5How to run I've been trying to troubleshoot this issue on a Windows 7 workstation along with the Network Engineers and the Oracle DBA at where I work. –Bryan Jul 11 '14 at 15:19
If you are not using domain names, and this parameter exists, delete it or disable it by commenting it out. 7. http://dba.stackexchange.com/questions/121806/ora-12154-when-plsql-developer-11-is-trying-to-connect-to-database I have already tested from Net Manager that the database can be connected to, but when I tried to connect with PL/SQL Developer there was problem that I do not understand: Pl Sql Developer Not Logged On Error Sandeep Malik Aug 11, 2009, 22:49 Zoran: Yes, my tnsnames is present in: C:\oracle...... Ora 12154 Tns Error In Pl Sql Developer Browse other questions tagged oracle plsqldeveloper ora-12154 or ask your own question.
What is a tire speed rating and is it important that the speed rating matches on both axles? this website Copyright © 2003-2016 TechOnTheNet.com. if (λ x . Please feel free to come to the community to ask questions should you have other issues in the future. Error While Trying To Retrieve Text For Error Ora-12154
The only options I see at the moment are: Uninstall and try again Re-install Windows to make sure the settings are gone. Correcting the name fixed it for us. I'm not sure why I'm getting the error message 12154.Thanks in advance. Get More Info I am told by a colleague who is already using the connection that no updations into the hosts file is needed!
How do I replace and (&&) in a for loop? Tns-03505 Failed To Resolve Name Hudspith 9200 10 A. Follow ryanp / 24 Mar 2009 at 4:40pm I reinstalled oracle driver and it works now...
I have tried 64 bit and 32 bit versions. If you are using domain names, verify that your sqlnet.ora file contains a NAMES.DEFAULT_DOMAIN parameter. gr am77 Aug 12, 2009, 16:22 Sandeep: tnsping xyz also successful: H:\>tnsp...... Tnsping How to prove that a paper published with a particular English transliteration of my Russian name is mine?
How to explain the existence of just one religion? For example, if the type of connect identifier used was a net service name then the net service name could not be found in a naming method repository, or the repository you need FOO.WORLD rather than FOO) –Justin Cave Oct 10 '12 at 18:27 @JustinCave my computer doesn't have a domain name. see here Report message to a moderator Re: Not able to login PL/SQL Developer ( Error ORA-12154:) [message #571132 is a reply to message #571126] Wed, 21 November 2012 06:48
Words that are anagrams of themselves Where's the 0xBEEF? But the issue remsins the same Report message to a moderator Re: Not able to login PL/SQL Developer ( Error ORA-12154:) [message #571136 is a reply to message I need Oracle 10G 32 bit. Your rating?: This reply is Good Excellent Goto: Reply-Top of page If you think this item violates copyrights, please click here Subject: Re: ORA-12154: TNS could not resolve the connect identifier
How can I copy and paste text lines across different files in a bash script? When I go to connect in PL/SQL Developer I get: ORA-12154: TNS:could not resolve the connect identifier specified. (http://i.stack.imgur.com/UGpwD.png) I have set up my Oracle Home and added a value for