RE: init.ora rolling restart
Date: Wed, 26 Aug 2015 13:07:52 -0500
Message-ID: <AD8FE6616C097545A4C9A8B0792909AC58E88AB043_at_DNBEXCH01.dnbint.net>
Thanks for checking into that Yong!
Now you've got me curious about your search(es) of the html doc. Did you somehow get the whole reference doc to be dumped into 1 file and perform various OS-level searches on it?
Regards,
Dave
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Yong Huang
Sent: Wednesday, August 26, 2015 9:56 AM
To: Herring, David
Cc: oracle-l_at_freelists.org
Subject: Re: init.ora rolling restart
> For a RAC install (11gR2 on RH Linux) are there any non-dynamic
> init.ora parameters that CANNOT be changed via a rolling restart? The
> only one I can think of off the top of my head is CLUSTER_DATABASE. I
> ask because we have a number of changes to make for primarys and
> standbys to become consistent and avoiding downtime would make the
> whole change order process a lot simplier and quicker.
David,
I've done some research on this because it's a big headache for us. Once we put a RAC database into production, we intend to keep it up until it's decommissioned in approximately 5 years. But these "stubborn" parameters, if we have to change their values, pose a challenge.
From `find' and `grep' documentation, I found 13 documented parameters to be static, instance-nonmodifiable in 11gR2:
ACTIVE_INSTANCE_COUNT
CLUSTER_DATABASE_INSTANCES
COMPATIBLE
CONTROL_FILES
DB_BLOCK_SIZE DB_DOMAIN DB_FILES DB_NAME DB_UNIQUE_NAME
INSTANCE_TYPE
PARALLEL_EXECUTION_MESSAGE_SIZE
REMOTE_LOGIN_PASSWORDFILE
UNDO_MANAGEMENT See
http://yong321.freeshell.org/oranotes/StaticInstanceNonmodifiableParameters.txt for a full description.
There's no dictionary view or fixed table that provides this information. An enhancement request has been opened.
Yong Huang
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 26 2015 - 20:07:52 CEST