![oracle 10g to 11g upgrade oracle 10g to 11g upgrade](https://docs.oracle.com/cd/E24628_01/upgrade.121/e22625/img/two_sys_upg.gif)
This creates a script called analyze.sql. SELECT 'Analyze table "'||table_name||'" validate structure cascade into invalid_rows ' SELECT 'Analyze table "'||table_name||'" validate structure cascade ' SELECT 'Analyze cluster "'||cluster_name||'" validate structure cascade ' Step 8: Check for corruption in the dictionary, use the following commands: Note 453903.1 - Enabling and Disabling Oracle Database Vault in UNIX Select * from v$option where PARAMETER='Oracle Database Vault' Note 276914.1 The National Character Set in Oracle 9i and 10g. If is not UTF8 or AL16UTF16 then refer the following article. If this is UTF8 or AL16UTF16 then no action is needed. Select value from NLS_DATABASE_PARAMETERS where parameter = 'NLS_NCHAR_CHARACTERSET' Step 5: Check that National Character set (NLS_NCHAR_CHARACTERSET) is UTF8 and AL16UTF16. $ORACLE_HOME/oracore/zoneinfo/ with a timezone data file of the same version as the one used in the 11.1.0.6.0 release database.In such case, do NOT proceed with upgrade.
ORACLE 10G TO 11G UPGRADE PATCH
BEFORE upgrading the database, patch the 11gR2 output of the above query is more than 11) then utlu112i.sql (Pre-Upgrade Information Tool) will generate the following warning.Įxample: WARNING: –> Database is using a time zone file greater than version 11. outputs of the above query is less than 11 then proceed with the Step 6.Ĭase 2.If the source database is using a time zone file greater than version 11 (i.e.
![oracle 10g to 11g upgrade oracle 10g to 11g upgrade](https://blogs.sap.com/wp-content/uploads/2015/07/a8_756596.jpg)
If the source database is using a time zone file older than version 11 i.e. Select TZ_VERSION from registry$database Ĭase 1. Step 3: Create Script for DBLINK for backup purpose. Run the Pre-Upgrade Information Tool (utlu112i.sql) from the Oracle Database 11g location as $ORACLE_HOME/rdbms/admin directory and try to execute on 10g database database as the spool file and examine the output of the upgrade information and take necessary actions like deprecated parameters, size in system tablespace, remove hidden parameter and gather system stats etc.
![oracle 10g to 11g upgrade oracle 10g to 11g upgrade](https://m.media-amazon.com/images/I/41AI-8LzriL.jpg)
Step 2: Run the Pre-Upgrade Information Tool for Collecting Pre-Upgrade Information
ORACLE 10G TO 11G UPGRADE HOW TO
Note: 1030426.6 how to Clean up Duplicate objects Owned by SYS and SYSTEM Schema Select OBJECT_NAME, OBJECT_TYPE from DBA_OBJECTS where OBJECT_NAME||OBJECT_TYPE in (select OBJECT_NAME||OBJECT_TYPE from DBA_OBJECTS where OWNER='SYS') and OWNER='SYSTEM' and OBJECT_NAME not in ('AQ$_SCHEDULES_PRIMARY', 'AQ$_SCHEDULES','DBMS_REPCAT_AUTH') Step 1: Always check for DUPLICATE objects in SYS/SYSTEM Make sure /etc/oraInst.loc is pointing to the correct inventory.
ORACLE 10G TO 11G UPGRADE INSTALL
Install 11g software on the new mount point.ģ. Get ORACLE_HOME mount point /ora11g with 25GB space.Ģ. Pre-upgrade Steps that do not require downtime and must be finished much before downtime starts:ġ. Post upgrade: Steps performed after upgrade Upgrade: Steps for performing database upgrade Preupgrade: Steps performed before upgrade of database.
![oracle 10g to 11g upgrade oracle 10g to 11g upgrade](http://www.windows8facile.fr/wp-content/uploads/2017/10/oracle-logo.jpg)
Steps of Up-gradation of Oracle database from 10g to 11g manually Blog explain the manually upgrade process of Oracle database from version 10G to 11G