Re: Listener problem on 10g - db registration on non-default listeners??

On 2 Mar 2006 16:28:50 -0800, "BD" <bobby_dread_at_hotmail.com> 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