Odp.net 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
Ora 12154 Tns Could Not Resolve The Connect Identifier Specified 10g
about Stack Overflow the company Business Learn more about hiring developers or posting ads ora-12154 tns could not resolve the connect identifier specified windows 7 with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow
Ora-12154 Oracle 12c
is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ODP.NET ORA-12154 TNS error only when run as service up vote 4 ora 12154 error in oracle 11g down vote favorite I am writing a service in VB.NET to continually log data to an Oracle DB using ODP.NET The application was originally written as a basic Windows Forms App and works however when I port it to a service it seems it cannot see the TNS file and the following error message is thrown: Service cannot be started. Oracle.DataAccess.Client.OracleException ORA-12154:TNS:could not resolve the connect identifier specified So tns could not resolve the connect identifier specified sqlplus when using the following example connectstring "Data Source= example;User Id= user;Password=password;" I get ORA-12154 If I provide the full TNS entry directly to the app e.g "Data Source= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = EXAMPLE)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = EXAMPLE) ) );User Id= user;Password=password;" Then it works but when I originally developed the app as a Forms Application it worked either way. I assumed maybe the environment variables were not set up correctly but I have added the required system variables (ORACLE_HOME / TNS_ADMIN / added the oracle folder to PATH) and it doesnt work. The path the service is being run/was installed from does not contain parentheses, I have checked the process with process monitor and it looks like it is being started up with the correct environment variables (ORACLE_HOME / TNS_ADMIN / PATH are all there and correct). The machine being used for testing is running Win XP What am I missing here? Thanks vb.net oracle service odp.net share|improve this question edited Jul 30 '14 at 15:23 Ortomala Lokni 7,48453068 asked Nov 9 '12 at 14:15 user1671538 547 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote accepted I suspect that th
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript
Ora 12154 Tns Could Not Resolve Service Name
back on and reload this page. Please enter a title. You ora-12154 sqlplus can not post a blank message. Please type your message and try again. More discussions in
Oracle Managed Data Access
General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 1 2 3 4 5 6 Previous Next 84 Replies Latest reply on Aug 4, http://stackoverflow.com/questions/13309702/odp-net-ora-12154-tns-error-only-when-run-as-service 2010 1:51 PM by rajeysh Go to original post This content has been marked as final. Show 84 replies 45. Re: ORA-12154 error plz help me 458726 Apr 26, 2006 12:50 PM (in response to 508936) Triple post? Try: C:> sqlplus u2/u2@mat Like Show 0 Likes(0) Actions 46. Re: ORA-12154: TNS:could not resolve the https://community.oracle.com/thread/269600?start=45&tstart=0 connect identifier specified 509395 Jun 26, 2006 12:37 PM (in response to 452882) You may want to check out this tutorial. http://www.devshed.com/c/a/Oracle/Experience-the-Possibilities-with-Oracle-10g-Express-Edition/ For other tutorials on Oracle check out this link: http://www.angelfire.com/vt2/hodentek/ It's a shame so many people have to spend so much time trouble shooting this ORA-12154 error. Oracle guys should come out with a definitive answer. Like Show 0 Likes(0) Actions 47. Re: ORA-12154: TNS:could not resolve the connect identifier specified orafad Jun 26, 2006 2:37 PM (in response to 509395) It's a shame so many people have to spend so much time trouble shooting this ORA-12154 error.Agreed. Oracle guys should come out with a definitive answer.Dont think they can give you one. It depends on your specific installation(s) and configuration. It could be some multi-home issue or Oracle Net domain name related.... To start with, you should check which Oracle home you are using really (registry, PATH etc.), then check that sqlnet.ora and tnsnames.ora "matches"
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join https://www.experts-exchange.com/questions/21827159/ORA-12154-TNS-could-not-resolve-the-connect-identifier-specified-error-in-C-code.html Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > https://forums.asp.net/t/1610218.aspx?ORA+12154+TNS+could+not+resolve+the+connect+identifier+specified Questions > ORA 12154 : TNS : could not resolve the connect identifier specified( error in C# code) Want to Advertise Here? Solved ORA 12154 : TNS : could not resolve the connect identifier specified( error in C# code) Posted on 2006-04-25 Oracle Database 3 Verified Solutions 10 Comments 7,427 Views Last Modified: 2008-03-10 Hi, I am trying to connect to oracle database 10 tns could g using visual C# 2005. I am using ODP.Net for connecting to the database. I have configured .Net Configuration Assistant in the Programs->Oracle-OraDb10g_home1->Configuration and Migration Tools ->.Net Configuration Assistant. I have installed ODP.Net on my machine. I have referenced Oracle.DataAccess.dll (under dir client1) in the program ( in solution explorer ->add reference).Below is my code: using System; using System.Collections.Generic; using System.Text; using Oracle.DataAccess.Client; namespace VamConnect { class Program { static void tns could not Main(string[] args) { string constr = "User Id=SYSTEM;Password=mskiranavk;Data Source=orcl"; OracleConnection con = new OracleConnection(constr); con.Open(); Console.WriteLine("Connected to Oracle" + con.ServerVersion); con.Close(); con.Dispose(); } } } When I try to run these code I am getting an unhandled exception :ORA 12154 : TNS : could not resolve the connect identifier specified. I have tried to change the tnsnames.ora and listener.ora , however could not connect. Anyone please help me with this code. Its urgent... thanks in advance vamshi 0 Question by:vamshiav1 Facebook Twitter LinkedIn Google LVL 4 Best Solution bycsachdeva 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 Go to Solution 10 Comments LVL 142 Overall: Level 142 Oracle Database 38 Message Active today Assisted Solution by:Guy Hengel [angelIII / a3]2006-04-25 >I have tried to change the tnsnames.ora and listener.ora can you post the content of tnsnames.ora (and sqlnet.ora) 0 Message Author Comment by:vamshiav12006-04-25 hi angel thanks for the response: The contents of TNSNAMES.ORA: # tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\netwo
ASP.NET Community Standup Forums Help Home/ASP.NET Forums/Data Access/Oracle, MySQL, Sybase, Informix and other databases/ORA-12154: TNS:could not resolve the connect identifier specified ORA-12154: TNS:could not resolve the connect identifier specified [Answered]RSS 3 replies Last post Oct 11, 2010 09:03 PM by Lannie ‹ Previous Thread|Next Thread › Print Share Twitter Facebook Email Shortcuts Active Threads Unanswered Threads Unresolved Threads Support Options Advanced Search Reply mrrogers Member 53 Points 783 Posts ORA-12154: TNS:could not resolve the connect identifier specified Oct 06, 2010 01:58 PM|mrrogers|LINK I have a fresh install of 10g ODACthat I have loaded.My Oracleclient interface connects to the db just fine but when I attempt to connect with my ASP.NET project, I get the following error: ORA-12154: TNS:could not resolve the connect identifier specified Can anyone help out on this? Reply grundebar Contributor 3065 Points 726 Posts Re: ORA-12154: TNS:could not resolve the connect identifier specified Oct 06, 2010 03:43 PM|grundebar|LINK I've had the same error and I eventually formattedmy connection string like this: Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=YOURIPADDRESS)(PORT=YOURPORT))(CONNECT_DATA=(SID=YOURSID)));User Id=USERNAME;Password=PASSWORD; That got me through to our instance of a 10g database. "What I hear, I forget; What I see, I remember; What I do, I understand." --Confucius Remeber to Mark as Answer if this post helped you. Reply mrrogers Member 53 Points 783 Posts Re: ORA-12154: TNS:could not resolve the connect identifier specified Oct 07, 2010 07:22 AM|mrrogers|LINK I will try that today but there has to be something else that I can do because I have this app running on severaldifferentmachines and they work find just with a standard connection string. There has to be some Oracle setting that is missing. Reply Lannie Contributor 3172 Points 1163 Posts ORA-12154: TNS:could not resolve the connect identifier specified Oct 11, 2010 09:03 PM|Lannie|LINK Of course, ODP.NET Client should be installed on each machine This simplied connection works for me without need to recreate what is already in TNSNAMES.ORA file. When using built in Microsoft Oracle ASP.NET client