Ora 12154 Tns Error In Toad
Contents |
NoSQL Oracle SQL Server PRODUCTSDiscussion & Resources Benchmark Factory Code Tester for Oracle SharePlex SQL Navigator SQL Optimizer Spotlight Stat Toad Intelligence Central Toad Data Modeler Toad Data Point Toad Extension for
Ora 12514 Toad
Eclipse Toad for Hadoop Toad for IBM DB2 Toad for Oracle Toad for toad tns_admin environment variable is not defined MySQL Toad for SQL Server Toad for SAP Solutions Toad MAC Edition Home » Products » Toad for
Ora 12154 Tns Could Not Resolve Service Name
Oracle » Toad for Oracle Forum » Unable to resolve tns names Unable to resolve tns names Toad for Oracle Community Join Overview Forum Code Tester for Oracle Forum Spotlight on Oracle tnsnames.ora location Forum SQL Optimizer for Oracle Forum Toad for Oracle Forum Blog Code Tester for Oracle Blog Spotlight on Oracle Blog SQL Optimizer for Oracle Blog Toad for Oracle Blog Idea Pond Connections Debug Editor General Grid Import/Export Monitor MyToad Other Schema Browser Team Coding Utilities Wiki Code Tester for Oracle Wiki Spotlight on Oracle Wiki SQL Optimizer for Oracle Wiki Toad for Oracle toad for oracle Wiki Media Code Tester for Oracle Videos Spotlight on Oracle Videos SQL Optimizer for Oracle Videos Toad Apps Toad for Oracle Videos Beta Beta Overview Beta Forum Members Forum Options RSS Feed Tweet Related Posts ORA-12154 tns: could not resolve service name by sdhalepaska on 11 Dec 2013 Suggested Answer Cursor Rowtype as Argument in Procedure throws "Unable to resolve type" by marc.juschkeit on 30 Sep 2014 Not Answered Cannot Resolve Connect Identifier by TammyM on 8 Feb 2012 View More This question is not answered Unable to resolve tns names Follow victor.sebaratnam / 9 Jun 2014 at 2:04am sqlnet.ora Hi I am using Win 7 with Toad 12.1 Previously I used Toad 9.1 on win XP Using Ora92 client. However when I connect to Oracle11 DB, I get the following error Error ORA-12154: TNS:could not resolve service name Items Checked [Pass] TNS_ADMIN environment variable is defined as "C:\Oracle\config" [Pass] "C:\Oracle\config\tnsnames.ora" was located [Pass] The following connect descriptor was found for TRIADP in the tnsnames.ora file TriadP = (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=se394)(PORT=1521))(CONNECT_DATA=(SID=TriadP))) [Pass] "C:\Oracle\config\sqlnet.ora" was located [Pass] NAMES.DIRECTORY_PATH specifies TNSNAMES in the sqlnet.
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 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 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: http://www.toadworld.com/products/toad-for-oracle/f/10/t/22112 Sign up ORA-12154: TNS:could not resolve the connect identifier specified using TOAD client up vote 0 down vote favorite I try to using connect with remote database using TOAD client. My oracle version is 10.2g. I follow these instructions that specified on this link, instead of step 13, because i cant understand what they explain link. My Oracle TNS_ADMIN path is C:\oracle\product\10.2.0\db_1\network\ADMIN and http://stackoverflow.com/questions/19157915/ora-12154-tnscould-not-resolve-the-connect-identifier-specified-using-toad-cli ORACLE_HOME is C:\oracle\product\10.2.0\db_1. I found may question regarding this query, but i am not found my answer. database error-handling oracle10g client toad share|improve this question edited Oct 3 '13 at 11:43 asked Oct 3 '13 at 11:22 Harmeet Singh Taara 1,66643270 What is in your tnsnames.ora, and how are you configuring the connection in Toad? –Alex Poole Oct 3 '13 at 12:22 In tnsnames.ora describe the description of my connection. TEST = (DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = TEST))) –Harmeet Singh Taara Oct 3 '13 at 12:37 add a comment| 2 Answers 2 active oldest votes up vote 2 down vote We encountered this issue as well with Toad 10.x and Oracle Instant Client 11.2.x. The (rather silly) solution for us was to add a comment to the very top of the tnsnames.ora file. So for Step #8 in the linked instructions, the tnsnames.ora file would have this instead: # Leave whitespace before your first entry below... VIS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta http://dba.stackexchange.com/questions/34952/ora-12154-tns-could-not-resolve-the-connect-identifier-specified-with-sqlplus Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database ora 12154 skills and learn from others in the community. 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 top ORA-12154 TNS: could not resolve the connect identifier specified with SQLPLUS up vote 3 down vote favorite I ora 12154 tns am using Toad to connect my database and its working fine for me . But when i try to connect with the same credential , i am getting the error message as shown below: ORA-12154 TNS: could not resolve the connect identifier specified Steps: Opened command promt Reach to the path of SQLPLUS (C:\programs\Oracle\Ora11g\BIN) C:\programs\Oracle\Ora11g\BIN\sqlplus username@schema_name Enter Password : ERROR: ORA-12154 TNS: could not resolve the connect identifier specified But when i open this with the owner of the schema ,it works for me C:\programs\Oracle\Ora11g\BIN\sqlplus schema_name@schema_name Enter Password: Connected to :...................... So,my question is why my username is not able to connect that particular schema ,while the owner of that schema can connect . Note:I can connect to that schema with my username with Toad ,but not with sqlplus My TNSNAME.ORA is under TNS_ADMIN folder Please help me out of this . oracle sqlplus connectivity share|improve this question asked Feb 18 '13 at 15:04 Gaurav Soni 2112310 add a comment| 2 Answers 2 active oldest votes up vote 1 down vote accept