Home » RDBMS Server » Networking and Gateways » tnsnames.ora file not present (Oracle Version 10.2.0.1.0)
icon7.gif  tnsnames.ora file not present [message #477094] Tue, 28 September 2010 08:41 Go to next message
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
Re: tnsnames.ora file not present [message #477095 is a reply to message #477094] Tue, 28 September 2010 08:45 Go to previous messageGo to next message
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/

Re: tnsnames.ora file not present [message #477291 is a reply to message #477095] Thu, 30 September 2010 00:09 Go to previous messageGo to next message
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
Re: tnsnames.ora file not present [message #477296 is a reply to message #477291] Thu, 30 September 2010 00:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68165
Registered: March 2007
Location: Nanterre, France, http://...
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
icon14.gif  Re: tnsnames.ora file not present [message #477305 is a reply to message #477296] Thu, 30 September 2010 01:00 Go to previous messageGo to next message
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
Re: tnsnames.ora file not present [message #477307 is a reply to message #477305] Thu, 30 September 2010 01:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68165
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe you executed netca (network assistant) during installation when it asked you if you want to.

Regards
Michel
Re: tnsnames.ora file not present [message #477314 is a reply to message #477307] Thu, 30 September 2010 02:12 Go to previous messageGo to next message
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
Re: tnsnames.ora file not present [message #477324 is a reply to message #477314] Thu, 30 September 2010 03:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68165
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: tnsnames.ora file not present [message #477401 is a reply to message #477324] Thu, 30 September 2010 08:35 Go to previous message
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
Previous Topic: Frequent Ora-12537 Errors
Next Topic: Oracle 12457 erro
Goto Forum:
  


Current Time: Mon May 16 21:00:12 CDT 2022