472,342 Members | 1,557 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,342 software developers and data experts.

Tns name Not Found


I am new To Oracle.When I am trying to log in Sql* Plus , There It is asking for the USername And Password,I Put that Information .After that it ask me Host string.. What should I Put there.When I put there it says "Tns name Not found". what is the concept of Tns what does it represents.

I found the same error when i try to login in PLSQL developer to do my work.

Can anyone help me.
Mar 4 '09 #1
10 4945
13,262 8TB
You need to verify that the credentials you are providing match the ones in the tnsnames.ora file in your oracle directory. If you have the SQL Net Easy Configuration wizard then run it to correct and verify your configuration.
Mar 4 '09 #2
308 256MB
Then what does the host string represents ..?
Mar 4 '09 #3
Hi All,

Thanks for the time you gave to resolve my question .

Anyways madankarmukta,
I am asking Hoststring in the context when we try to login in sql* plus .
Mar 4 '09 #4
8,127 Expert 4TB
host string is the name of the database that you are trying to connect. If you have not specified any other name the default name would be ORCL. If the DB is installed on your pc you need not specify the HOST STRING.
Mar 5 '09 #5
Okay.. SO the host string is basically the IP address of the machine where the database is installed..Please correct me If I am going wrong.

It means if the oraganizantion is having a shared machine with the Db instyalled on it and the one acting as a oracle server , then while accessing database we need to specify that IP in the host string for login in sql* plus which in turn need to specify in tns.ora file.

Please correct me If I am getting wrong.
Mar 5 '09 #6
8,127 Expert 4TB
you need the name of the database not the IP address of the system.
Mar 5 '09 #7
785 Expert 512MB
It represents the host-name, the port number and the database name (= SID, =ServiceID). It can also contain additional non-mandatory parameters.
You can give it directly or you just give a single name as reference.
This single name then is looked up in the tnsnames.ora file.

as direct string:
or as reference:
If you give it as reference, you must have following entry in tnsnames.ora file:
Expand|Select|Wrap|Line Numbers
  1. myOra=
  3.     (ADDRESS_LIST =
  4.        (ADDRESS =
  5.           (PROTOCOL = TCP)
  6.           (HOST = myHostNameOrIp)
  7.           (PORT = 1526)
  8.        )
  9.     )
  10.     (CONNECT_DATA =
  11.        (SID=myOracleDB)
  12.     )
  13.   )
Buy the way, you can use "tnsping" to see if the connection is ok or not.
Mar 9 '09 #8
Host String refers to database name or SID.
Mar 10 '09 #9
Thanks for the detailed and explanatory answer.

So, I need to add the reference in tnsnames.ora file containing protocol ,Host and other information which Oracle server will use during startup.

Thank you very much.
Mar 10 '09 #10
785 Expert 512MB
Not necessarily. It is advised, but sometimes you can't do it because you have no rights to modify this file. You have 2 other options:
1.) give the long string directly
2.) make an entry in database table USER_DB_LINKS. Put the long string there in column HOST
Mar 10 '09 #11

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Andrew Thompson | last post by:
I have written a few scripts to parse the URL arguments and either list them or allow access to the value of any parameter by name....
by: Srini | last post by:
I was reading the "Exceptional C++" of Herb Sutter. In an example, he mentions the following. // In some library header: namespace N { class...
by: spike | last post by:
Im trying to write a program that should read through a binary file searching for the character sequence "\name\" Then it should read the...
by: Maarten Verhage | last post by:
Hi All, I've made a modified version of the Expat elements.c example. What I want the program to do is to recognize a hardcoded...
by: aallee83 | last post by:
i'm new in asp.net after develop my solution i copied it on the server where I want it to run but something cares... WHAT?!?! thank you in advance...
by: Olav Tollefsen | last post by:
I get the included error message when trying to run my ASP.NET application under Windows Server 2003 (with all updates installed). How can I...
by: sounak | last post by:
How could we get a macro name from a macro value such that in a header file #define a 100 #define b 200 now the source file will be such that...
by: Alexander Walker | last post by:
Hello I would like to write a method that allows me to pass a reference to an instance of a class, the name of a property of that class and a...
by: martin DH | last post by:
I have an Access database of employees. Each employee has a unique identification number called "BANNER_ID". Each employee's last name and first...
by: vineetbindal | last post by:
Hi All, I am new to silverlight and i am following a tutorial. In order to connect to database in silverlight application i need to add a...
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.