Locally Modifiable Global Parameters for AutoUpgrade Configuration File
Required configuration parameters for AutoUpgrade can be set either globally for all upgrades, or locally.
Usage Notes
If you set required AutoUpgrade parameters globally, as a locally modifiable global parameter, then these parameters can be overridden by local parameters set for particular upgrades, so that you can better control AutoUpgrade job processing.
With locally modifiable global parameters, you can use the prefix
global
to set values for required parameters as global
parameters for all jobs in your AutoUpgrade configuration file, but identify the
same parameter with a local job prefix to reset the global value to a different
value for a particular job in the same configuration file. You can also choose to
set locally modifiable global parameters only as local parameters for each
AutoUpgrade job.
Note:
These parameters are available in the latest version of AutoUpgrade that you can download from My Oracle Support.When a locally modifiable global parameter is set both with a global prefix, and with a local job prefix, the locally modified parameter value overrides the global parameter values for the job identified by the prefix that you use with the parameter.
For example, with global.target_home
, the syntax you
use is in the form global.target_home=Global target
Oracle home
, and database.target_home=local target Oracle
home.
Example
In the AutoUpgrade configuration file, the required parameter
target_home
is set globally to one Oracle home path. But in the
configuration file, the same parameter is set locally to a different Oracle home
path. As AutoUpgrade processes the jobs in the configuration file, it uses the
locally defined path for target_home
for the job defined by the
prefix upgrade3
, overriding the global parameter setting:
global.target_home=/u01/app/oracle/21.0.0/dbhome01
upgrade3.target_home=/u03/app/oracle3/12.2.0.1/dbhome3
- defer_standby_log_shipping
Defers shipping logs from the primary database to any standby database. All log archive destionations (log_archive_dest_n
) are set to deferred. - dictionary_stats_after
(Optional) Specifies that AutoUpgrade gathers data dictionary statistics on the target database after the upgrade is complete. - dictionary_stats_before
(Optional) Specifies that AutoUpgrade gathers data dictionary statistics on the source database before starting the upgrade. - drop_grp_after_upgrade
Deletes the Guaranteed Restore Point (GRP) after database upgrade. - enable_local_undo
For a CDB upgrade, specifies whether or notLOCAL
undo should be enabled before the upgrade ofCDB$ROOT
. - fixed_stats_before
(Optional) Specifies that AutoUpgrade gathers fixed object statistics on the source database before starting the upgrade. - manage_network_files
Specifies whether network files are processed during the upgrade. - remove_underscore_parameters
Removes underscore (hidden) parameters fromPFILE
files during upgrade, and after upgrade, for all Oracle Databases in the configuration file. - restoration
(Available with Enterprise Edition only) Generates a Guaranteed Restore Point (GRP) for database restoration. - target_base
Specifies the targetORACLE_BASE
path for the target Oracle home. - target_home
(Required for upgrade and deploy modes, if the target home is not on the system. Optional for analyze and fixups mode. ) Specifies the target Oracle home (ORACLE_HOME
) path. - target_version
(Required if target Oracle home is not on the system, or is release 12.2) Specifies the target release version on which you want AutoUpgrade to perform the upgrade.
Parent topic: Preparing to Upgrade Oracle Database
defer_standby_log_shipping
log_archive_dest_n
) are set to
deferred.
Usage Notes
By default, log shipping occurs as part of the upgrade. When Autoupgrade defers log shipping, you receive a notice that log shipping is deferred, and that after the upgrade completes successfully, you need to reenable shipping logs from the primary database to the secondary database.
Note:
This configuration file parameter affects not only standby databases, but all products or services that receive redo from the primary database, such as Oracle Zero Data Loss Recovery Appliance (ZDLRA) real-time log transport, and Oracle GoldenGate downstream capture.Options
[yes | no]
The default value is no
The default is no (log-shipping is not deferred). If you change the
default to Yes
, then log shipping is deferred, and you must choose
to re-enable it manually after upgrade.
Example
defer_standby_log_shipping=yes
dictionary_stats_after
(Optional) Specifies that AutoUpgrade gathers data dictionary statistics on the target database after the upgrade is complete.
Usage Notes
Oracle recommends that you gather dictionary statistics both before and after upgrading the database, because Data Dictionary tables are modified and created during the upgrade. When you specify yes, AutoUpgrade gathers dictionary statistics after the upgrade is completed.
Options
[yes | no]
The default value is Yes
.
Example
global.dictionary_stats_after=yes
sales.dictionary_stats_after=yes
dictionary_stats_before
(Optional) Specifies that AutoUpgrade gathers data dictionary statistics on the source database before starting the upgrade.
Usage Notes
Oracle recommends that you gather dictionary statistics both before and after upgrading the database, because Data Dictionary tables are modified and created during the upgrade. When you specify yes, AutoUpgrade gathers dictionary statistics before beginning the upgrade.
Options
[yes | no]
The default value is Yes
.
Example
global.dictionary_stats_before=yes
sales.dictionary_stats_before=yes
drop_grp_after_upgrade
Deletes the Guaranteed Restore Point (GRP) after database upgrade.
Usage Notes
If you select this option, then GRP is deleted after upgrade completes successfully.
Options
[yes | no]
The default value is no
.
Example
global.drop_grp_after_upgrade=yes
sales.drop_grp_after_upgrade=yes
enable_local_undo
For a CDB upgrade, specifies whether or not LOCAL
undo
should be enabled before the upgrade of CDB$ROOT
.
Usage Notes
If you select this option, then AutoUpgrade runs the following statement
before upgrade: ALTER DATABASE LOCAL UNDO ON;
.
When local undo is first enabled, the size of the undo tablespace in
PDB$SEED
is determined as a factor of the size of the undo
tablespace in CDB$ROOT
. The default is 30 percent of the undo
tablespace size. Every other PDB in the CDB inherits this property from
PDB$SEED
. Ensure that there is enough space to allocate new
UNDO
tablespaces.
Options
[yes | no]
The default value is no
.
Example
enable_local_undo=yes
fixed_stats_before
(Optional) Specifies that AutoUpgrade gathers fixed object statistics on the source database before starting the upgrade.
Usage Notes
Before an upgrade, Oracle recommends that you regather fixed object statistics.
Fixed objects are the X$
tables and their indexes.
V$
performance views are defined through X$
tables. Gathering fixed object statistics is valuable for database performance,
because these statistics help the optimizer generate good execution plans, which can
improve database performance. Failing to obtain representative statistics can lead
to suboptimal execution plans, which can cause significant performance problems.
Options
[yes | no]
The default value is Yes
.
Example
global.fixed_stats_before=yes
sales.fixed_stats_before=yes
manage_network_files
Specifies whether network files are processed during the upgrade.
Usage Notes
If you select this option, then AutoUpgrade processes network files, depending on the option that you specify.
The following network files are processed: oranfstab
,
ldap.ora
, tnsnames.ora
,
sqlnet.ora
, and listener.ora
Options
[FULL|SKIP|IGNORE_READ_ONLY
]
FULL
: (default) Raise all exceptions encountered during the copy and merge of network files into the target Oracle home.SKIP
: Do not process network files during postupgrade.IGNORE_READ_ONLY
: Attempt to copy and merge network files, but do not raise an exception during the upgrade if the target file is read only
Example
manage_network_files=ignore_read_only
remove_underscore_parameters
Removes underscore (hidden) parameters from PFILE
files
during upgrade, and after upgrade, for all Oracle Databases in the configuration
file.
Usage Notes
Underscore parameters should only be used by advice of Oracle Support.
Options
[yes | no]
The default value is no
.
Example
global.remove_underscore_parameters=yes
restoration
(Available with Enterprise Edition only) Generates a Guaranteed Restore Point (GRP) for database restoration.
Usage Notes
This option determines whether database backup and database restoration must be performed manually by the DBA.
Standard Edition does not support Flashback Database, so this option is not available for Standard Edition. If your database is a Standard Edition Oracle Database, then you must ensure that you have a separate fallback mechanism is in place.
Options
[yes | no]
The default value is yes
.
Example
global.restoration=no
target_base
Specifies the target ORACLE_BASE
path for the target Oracle
home.
Example
global.target_base=/u01/app/oracle
sales4.target_base=/u04/app/oracle4
target_home
(Required for upgrade and deploy modes, if the target home is not on the
system. Optional for analyze and fixups mode. ) Specifies the target Oracle home
(ORACLE_HOME
) path.
Usage Notes
AutoUpgrade uses the release version information that you provide in this parameter to ensure that the correct checks and fixups are used for the target Oracle Database release to which you are upgrading. The format for this parameter are period-delimited values of valid Oracle versions.
This option is only required if the target home is not present on the system, or if the target home is a 12.2 release. Otherwise, AutoUpgrade can derive the target release value.
Options
Valid values
- 12.2
- 18
- 19
- 21
- 23
Example
global.target_version=23
employees.target_version=19
target_version
(Required if target Oracle home is not on the system, or is release 12.2) Specifies the target release version on which you want AutoUpgrade to perform the upgrade.
Usage Notes
AutoUpgrade uses the release version information that you provide in this parameter to ensure that the correct checks and fixups are used for the target Oracle Database release to which you are upgrading. The format for this parameter are period-delimited values of valid Oracle versions.
This option is only required if the target home is not present on the system, or if the target home is a 12.2 release. Otherwise, AutoUpgrade can derive the target release value.
Options
Valid values
- 12.2
- 18
- 19
- 21
- 23
Example
global.target_version=23
employees.target_version=19