![upgrade oracle 10g to 11g upgrade oracle 10g to 11g](https://oracle-base.com/articles/12c/images/upgrades/01-select-operation.jpg)
- #UPGRADE ORACLE 10G TO 11G HOW TO#
- #UPGRADE ORACLE 10G TO 11G MANUAL#
- #UPGRADE ORACLE 10G TO 11G UPGRADE#
#UPGRADE ORACLE 10G TO 11G UPGRADE#
And Step 4, as this embodiment is an upgrade from 10.2.0.4 to 11g, and this step is not required. (5) generated reconstruction dblink script, just in case you need to downgrade the database. SQL> Starting from 10.2, the CONNECT role of authority fewer, so if you are upgrading from a previous 10.2 to 11g, then after the upgrade, need to grant permission to the missing, but if it is fromġ0.2 to 11g and upgraded after then, there is no need to re-assign the authority, the present embodiment is from 10.2.0.4 to upgrade, it is not necessary that the step 11g. If the script report invalid objects, run the following command to recompile invalid objects: Sql> alter session set nls_language='American' To Collect DB Upgrade / Migrate Diagnostic Information (dbupgdiag.sql) (3) can be downloaded from the following documentation to this script dbupgdiag.sql: Upgrade_info.log generated content is important in the subsequent steps to make the appropriate changes based on the contents of the document, and therefore must be retained. (1) 11gR2 of the Oracle Home from the copy of the following file to a temporary folder:
#UPGRADE ORACLE 10G TO 11G HOW TO#
How to Clean Up Duplicate Objects Owned by SYS and SYSTEM Schema If there are other records are returned, you must delete the duplicate records in accordance with this document the following: Select object_name, object_type from dba_objects where object_name || object_type in (select object_name || object_type fromĭba_objects where wner = 'SYS') and wner = 'SYSTEM' Ībove this statement can only return the following four records: sys and system ensuring that no duplicate objects: If there is invalid objects, run utlrp.sql re-compiled object.Ģ. Order by owner, object_type - for the object Select substr (object_name, 1,40) object_name, substr (owner, 1,15) owner, object_type from dba_objects where status = 'INVALID' Select substr (comp_name, 1,40) comp_name, status, substr (version, 1,10) version from dba_registry order by comp_name - for Before you upgrade, make sure that all components and objects are valid:
![upgrade oracle 10g to 11g upgrade oracle 10g to 11g](https://www.mandsconsulting.com/wp-content/uploads/ExtApp.png)
It should be noted that: If you want to apply the latest PSU or CPU on 11gr2, PSU or CPU can first be marked at the software level, so do not run twice catbundle.sql, reduce down timeġ.
![upgrade oracle 10g to 11g upgrade oracle 10g to 11g](https://i0.wp.com/ittutorial.org/wp-content/uploads/2019/05/Oracle-Upgrade.jpg)
Here installing the software not described in detail, refer to the appropriate documentation. The first portion - mounted 11gR2 Software
#UPGRADE ORACLE 10G TO 11G MANUAL#
Reference documents: Complete Checklist for Manual Upgrades to 11gR2 The new version of the database: 11.2.0.2 Oracle 10g to 11g upgrade from older versions of the database detailed steps: 10.2.0.4