Re: Oracle Security Alert for CVE-2012-1675 - 10g extended support

From: Frits Hoogland <frits.hoogland_at_gmail.com>
Date: Sat, 5 May 2012 10:39:19 +0200
Message-ID: <-4328741704790634027_at_unknownmsgid>



For dynamically registered databases, it takes a little while before pmon registers itself to the listener. You can make pmon do it with the 'alter database register' command. By default pmon does so for listeners at port 1521 on the local machine's network interfaces. If you want to register automatically to other local listeners, use the local_listeners parameter, or remote (SCAN!) use remote_listeners. Frits Hoogland

http://fritshoogland.wordpress.com
mailto:frits.hoogland_at_gmail.com
cell: +31 6 53569942

Op 5 mei 2012 om 10:30 heeft Martijn Bos <maboc_at_maboc.nl> het volgende geschreven:

> Hi,
>
>>
>> In your (and everyone else's experience), how long does a listener
>> start/stop take? If it's in a shell script it might be very quick, and
>> done over a quiet period shouldn't hurt too much.
>>
>
> In my experience stopping/starting a listener doesn't take more then a few seconds.
> However, it can take a while (have no figures available) before the "locallistener databases" will register them selfs with the listener.
>
> The other day it took about 30 seconds for the last local listener to register, in out test environment.
>
> The existing connections are not impacted, only new connections can't be made. So I gues that applications which user some kind of connection-pooling mechanism are not hurt, since they do not (generally) need to create new connections all the time. Applications whitout connection pools may suffer from "database loss" or "no database" for a while. I guess it's up to "the bussiness" to see whether that is acceptable.
>
> Best Regards,
> Martijn
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Sat May 05 2012 - 03:39:19 CDT

Original text of this message