Tns name Not Found

NewToOracle

Hi,

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 127.0.0.1 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.

r035198x

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.

madankarmukta

Quote:

Originally Posted by r035198x

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.

Then what does the host string represents ..?

NewToOracle

Quote:

Originally Posted by madankarmukta

Then what does the host string represents ..?

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 .

debasisdas

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.

NewToOracle

Quote:

Originally Posted by debasisdas

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.

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.

debasisdas

you need the name of the database not the IP address of the system.

chaarmann

Quote:

Originally Posted by madankarmukta

Then what does the host string represents ..?

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.

Example:
as direct string:

"(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = myHostNameOrIp)(PORT = 1526)))(CONNECT_DATA =(SID=myOracleDB))"

or as reference:

"myOra"

If you give it as reference, you must have following entry in tnsnames.ora file:

Expand|Select|Wrap|Line Numbers

 myOra=

  (DESCRIPTION =

    (ADDRESS_LIST =

       (ADDRESS =

          (PROTOCOL = TCP)

          (HOST = myHostNameOrIp)

          (PORT = 1526)

       )

    )

    (CONNECT_DATA =

       (SID=myOracleDB)

    )

  )

Buy the way, you can use "tnsping" to see if the connection is ok or not.

Jibran

Host String refers to database name or SID.

NewToOracle

Quote:

Originally Posted by chaarmann

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.

Example:
as direct string:

"(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = myHostNameOrIp)(PORT = 1526)))(CONNECT_DATA =(SID=myOracleDB))"

or as reference:

"myOra"

If you give it as reference, you must have following entry in tnsnames.ora file:

Expand|Select|Wrap|Line Numbers

 myOra=

  (DESCRIPTION =

    (ADDRESS_LIST =

       (ADDRESS =

          (PROTOCOL = TCP)

          (HOST = myHostNameOrIp)

          (PORT = 1526)

       )

    )

    (CONNECT_DATA =

       (SID=myOracleDB)

    )

  )

Buy the way, you can use "tnsping" to see if the connection is ok or not.

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.

chaarmann

Quote:

Originally Posted by NewToOracle

So, I need to add the reference in tnsnames.ora file containing protocol

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

Tns name Not Found

re: Tns name Not Found

re: Tns name Not Found

re: Tns name Not Found

re: Tns name Not Found

re: Tns name Not Found

re: Tns name Not Found

re: Tns name Not Found

re: Tns name Not Found

re: Tns name Not Found

re: Tns name Not Found

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about