The Oracle pre-upgrade utility performs a simple verification of
the major database components prior to running a database and
dictionary upgrade.
You can see the Oracle pre-install utility in your rdbms/admin
directory:
$ORACLE_HOME/rdbms/admin/utlu112i.sql
You can run the Oracle pre-upgrade utility from SQL*Plus:
SQL > connect sys/xxx as
sysdba
Connected.
SQL> spool preupgradeutility.txt
SQL >
@$ORACLE_HOME/rdbms/admin/utlu112i.sql
SQL > spool off
The Oracle pre-upgrade utility is great for beginners because if
verifies some important pre-existing conditions for an Oracle
upgrade:
- Inspects your initialization parameter for the
pre-install checklist, detecting hidden and deprecated
parameters that will not work in the upgraded release. The
pre-upgrade utility also detects too-small values for important
pool parameters (e.g. java_pool_size)
- Verifies the existence and sizing for your system,
sysaux and temp tablespaces.
- Verifies that you have created valid optimizer
statistics (using dbms_stats), detecting “stale”
statistics. BEWARE: If you have no problems with SQL execution
plans, you may not want to re-analyze your statistics.
The Oracle pre-install utility is not a full replacement for the
pre-upgrade manual and checklist, because it does not detect missing
parameters and new settings, but the Oracle pre-upgrade utility does
provide a minimal check.
MOSC note 884522.1
describes the details for using Oracle Pre-upgrade Utility.
An Oracle upgrade is still tricky and should not be attempted by
an inexperienced DBA. For a reliable and certified Oracle upgrade,
BC can provide
remote and on-site Oracle upgrades in just a few hours.
|
|
 |
|
Guarantee your Success!
Oracle is the
world's most complex, robust and flexible database, considered
impossible to master without a mentor.
That's why all BC
Oracle trainers are working professionals, experts in Oracle who
share their tips and secrets. |
|
| |
|
Burleson is the American Team
Note:
This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.
Verify
experience!
Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.
Errata?
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just
e-mail:
 and include the URL for the page.
Copyright ? 1996 - 2012
All rights reserved.
Oracle ?
is the registered trademark of Oracle Corporation.
|
|
