Database upgrade from 9i to 10g manually

 · IMPORTANT NOTE: Bring up the listener from 10g_ORACLE_HOME and DATABASE from 9i_ORACLE_HOME and LISTENER of 9i_ORACLE_HOMEshould be DOWN. 1. Run the Pre-Upgrade Information Tool After you have installed the Oracle Database software and any required patches, you should analyze your database before upgrading to Estimated Reading Time: 5 mins. Steps for Upgrading the Database to 10g Release 2 Preparing to Upgrade Fresh Install oracle software only 10gR2 on the same 11i instance. Oracle 9i() to Oracle 10g().  · Once the above step is executed, follow the below steps to complete the upgrade. Step 2) Make the recomended changes and bounce the database. Run the script again. and check if any recomendations. Step 3) Make the following changes. Copy the www.doorway.ru file from old 9i ORACLE_HOME/dbs to new 10g ORACLE_HOME/www.doorway.ruted Reading Time: 1 min.

However, if you are currently on Oracle 9i then you will have to tackle both the upgrade to a new release and the migration from the Rule-Based Optimizer (RBO) to the Cost-based Optimizer (CBO). The RBO was de-supported in Oracle Database 10g, so in Oracle Database 11g you must use the CBO. Oracle upgrade 10g to 11g version Blog explain the manually upgrade process of Oracle database from version 10G to 11G Steps of Up-gradation of Oracle database from 10g to 11g manually Process divided into three section: Preupgrade: Steps performed before upgrade of database. How would you upgrade a 9i database to 10g? One way (the manual option) is use the datafiles and run the upgrade script (plus the other steps spelled out in the upgrade checklist on MOS). That is essentially your duplicate when done.

1 Okt ora/spfile. Create dictionary statistics the night before the upgrade. 9i SQL> exec DBMS_www.doorway.ru_SCHEMA_STATS;; 10g/11g SQL> exec. Hi All, We are planning to upgrade our old IBM h/w to new IBM Box on which SAP running, Oracle 9i to 10g upgrade and database reorg. 9 Mar During the upgrade to Oracle Database 11g Release 2 () from Oracle Database 9i Release 2 () or Oracle Database 10g Release 1 ().