Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: TNS listener question

RE: TNS listener question

From: Mercadante, Thomas F (LABOR) <>
Date: Thu, 1 Nov 2007 08:03:18 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF017BF107@EXCNYSM0A1AJ.nysemail.nyenet>


First, make a copy of the listener.ora file for safe keeping.

Then go ahead and edit the file and do a reload.

The listener is *only* used to establish new connections. The existing connections never go back to the listener. So you can restart it at will unless you have a very busy application that is constantly bre4aking and reconnecting to the database.

I usually have two unix sessions open when I do this. One to edit the file and the other to run lsnrctl. That way, I can quickly re-edit the file if I need to.


-----Original Message-----

[] On Behalf Of Sweetser, Joe Sent: Wednesday, October 31, 2007 3:26 PM To:
Subject: TNS listener question

Oracle on RedHat AS 2.1

I just found out that one my listener.ora files does not have a SID_LIST_LISTENER entry for the main database on that server. I discovered this because I am setting up a duplicate database (from another server) and went to add the duplicate database to the listener.ora.

lsnrctl status seems OK to me:

Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "" has 1 instance(s).   Instance "dctmp", status UNKNOWN, has 1 handler(s) for this service... Service "" has 1 instance(s).   Instance "tiros", status READY, has 1 handler(s) for this service... The command completed successfully

dctmp is an old database that's been decommissioned (but, ironically, does have an entry in listener.ora). tiros is the current, running database on the server.

My guess is that tiros auto-registered with the listener (it's been up since July 9) but I am wondering if I will cause any grief if I:

  1. Edit listener.ora to "reflect reality" - remove dctmp, add tiros database and my new duplicate one 2. Do a lsnrctl reload

It's a production box so I need to be careful.

Thanks for any insight/advice/etc.


Confidentiality Note: This message contains information that may be confidential and/or privileged. If you are not the intended recipient, you should not use, copy, disclose, distribute or take any action based on this message. If you have received this message in error, please advise the sender immediately by reply email and delete this message. Although ICAT Managers, LLC scans e-mail and attachments for viruses, it does not guarantee that either are virus-free and accepts no liability for any damage sustained as a result of viruses. Thank you.


-- Received on Thu Nov 01 2007 - 07:03:18 CDT

Original text of this message