Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newshub.sdsu.edu!news.astraweb.com!router2.astraweb.com!216.168.1.164.MISMATCH!sn-xt-sjc-04!sn-xt-sjc-10!sn-xt-sjc-06!sn-xt-sjc-01!sn-post-02!sn-post-ams-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.server Subject: Re: Listener problem on 10g - db registration on non-default listeners?? Date: Fri, 03 Mar 2006 07:04:54 +0100 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Reply-To: sybrandb@hccnet.verwijderdit.nl References: <1141339284.719171.239330@e56g2000cwe.googlegroups.com> <1141340980.069310.133830@u72g2000cwu.googlegroups.com> <1141343253.083408.22240@v46g2000cwv.googlegroups.com> <1141345406.450800.48480@i40g2000cwc.googlegroups.com> <1141345730.063479.278090@z34g2000cwc.googlegroups.com> X-Newsreader: Forte Agent 3.2/32.830 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 21 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:262660 On 2 Mar 2006 16:28:50 -0800, "BD" wrote: >>Is there a specific reason you need to have multiple listeners? > >Generally it's for ease of access control: If we want to do maintenance >on databases and need the users out, but the database up, we can shut >down the default listener so users cannot get in, and the DBAs can get >in through an alternative one which the users don't have in their TNS. >Similarly, our application servers use a third listener that's just for >them. > >Probably lots of ways to skin that particular cat, but this is how it's >done in this environment. > >BD Just enable restricted sessions by means of alter system and get rid of this utter crap. -- Sybrand Bakker, Senior Oracle DBA