Home > Pl Sql > Pl Sql Developer Error Ora-12154

Pl Sql Developer Error Ora-12154

Contents

more hot questions question feed lang-sql about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Would TNS_ADMIN do any good? [Updated on: Wed, 21 November 2012 03:29]Report message to a moderator Re: Not able to login PL/SQL Developer ( Error ORA-12154:) [message #571117 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 If you are not using domain names, and this parameter exists, delete it or disable it by commenting it out. 7. this content

Boles 13500 8 M. Not the answer you're looking for? gr am77 Aug 12, 2009, 16:23 Sandeep/Zoran: The problem here seems that I have...... 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 Continued

Pl Sql Developer Not Logged On Error

Hudspith 9200 10 A. I don't knowwhy it didn't. See the Oracle Net Services Administrators Guide or the Oracle operating system specific guide for more information on naming.

All rights reserved. How to create a table of signs How much interest did Sauron have in Erebor? One reason of coming this error is if PL/SQL Developer is installed in "C:\Program Files (x86)" It must be installed in "C:\Program Files" which is correct in my case. Ora-12154 Tns Could Not Resolve The Connect Identifier Does sqlplus work?

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. Ora 12154 Tns Could Not Resolve Service Name Pl Sql Developer Sunday, September 22, 2013 Windows 7, PLSQL Developer, Connect Error "ORA-12154: TNS:could not resolve the connect identifier specified" Operating System version: Windows 7 Professional, Service Pack 1 PLSQL Developer version: 7.0.0.1050 Schnackenberg 16400 4 B. http://forums.allroundautomations.com/ubb/ubbthreads.php?ubb=showflat&Number=33783 http://www.mydigitallife.info/manual-and-clean-uninstall-oracle-for-windows/ I then installed Oracle 10G 32bit.

users last 24h10Act. Ora-12545 I don't know why this broke it. oracle plsqldeveloper ora-12154 share|improve this question edited Feb 18 '12 at 14:43 Burhan Ali 1,75711334 asked Feb 17 '12 at 6:43 Nore 731317 add a comment| 3 Answers 3 active oldest Do I need to do this?

Ora 12154 Tns Could Not Resolve Service Name Pl Sql Developer

It means that I need to either delete one of the Oracle Homes or Uninstall Oracle including the registry entries, and reinstall Oracle with only one Oracle Home.. How to make your world’s revolutions feel realistic? Pl Sql Developer Not Logged On Error Words that are anagrams of themselves Where's the 0xBEEF? Ora 12154 Tns Error In Pl Sql Developer At last you may add new entries using the SQL*Net Easy configuration utility.

Delete the HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE key which contains registry entries for all Oracle products by using regedit. http://iipseconline.com/pl-sql/pl-sql-developer-error-at-login.html I ran into the same issue and fortunately found your answer here. 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: tnsping works. Error While Trying To Retrieve Text For Error Ora-12154

I get the following error when I try to connect to my database. I'm talking about the domain (or lack thereof) on the TNS alias. Report message to a moderator Previous Topic: checking users execute previlege on ALIAS LIBRARY Next Topic: Not able to see euro symbol in pl/sql developer on have a peek at these guys ORA-12514, TNS listner does not currently know of service requested in connect descriptor TOAD: ORA-12154: TNS could not resolve the connect identifier specified (xyz) Goto: Reply-Top of page If you think

more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Tns-03505 Failed To Resolve Name Option #2 Make sure that the service name that you are connecting to is included in the TNSNAMES.ORA file and that it is correctly defined. Browse other questions tagged oracle plsqldeveloper ora-12154 or ask your own question.

Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the

Zlib compression disabled.Powered by UBB.threads™ PHP Forum Software 7.4.1p2

current community blog chat Database Administrators Database Administrators Meta your communities Sign up or log in to customize your list. So please answer Phil's question. –miracle173 Nov 24 '15 at 7:52 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote The message means: I can not Replies Follow [email protected] / 24 Mar 2009 at 4:33am Hi Ryanp,Can you TNSPING your database?------------------------------------------------------------------------ORA-12154: TNS:could not resolve service nameCause: Oracle Net could not locate the net service name specified in Tnsping An other frequent isssue is that sqlnet.default_domain is different than what is specified in the alias names in the tnsnames.ora.

more hot questions question feed lang-sql about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Browse other questions tagged oracle plsql sqlplus plsqldeveloper tnsnames or ask your own question. Now I've UnInstalled this but PL/SQL Developer still giving me same error. http://iipseconline.com/pl-sql/pl-sql-developer-not-logged-on-error.html if (λ x .

Please re-enable javascript in your browser settings. This link gave me an idea connect to MS Access so i created a user in oracle sql developer and the tried to connect to it in Toad and it worked. Why do units (from physics) behave like numbers? Errors in a TNSNAMES.ORA file may make it unusable. - If you are using directory naming: - Verify that "LDAP" is listed as one of the values of the NAMES.DIRETORY_PATH parameter

Although it lists all TNS entries in Database drop down. SQLNET.AUTHENTICATION_SERVICES = (NTS) That's anyone knows what I'm doing wrong? Fill in the Minesweeper clues Is this alternate history plausible? (Hard Sci-Fi, Realistic History) What is the possible impact of dirtyc0w a.k.a. "dirty cow" bug? Can I use my client's GPL software?

All rights reserved. It also makes upgrading a lot easier because the sql net configuration is outside of the software installation. Username: Password: Have you forgotten your login information? Do these physical parameters seem plausible?

You've installed the Oracle 10G client, right? Zoran Hudec Aug 11, 2009, 22:44 The name in TNS entry is xyz, try using xyz when d...... Your rating?: This reply is Good Excellent Goto: Reply-Top of page If you think this item violates copyrights, please click here Powered by Exitas - Belgium's leading Oracle Solution provider.