Home » RDBMS Server » Networking and Gateways » listener.ora , tnsnames.ora (oracle 10.2.0 win7)
listener.ora , tnsnames.ora [message #527528] Tue, 18 October 2011 10:15 Go to next message
shvn23
Messages: 5
Registered: October 2011
Location: Lucknow
Junior Member
listener.ora and tnsnames.ora files are missing , only sqlnet.ora file is present at the location
oraclehome\network\admin .
database is causing no problem . i am able to start the listener service , open em , even tnsping is giving right output .
but i cant understand how can the service work without these files . i searched full computer for "tnsnames.ora" and "listener.ora" but no reslts except the sample files.
Re: listener.ora , tnsnames.ora [message #527530 is a reply to message #527528] Tue, 18 October 2011 10:20 Go to previous messageGo to next message
BlackSwan
Messages: 22506
Registered: January 2009
Senior Member
tnsnames.ora file is only required on a client & is not needed on DB Server.
Since V10 Oracle no listener.ora file is required to start the listener.
All is as it should be.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: listener.ora , tnsnames.ora [message #527531 is a reply to message #527528] Tue, 18 October 2011 10:24 Go to previous messageGo to next message
Michel Cadot
Messages: 58574
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Net Services Administrator's Guide

Read at least the introduction part.

Regards
Michel

Re: listener.ora , tnsnames.ora [message #527532 is a reply to message #527531] Tue, 18 October 2011 10:38 Go to previous message
shvn23
Messages: 5
Registered: October 2011
Location: Lucknow
Junior Member
thank you for answers . and i have read guidelines now . nice guidelines .
Previous Topic: ORA-12504: TNS listener was not given the SERVICE_NAME in CONNECT_DATA (3 Merged)
Next Topic: Firing query to multiple database
Goto Forum:
  


Current Time: Sat Jul 26 00:08:38 CDT 2014

Total time taken to generate the page: 0.09043 seconds