Oracleconnection Tns Error
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
Tns Could Not Resolve The Connect Identifier Specified Oracle 11g
Stack Overflow the company Business Learn more about hiring developers or posting ads with tns could not resolve the connect identifier specified windows 7 us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is
Tns:could Not Resolve The Connect Identifier Specified Sqlplus
a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up this is error ORA-12154: TNS:could not resolve the connect identifier specified? up vote 5 tns could not resolve the connect identifier specified odbc down vote favorite 5 I've this code : OracleConnection con = new OracleConnection("data source=localhost;user id=fastecit;password=fastecit"); con.Open(); string sql="Select userId from tblusers"; OracleCommand cmd = new OracleCommand(sql, con); OracleDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { messageBox.Show(dr[0].Tostring()); } Same code in both projects, in project1 "WinForm" Is Working correctly in project2 "Excel 2007 addins" Following error appears: ORA-12154: TNS:could not resolve the connect identifier specified I'm using C#.net 2010 ,office 2007 , ora-12154 tns could not resolve service name windows8, oracle 10g. When preparing a manual connection to the database, as shown in the picture Visual Studio, open View menu + Server Explorer. Right mouse click on Data Connection + Add Connection + Select Oracle Database server Name : localhost or name of my machine, set username & password and click on Test Connection, test is no succeeds. c# oracle excel-addins share|improve this question edited Jun 2 at 11:09 Alex Weitz 7252519 asked Dec 3 '13 at 20:46 محمد النعيمي 1711315 1 don't you have to specify the database name somewhere ? –Habib Dec 3 '13 at 20:47 Yes, I can not specify the database somewhere –محمد النعيمي Dec 3 '13 at 20:51 The same code works correctly in Project1 "winForms" and on the same machine, but it does not work in another project "Excel 2007 addins" –محمد النعيمي Dec 3 '13 at 20:54 Is either project1 or project2 64-bit? Do you have more than one Oracle Home in your PATH environment variable? –helrich Dec 3 '13 at 21:08 project1 "winForms" Platform =x86 , output type =WindoseApplaciton.Project2 Platform =active any cpu,output type "Class Library" –محمد النعيمي Dec 3 '13 at 21:30 | show 2 more comments 2 Answers
TNS:received bad packet type from network layer Cause: Internal error. Action: Not normally visible to the user. For further details, turn on tracing and reexecute the operation. If error persists, contact Worldwide Customer Support. ORA-12152: TNS:unable to
Tns Could Not Resolve The Connect Identifier Specified Oracle 10g
send break message Cause: Unable to send break message. Connection probably disconnected. Action: Reestablish error while trying to retrieve text for error ora-12154 connection. If the error is persistent, turn on tracing and reexecute the operation. ORA-12153: TNS:not connected Cause: Not currently connected to
Ora-12154 Tns Could Not Resolve Service Name Oracle 11g
a remote host. Action: Reestablish connection. 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 http://stackoverflow.com/questions/20361325/this-is-error-ora-12154-tnscould-not-resolve-the-connect-identifier-specified 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 https://docs.oracle.com/cd/B19306_01/server.102/b14219/net12150.htm of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA) - Verify that a TNSNAMES.ORA file exists and is in the proper directory and is accessible. - Check that the net service name used as the connect identifier exists in the TNSNAMES.ORA file. - Make sure there are no syntax errors anywhere in the TNSNAMES.ORA file. Look for unmatched parentheses or stray characters. 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 in the Oracle Net profile (SQLNET.ORA). - Verify that the LDAP directory server is up and that it is accessible. - Verify that the net service name or database name used as the connect identifier is configured in the directory. - Verify that the default context being used is correct by specifying a fully qualified net service name or a full LDAP DN as the connect identifier - If you are using easy connect naming: - Verify that "EZCONNECT" is listed as one of the values of the NAMES.DIRETORY_PATH parameter in the Oracle Net profile (SQLNET.ORA). - Make sure the host, port and service name specified are correct. - Try enclosi
Last updated: April 22, 2016 - 4:40 am UTC Category: SQL*Plus � Version: 9.2.0 Whilst you are here, check out some content from the AskTom team: Fine-tuning the Quiz-taking Experience on https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:431775600346873836 the Oracle Dev Gym Latest Followup You Asked i'm running oracle on standalone computer at home.it used to work properly but from couple of days i'm getting error stating "ORA-12560: TNS:protocol adapter error " what should i do? please help.. (scott/tiger) and we said... sounds like the database is not up. you probably restarted your machine and the instance is could not not set to autostart C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:43:55 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options scott%ORA10GR1> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the could not resolve Partitioning, OLAP and Data Mining options C:\Documents and Settings\tkyte>net stop oracleserviceora10gr1 The OracleServiceORA10GR1 service is stopping......... The OracleServiceORA10GR1 service was stopped successfully. C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:44:35 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: ERROR: ORA-12560: TNS:protocol adapter error SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus C:\Documents and Settings\tkyte>net start oracleserviceora10gr1 The OracleServiceORA10GR1 service is starting.......... The OracleServiceORA10GR1 service was started successfully. C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:45:12 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options scott%ORA10GR1> in the above ora10gr1 is my oracle sid, you can use control panel instead - control panel -> services -> look for the services starting with Oracle. Reviews Write a Review Another method September 10, 2007 - 3:15 am UTC Reviewer: Aran