Home » Server Options » Data Guard » About tnsnames.ora and listener
About tnsnames.ora and listener [message #265813] Fri, 07 September 2007 08:13 Go to next message
Messages: 26
Registered: June 2007
Junior Member
Hi All,

When the Oracle is up and running and I make some change in tnsnames.ora, is it necessary to restart the listener for it to pick up the updated tnsnames.ora?

I initially thought that the listener shoudl be restarted to pick up the new changes.
But yesterday I did a change in tnsnames.ora and the change was effective without restarting the listener.

Please let me know.

Thanks and regards,
Kaustubh Kane.
Re: About tnsnames.ora and listener [message #265840 is a reply to message #265813] Fri, 07 September 2007 10:06 Go to previous message
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member

Test case

i edit mine tnsnames.ora

    (SDU = 8192)
    (TDU = 8192)
      (SID = mydb)

DIDN'T restart mine Listener.


SQL*Plus: Release - Production on Fri Sep 7 15:05:06 2007

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP and Data Mining options


[Updated on: Fri, 07 September 2007 10:07]

Report message to a moderator

Previous Topic: Recover Database failure
Next Topic: lsp process is not starting
Goto Forum:

Current Time: Tue Oct 25 17:52:09 CDT 2016

Total time taken to generate the page: 0.13805 seconds