OraFAQ Forum: Networking and Gateways » listener.ora , tnsnames.ora

Home » RDBMS Server » Networking and Gateways » listener.ora , tnsnames.ora (oracle 10.2.0 win7)

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

listener.ora , tnsnames.ora [message #527528]

Tue, 18 October 2011 10:15

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.

Report message to a moderator

Re: listener.ora , tnsnames.ora [message #527530 is a reply to message #527528]

Tue, 18 October 2011 10:20

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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/

Report message to a moderator