OraFAQ Forum: Data Guard » About tnsnames.ora and listener

Home » Server Options » Data Guard » About tnsnames.ora and listener

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

About tnsnames.ora and listener [message #265813]

Fri, 07 September 2007 08:13

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.

Report message to a moderator

Re: About tnsnames.ora and listener [message #265840 is a reply to message #265813]

Fri, 07 September 2007 10:06

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 22:07:31 CST 2024