![]() Any errors that occur during the upgrade are listed with each component and must be addressed It displays the status of the database components in the upgraded database and the time required to complete each component upgrade. Start the database and run the Post-Upgrade Status Tool $ORACLE_HOME/rdbms/admin/utlu112s.sql which provides a summary of the upgrade at the end of the spool log. Set the system to spool results to a log file for later verification after the upgrade is completed and start the upgrade script. Upgrade Database:At the operating system prompt, change to the $ORACLE_HOME/rdbms/admin directory of 11gR2 Oracle Home. ![]() The input has to be the sid which is entered in /etc/oratab against 11g home.ġ0. 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. Update the oratab entry, to set the new ORACLE_HOME pointing towards ORCL and disable automatic startup Note : If ORACLE_BASE is not known, after setting Path towards 11g Oracle Home, execute 'orabase', which will point the location of base.ī. Make sure the following environment variables point to the Oracle database software 11g Release directories: ![]() ![]() If your operating system is UNIX then complete this step, else skip to next Step.Ī. Note: Once the Parameter file is modified as per your requirement, copy the file to $ORACLE_HOME/dbs (11g Oracle Home ) * The DIAGNOSTIC_DEST initialization parameter replaces the USER_DUMP_DEST, BACKGROUND_DUMP_DEST. Make a backup of the init.ora file.Comment out obsolete parameters Ensure that no files need media recovery:Ĩ. SQL> EXEC DBMS_STATS.GATHER_DICTIONARY_STATS Ĥ. 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 When upgrading to Oracle Database 11g Release 2 (11.2), optimizer statistics are collected for dictionary tables that lack statistics. ![]() If this is UTF8 or AL16UTF16 then no action is needed.ģ. Select value from NLS_DATABASE_PARAMETERS where parameter = 'NLS_NCHAR_CHARACTERSET' SQL> that National Characterset (NLS_NCHAR_CHARACTERSET) is UTF8 and AL16UTF16. Please note that the database should be started using the Source Oracle Home.Ģ.run $ORACLE_HOME/rdbms/admin/utlrp.sql (multiple times) to validate the invalid objects in the database, until there is no change in the number of invalid objects. 1.$ORACLE_HOME/rdbms/admin/utlu112i.sql - copy this from oracle 11g to /tmp and run it ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |