Re: QUESTION: Stop 9i db from auto-registering in listener

BD wrote:
>
> Hey, all.
>
> I have a 9.2.0.6 db on AIX 5.2.
>
> I want to perform maintenance on one DB which is currently on the
> default 1521 listener.
>
> I set this db to "N" in the oratab, and bounce the default listener.
>
> The db automatically registers itself on 1521 within a minute or so.
>
> I want to stop this behavior, so I can control which dbs are accessible
> during the maintenance window.
>
> Is there a way I can gain control over the automatic listener
> registration process? some init file entry or something?
>
> Thanks!!
>
> BD.

The advice you've had is fine, but I would have thought to do maintenance, you'd only need to put the database in restricted mode.

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------