Reply Dinesh says: February 20, 2014 at 2:29 am Hi, Thank you for the article. You might need to set up an environment variable as described here: http://kb.tableausoftware.com/articles/knowledgebase/oracle-connection Like Show 1 Likes(1) Actions 2. It would give me this error when I had full=yes ... Again, extremely vague.
Make sure you can ping any server names short or long. Three: SQLPlus users, check for typos If you are using SQLPlus, first check for typos. Should I record a bug that I discovered and patched? How do I "Install" Linux?
Where is the process monitor log? This article solved my issue and my code is working once more. Are illegal immigrants more likely to commit crimes? Learn more You're viewing YouTube in Greek.
There should be no control characters at the end of the instance or database name. This check can be accomplished simply by going to the internet and being able to pull up this page. 12. Here is my attempt to clarify them: 1. "Alias" is referred to as "Connection Name" in Oracle SQL Developer. If it exists then make sure it has the right value as “Dir:\app\product\11.1.0\client_1\network\admin”.
The connection details in the TNSNames.ora file are picked up through the TNS_ADMIN system variable. You can not post a blank message. Browse other questions tagged oracle plsql sqlplus plsqldeveloper tnsnames or ask your own question. Sometimes that is what Oracle needs and wants - the whole connection.
If you're trying to connect to a private database using Oracle 9, edit your local tnsnames.ora file (the default location is C:\Program Files\oracle\ora92\network\Admin\tnsnames.ora). Contact the database administrator for the correct parameters, if necessary. Available online, offline and PDF formats. Check if the environment variable ‘PATH' has the path for tnsnames.ora file specified.
Show 7 replies 1. echo %TNS_ADMIN% If the path is not the directory where the tnsnames.ora file resides, then try changing the TNS_ADMIN path and then try connecting the db. Was able to edit the TNS_Names and to get it working after a 2nd Oracle Client attempt was made. This article doesn't explain why that might be the case. 4.
Verify that a tnsnames.ora file exists and is in the proper directory and is accessible. No complaints. Easy to use Average Difficult to use This article is: Thank you for your feedback. Worked beautifully… I wish ORACLE would get their act together on making integration with other systems easier.
Browse other questions tagged oracle oracle-11g-r2 import or ask your own question. Navigate, on your hard drive, to the Oracle installation. What is a tire speed rating and is it important that the speed rating matches on both axles? Like Show 0 Likes(0) Actions 4.
Look for the first time that Oracle appears. help me out error: ora-12154 tns could not resolve service name i am using windows 7 64 bit and oracle 11g Reply Umar says: November 18, 2015 at 11:52 am I Check the value of the key ”Oracle_Home” in the registry under HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient11g_home1 and verify that it has the right path for the Oracle home.
Check that the net service name used as the connect identifier exists in the tnsnames.ora file. For more informations : http://turfybot.free.fr/oracle/11g/errors/ORA-12154.html share|improve this answer answered Feb 17 '13 at 16:13 tufy 212 add a comment| up vote 1 down vote As I can't add a comment, just Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).