![]() ![]() Step 2: Run the Pre-Upgrade Information Tool for Collecting Pre-Upgrade Information 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. 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. 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 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |