Pl Sql Developer Error Ora-12154
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 site About Us Learn more about Stack Overflow the company Business Learn more about hiring
Pl Sql Developer Not Logged On Error
developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question ora 12154 tns could not resolve service name pl sql developer x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; ora 12154 tns error in pl sql developer it only takes a minute: Sign up Error when trying to log in: ORA-12154 up vote 3 down vote favorite 1 I am using Oracle 10g and PL/SQL Developer for the development. I have already tested from Net Manager that
Error While Trying To Retrieve Text For Error Ora-12154
the database can be connected to, but when I tried to connect with PL/SQL Developer there was problem that I do not understand: ORA-12154: TNS:could not resolve the connect identifier specified I have already searched for solution for the problem but still it can't be resolved. Any advice? 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
Ora-12154 Tns Could Not Resolve The Connect Identifier
votes up vote 7 down vote accepted This was a hard one. tnsping works. tnsnames.ora is correct. This post solved it for me: http://sambitimes.blogspot.de/2010/10/ora-12154-error-in-windows-7.html If installation path of PL/SQL-Developer contains brackets, it screws up... This will not work with win7: "C:\Program Files (x86)\PLSQL Developer" this does for me: "C:\Program Files\PLSQL Developer" I hope it helps for others. share|improve this answer answered Jul 9 '12 at 8:42 Dirk Schumacher 408515 1 It should the accepted answer. –Luc M Nov 29 '12 at 14:22 Dirk, your answer really helps! I ran into the same issue and fortunately found your answer here. I just moved the sub dir of plsql developer from C:\Program Files (x86) to C:\Program Files and it's working now. Thank you and Nore. –Gary Mar 25 '14 at 14:48 add a comment| up vote 0 down vote That usually means that the database name you specify is not in the tnsnames.ora file. If you open PL/SQL Developer you will find the option "support info" under the About menu. This has an entry such as this: TNS File D:\Oracle\Designer\net80\admin\tnsnames.ora Make sure your database is in this file. share|improve this answer answered Feb 17 '12 at 7:05 Rene 6,28931932 I've checked that, and mine is correct –Nore Feb 17 '12 at 7:26 I think i would use other tools, and i have try to use Oracle SQL Developer, and its work!, bu
back to return to the previous page. Enter your Username and Password http://forums.allroundautomations.com/ubb/ubbthreads.php?ubb=showflat&Number=33783 to log in. If you have not yet registered, you can register here. Username: Password: Have you forgotten your login information? Mark all read Contact Us · · Top Generated in 0.008 seconds in which 0.001 seconds were spent on a total of 3 queries. Zlib compression disabled.Powered by UBB.threads™ PHP Forum Software 7.4.1p2
to friend Not able to login PL/SQL Developer ( Error ORA-12154:) [message #571108] Wed, 21 November 2012 03:09 Manoj.Gupta.91 Messages: 217Registered: March 2008 Location: Delhi Senior Member Hi All, I'm not able to login to PL/SQL Developer 7.0.3.1123. I'm http://www.orafaq.com/forum/t/185013/ receiving "ORA-12154: TNS: could not resolve the connect identifier specified" error. Although it lists all TNS entries in Database drop down. It was working fine last week but now I'm not able to login. Please suggest what http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=37446 could be the issue. Thanks & Regards Manoj Report message to a moderator Re: Not able to login PL/SQL Developer ( Error ORA-12154:) [message #571109 is a reply to message #571108] Wed, 21 pl sql November 2012 03:12 Littlefoot Messages: 20850Registered: June 2005 Location: Croatia, Europe Senior MemberAccount Moderator What changed since last week? Report message to a moderator Re: Not able to login PL/SQL Developer ( Error ORA-12154:) [message #571110 is a reply to message #571109] Wed, 21 November 2012 03:15 Manoj.Gupta.91 Messages: 217Registered: March 2008 Location: Delhi Senior Member Hi, In installed Brio software for SQR. Now I've UnInstalled this but PL/SQL Developer pl sql developer still giving me same error. Even I've UnInstalled and the Installed PL/SQL Developer 2-3 times but issue remains the same. 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. I'm using Windows 7 64 Bit OS. Please suggest Thanks & Regards Manoj Report message to a moderator Re: Not able to login PL/SQL Developer ( Error ORA-12154:) [message #571111 is a reply to message #571110] Wed, 21 November 2012 03:20 Michel Cadot Messages: 63912Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator ORA-12154: TNS:could not resolve the connect identifier specified *Cause: A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods configured. 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 could not be located or reached. *Action: - If you are using local naming (TNSNAMES.ORA file): - Make sure that "TNSNAMES" is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.
Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Scripts Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Papers Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Forum All threads Best last month Links Oracle official Oracle Technical Info Tools (free) Tools (commercial) Oracle FAQ Other DBA-sites Oracle development Not Oracle specific Oracle Blogs Imho Fqa Pirats | Start a new thread | All threads | Best last month | No question at this time DBA Top 10 1 M. Cadot 35800 2 F. Diaz 34000 3 J. Schnackenberg 16400 4 B. Vroman 15450 5 A. Kavsek 15250 6 P. Wisse 14250 7 T. Boles 13500 8 M. Hidayathullah ... 10900 9 A. Hudspith 9200 10 A. Khan 4100 About Advertise here Download PLATOThe free tool for auditing and tuning your databaseVersion 55 now available Sep 02, 2016 The DBA-Village forum as RSS feed Site StatisticsEver registered users47789Total active users2118Act. users last 24h10Act. users last hour2Registered user hits last week772Registered user hits last month2452 Go up ORA-12154: TNS could not resolve the connect identifier specified Next thread: Steps for Downgrade oracle 9i EE to standared edition Prev thread: How can I write a single query for this? Message Score Author Date I tried to log into oracle using pl/sql developer,...... gr am77 Aug 11, 2009, 16:25 Ping to abc.com is successful H:\>ping abc.com ...... gr am77 Aug 11, 2009, 16:25 Also, accidently I have installed 2 oracle homes. ...... gr am77 Aug 11, 2009, 19:04 What if I remove only one Oracle Home: KEY_OraClie...... gr am77 Aug 11, 2009, 19:25 is your tnsnames.ora located here: C:\oracle\prod...... Zoran Hudec Aug 11, 2009, 22:44 The name in TNS entry is xyz, try using xyz when d...... Sandeep Malik Aug 11, 2009, 22:47 My previous post with assumption that you have set...... Sandeep Malik Aug 11, 2009, 22:49 Zoran: Yes, my tnsnames is present in: C:\oracle...... gr am77 Aug 12, 2009, 16:22 Sandeep: tnsping xyz also successful: H:\>tnsp...... gr am77 Aug 12, 2009, 16:23 Sandeep/Zoran: The problem here seems that I have...... gr am77 Aug 12, 2009, 16:28 you only have to define TNS_ADMIN=C:\oracle\prod...... Zoran Hudec Aug 13, 2009, 02:04 Follow up by mail Click here Subject: ORA-12154: TNS could not resolve the connect identifier specified Author: gr am77, United Kingdom Date: Aug 11, 2009, 16:25, 2630 days ago Os info: WindowsXP Oracle info: 10g