12154 Error In Toad
Contents |
Oracle SQL Server PRODUCTSDiscussion & Resources Backup Reporter Benchmark Factory Code Tester for Oracle SQL Navigator SQL Optimizer for IBM DB2 SQL Optimizer ora 12154 toad for Oracle SQL Optimizer for SQL Server SQL Optimizer for SAP toad oracle ora 12154 ASE Spotlight on DB2 LUW Spotlight on Oracle Spotlight on SQL Server Spotlight on SAP ASE ora 12154 toad windows 7 Toad Intelligence Central Toad Data Modeler Toad Data Point Toad Decision Point Toad Extension for Eclipse Toad for Apache Hadoop Toad for IBM DB2 Toad for MySQL ora 12154 error in oracle 11g Toad for Oracle Toad for SQL Server Toad for SAP Solutions Toad Mac Edition Home » Products » Toad for Oracle » Toad for Oracle Forum » ORA-12154: TNS:could not resolve the connect identifier specified ORA-12154: TNS:could not resolve the connect identifier specified Toad for Oracle Community Join Overview Forum Blog Idea Pond Connections
Error 12154 Received Logging On To The Standby 11g
Debug Editor General Grid Import/Export Monitor MyToad Other Schema Browser Team Coding Utilities Wiki Media Toad Apps Toad for Oracle Videos Beta Beta Overview Beta Forum Members Support Forum Options RSS Feed Tweet Related Posts Toad 12.7.0.121 : ORA-12154: TNS:could not resolve the connect identifier specified by sergiovalle on 22 Jun 2015 ORA-12154 tns: could not resolve service name by sdhalepaska on 11 Dec 2013 Suggested Answer Cannot Resolve Connect Identifier by TammyM on 8 Feb 2012 View More This question has suggested answer(s) ORA-12154: TNS:could not resolve the connect identifier specified Follow telo / 11 Feb 2014 at 8:29am Hi, I try to create connection to Oracle database 10.2 using toad 12.1.0.22, but I get this error. I can TNSPING my database & SQLPLUS work fine. Can anybody help me resolve this error? Thanks, Telo Create an account to join the discussion. You have posted to a forum that requires a moderator to approve posts before they are publicly available.
Blog Contact Us Search The Blog M&S News and Insights TOAD for Oracle 9 or TOAD 10 - 64-bit Windows - ORA-12154: could not resolve the connect identifier specified or ORA-6413: connection not open TOAD for Oracle 9 or TOAD 10
Error 12154 Connecting To
- 64-bit Windows - ORA-12154: could not resolve the connect identifier specified or ORA-6413: error 12154 received logging on to the standby rac connection not open I recently downloaded the new 10.x version of TOAD and could not connect to my databases. Still running TOAD 9.x, error 12154 connecting to standby host no problem. This really threw me off for a minute, so I thought I would share the resolution. You are likely running a 64-bit Windows OS and have installed TOAD into C:\Program Files (x86)\.... I simply copied http://www.toadworld.com/products/toad-for-oracle/f/10/t/21292 over my entire Quest Software directory from C:\Program Files (x86)\... to C:\Program Files\..., and restarted the TOAD.exe. Everything is working great, without having to reinstall anything. PS: Not sure who to blame here. Vendors (like Oracle and TOAD) should know Microsoft is capable of doing strange things with important directory names (using spaces and, in this case, "strange" characters like parentheses)…and of course, Microsoft should simply stop perpetuating the use of these characters in important http://www.mandsconsulting.com/toad-for-oracle-9-or-toad-10-64-bit-windows-ora-12154-could-not-resolve-the-connect-identifier-specified-or-ora-6413-connection-not-open directories. UPDATE on 1/12/11: I had to install TOAD again today and noticed a message in the installer about directories with parentheses -- glad to see Quest now added a note about it (see screenshot below). Funny thing is, even though I installed to C:\Program Files\, there were still files created in C:\Program Files (x86)\ that I had to manually copy and paste over. This time, by the way, I cut and paste which also worked -- so no files are actually needed in the C:\Program Files (x86)\ folders. Tags:in the trenches, oracle dev, oracle sql, quest toad 86 Comments on “TOAD for Oracle 9 or TOAD 10 - 64-bit Windows - ORA-12154: could not resolve the connect identifier specified or ORA-6413: connection not open” Reply Dan04.13.2012 at 10:16 am I wasted 9 straight hours trying to figure this out with no luck. I finally gave up and resorted to google; and bingo! Your post helped me out. Many thanks. Reply venky05.17.2012 at 11:28 pm thank you very much…i spent lot of time….your post totally helped me…thanks so much Reply Silvia05.25.2012 at 5:12 am Thank you very much for the post! It has been very useful. Reply Vikas S07.30.2012 at 1:34 am It worked for me too. I simply copied over my entire Quest Software directory from C:\Program Files (x86)\… to C:\Pro
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies http://stackoverflow.com/questions/8690206/error-in-toad-ora-12154 of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x 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: ora 12154 Sign up Error in Toad - ora 12154 up vote 1 down vote favorite I am trying to make a connection using Toad to a database (xe10 free edition) and it givea me a error: ORA-12154 I tried changing the sqlnetORA to: SQLNET.AUTHENTICATION_SERVICES= (NONE) and still the same error. oracle toad share|improve this question edited Dec 31 '11 at 19:52 emaillenin 10.6k94890 12154 error in asked Dec 31 '11 at 19:46 Raguraman Thuraiyur 23126 try to ping to the database server –emaillenin Dec 31 '11 at 19:50 i find that IP is: 198.11.34.43 is correct? i attach the ping Estadísticas de ping para 198.11.34.43: Paquetes: enviados = 4, recibidos = 4, perdidos = 0 (0% perdidos), –Raguraman Thuraiyur Dec 31 '11 at 19:52 2 sorry I think that is not English –emaillenin Dec 31 '11 at 19:55 is not a database., is my personal laptop windows 7 64 bits –Raguraman Thuraiyur Dec 31 '11 at 19:57 Did you check the tnsnames.ora file ? can you provide its contents ? –A.B.Cade Dec 31 '11 at 22:07 | show 6 more comments 2 Answers 2 active oldest votes up vote 0 down vote 1st check to make sure you can ping the database, if yes move to next step if not resolve firewall/network issues. 2nd check to see if you can connect via SQL*plus. If you can connect with SQL+ then your TNS is fine and Toad seems to be the issu