Validating databases after migration oracle 8i 10g
Copy the Pre-Upgrade Information Tool (utlu112i.sql) and utltzuv2from the Oracle Database 11g Release 2 (11.2) ORACLE_HOME/rdbms/admin directory to a directory outside of the Oracle home, such as the temporary directory on your system.$ORACLE_HOME/rdbms/admin/utlu112Should be change to the directory where utlu112had been copied in the previous step.
When upgrading to Oracle Database 11g Release 2 (11.2), optimizer statistics are collected for dictionary tables that lack statistics.
This statistics collection can be time consuming for databases with a large number of dictionary tables, but statistics gathering only occurs for those tables that lack statistics or are significantly changed during the upgrade If your operating system is UNIX then complete this step, else skip to next Step. Make sure the following environment variables point to the Oracle database software 11g Release directories: - ORACLE_BASE - ORACLE_HOME - PATH Note : After /etc/oratab is updated to have sid and Oracle Home (11.2), you can execute oraenv (/usr/local/bin/oraenv) and set the environment.
The input has to be the sid which is entered in /etc/oratab against 11g home.
A blog about Database Administration, Exadata, DBA tutorials, Database troubleshooting and new Development in Database area.
The views expressed are my own and not necessarily those of Oracle and its affiliates.