OraFAQ Forum: Networking and Gateways » tnsnames.ora file not present

Home » RDBMS Server » Networking and Gateways » tnsnames.ora file not present (Oracle Version 10.2.0.1.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

tnsnames.ora file not present [message #477094]

Tue, 28 September 2010 08:41

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

Hi All,

I have Oracle 11g already installed on my system, today I installed Oracle 10g Version 10.2.0.1.0. When I was looking forward to add entries into the tnsnames.ora file in the admin folder which in present in NETWORK folder of Oracle. There was no file tnsname.ora.

can anyone tell me reason for this?

Thanks
Deepak

Report message to a moderator

Re: tnsnames.ora file not present [message #477095 is a reply to message #477094]

Tue, 28 September 2010 08:45

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>can anyone tell me reason for this?
TNSNAMES.ORA file is really a client file & not a DB Server file.
No TNSNAMES.ORA file is required to operate Oracle DB on server system.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: tnsnames.ora file not present [message #477291 is a reply to message #477095]

Thu, 30 September 2010 00:09

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

Hello Sir,

I agree to your answer but partially, we do have tnsnames.ora file in the server as well, and we do need to make the entries in the file, if we want to connect to the other database server.

It is not necessary that we need to make the connection through the Client only if we can connect through the entries in the tnsnames.ora file of the Server.

Correct me If I am wrong.

Thanks
Deepak

Report message to a moderator

Re: tnsnames.ora file not present [message #477296 is a reply to message #477291]

Thu, 30 September 2010 00:27

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You are not wrong but you question was:

Quote:

There was no file tnsname.ora. can anyone tell me reason for this?

And BlackSwan answered it. Unless you yourself put a tnsnames.ora there is no reason there is one.

Regards
Michel

Report message to a moderator

Re: tnsnames.ora file not present [message #477305 is a reply to message #477296]

Thu, 30 September 2010 01:00

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

Thanks for the reply Sir. I got my question cleared.When I checked the tnsnames.ora file of the ORACLE 11g Database the entry for the 10g database was there.

Regards
Deepak

Report message to a moderator

Re: tnsnames.ora file not present [message #477307 is a reply to message #477305]

Thu, 30 September 2010 01:06

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Maybe you executed netca (network assistant) during installation when it asked you if you want to.

Regards
Michel

Report message to a moderator

Re: tnsnames.ora file not present [message #477314 is a reply to message #477307]

Thu, 30 September 2010 02:12

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

No I did not but then also I will just find out reason for this or If you can help me better to understand that why it happened I will be thankful to you.

Regards
Deepak

Report message to a moderator

Re: tnsnames.ora file not present [message #477324 is a reply to message #477314]

Thu, 30 September 2010 03:43

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I don't know as it depends on what you did and I don't know what you did.
Anyway, how does this matter?

Regards
Michel

Report message to a moderator

Re: tnsnames.ora file not present [message #477401 is a reply to message #477324]

Thu, 30 September 2010 08:35

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>No I did not but then also I will just find out reason for this or If you can help me better to understand that why it happened I will be thankful to you.
Too bad you chose not to comply with Posting Guidelines http://www.orafaq.com/forum/t/88153/0/
& post Operating System name & version

post full directory listing including file creation time for ORACLE_HOME/network/admin

Report message to a moderator

Previous Topic:	Frequent Ora-12537 Errors
Next Topic:	Oracle 12457 erro

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 04 17:52:06 CST 2025