Oracle Database 10.2 Upgrade Information Utility Output

Posted by Vasudev Seeram on August 30, 2007 Leave a comment (0) Go to comments

SQL> @ utlu102i.sql
Oracle Database 10.2 Upgrade Information Utility 08-30-2007 18:57:10
.
**********************************************************************
Database:
**********************************************************************
–> name: PROD
–> version: 9.2.0.8.0
–> compatible: 9.2.0
–> blocksize: 8192
.
**********************************************************************
Logfiles: [make adjustments in the current environment]
**********************************************************************
–> The existing log files are adequate. No changes are required.
.
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
–> SYSTEM tablespace is adequate for the upgrade.
…. minimum required size: 7139 MB
–> CTXD tablespace is adequate for the upgrade.
…. minimum required size: 17 MB
–> APPLSYSD tablespace is adequate for the upgrade.
…. minimum required size: 18597 MB
–> CCTD tablespace is adequate for the upgrade.
…. minimum required size: 7 MB
–> ARD tablespace is adequate for the upgrade.
…. minimum required size: 268 MB
–> OKCD tablespace is adequate for the upgrade.
…. minimum required size: 33 MB
–> AMVD tablespace is adequate for the upgrade.
…. minimum required size: 7 MB
–> XNPD tablespace is adequate for the upgrade.
…. minimum required size: 9 MB
–> XDPD tablespace is adequate for the upgrade.
…. minimum required size: 8 MB
–> IEOD tablespace is adequate for the upgrade.
…. minimum required size: 4 MB
–> IBUD tablespace is adequate for the upgrade.
…. minimum required size: 1 MB
–> IEMD tablespace is adequate for the upgrade.
…. minimum required size: 8 MB
–> JTFD tablespace is adequate for the upgrade.
…. minimum required size: 63 MB
–> ASOD tablespace is adequate for the upgrade.
…. minimum required size: 7 MB
–> TEMP tablespace is adequate for the upgrade.
…. minimum required size: 58 MB
–> APPS_UNDOTS1 tablespace is adequate for the upgrade.
…. minimum required size: 286 MB
.
**********************************************************************
Update Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
WARNING: –> “streams_pool_size” is not currently defined and needs a value of
at least 50331648
WARNING: –> “session_max_open_files” needs to be increased to at least 20
.
**********************************************************************
Renamed Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
— No renamed parameters found. No changes are required.
.
**********************************************************************
Obsolete/Deprecated Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
–> “optimizer_max_permutations”
–> “row_locking”
–> “undo_suppress_errors”
–> “log_archive_start”
–> “max_enabled_roles”
–> “enqueue_resources”
.
**********************************************************************
Components: [The following database components will be upgraded or installed]
**********************************************************************
–> Oracle Catalog Views [upgrade] VALID
–> Oracle Packages and Types [upgrade] VALID
–> JServer JAVA Virtual Machine [upgrade] VALID
…The ‘JServer JAVA Virtual Machine’ JAccelerator (NCOMP)
…is required to be installed from the 10g Companion CD.
–> Oracle XDK for Java [upgrade] VALID
–> Oracle Java Packages [upgrade] VALID
–> Oracle Text [upgrade] VALID
–> Oracle XML Database [install]
–> Real Application Clusters [upgrade] INVALID
–> Oracle interMedia [upgrade] VALID
…The ‘Oracle interMedia Image Accelerator’ is
…required to be installed from the 10g Companion CD.
–> Spatial [upgrade] VALID
.
**********************************************************************
Miscellaneous Warnings
**********************************************************************
WARNING: –> Passwords exist in some database links.
…. Passwords will be encrypted during the upgrade.
…. Downgrade of database links with passwords is not supported.
WARNING: –> Deprecated CONNECT role granted to some user/roles.
…. CONNECT role after upgrade has only CREATE SESSION privilege.
WARNING: –> Database contains stale optimizer statistics.
…. Refer to the 10g Upgrade Guide for instructions to update
…. statistics prior to upgrading the database.
…. Component Schemas with stale statistics:
…. SYS
…. CTXSYS
…. ORDSYS
…. MDSYS
WARNING: –> Database contains INVALID objects prior to upgrade.
…. USER APPS has 4 INVALID objects.
…. USER DISCOVERER has 1 INVALID objects.
…. USER PERFSTAT has 1 INVALID objects.
…. USER SPOTLIGHT has 2 INVALID objects.
…. USER SYS has 5 INVALID objects.
…. USER VTAS_I3_ORCL has 40 INVALID objects.
.
**********************************************************************
SYSAUX Tablespace:
[Create tablespace in the Oracle Database 10.2 environment]
**********************************************************************
–> New “SYSAUX” tablespace
…. minimum required size for database upgrade: 500 MB
.