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
kaustubh
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
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
No.

Test case

i edit mine tnsnames.ora

#
MY_SERVICE =
  (DESCRIPTION =
    (SDU = 8192)
    (TDU = 8192)
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = XXXXX)(PORT = 5521))
    )
    (CONNECT_DATA =
      (SID = mydb)
    )
  )


DIDN'T restart mine Listener.

$ sqlplus USER/PASSWORD@MY_SERVICE

SQL*Plus: Release 10.2.0.3.0 - 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 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL>

[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: Fri Mar 29 07:18:05 CDT 2024