Running utlu111i.sql will present the report about warnings in potential upgrade issues such as dataabse version and compatibility, and so on. Point 3: With running utlu111i.sql, making necessary change on parameter file is required. By running script utlu111i.sql, the new time zone file (version 4) will be recorded in view registry$database. Failing doing that will cause break out of upgrade while we do upgrade with running catupgrd.sql. For instance, the time zone files required in Oracle 11g has been updated to version 4. Actually, it solves problems which could break the process of upgrade.
Script utlu111i.sql does more than gathering information from database and analyzing database.
Point 2: Running utlu111i.sql would be helpful to solve possible pre-requisite problem of upgrade. If anything wrong happens during upgrade, we get the most straightforward way to restore source database. The reason to do that is to minimize downtime as much as possible. Since 11g upgrade requires downtime of oracle database, I strongly suggest to take cold backup beforehand. Point 1: Either take a Cold or Hot backup of source 10g database (advisable to have cold backup). Here, I would like to highlight couple points I experienced during my 11g upgrade.
Utlrp.sql This script recompiles and revalidates any remaining applicationīy following Oracle Metalink document “Complete Checklist for Manual Upgrades to 11gR1 ", the upgrade process would be smooth. Utlu111s.sql This is the Upgrade Status Utility script which lets youĬheck the status of the upgradeâ€â€that is, whether the upgraded database’sĬatuppst.sql This is the script you run to perform post-upgrade actions. Requirements for upgrading to Oracle Database 11g.Ĭatupgrd.sql This is the script that performs the actual upgrading of theĭatabase to the Oracle Database 11g release and it now supports parallel Size estimates, and generates warnings if your database doesn’t satisfy the Will issue warnings about potential upgrade issues such as database versionĪnd compatibility, redo log size, initialization parameters, and tablespace Meets all the upgrade requirements, such as whether the database alreadyĬontains the SYSAUX tablespace or not. Gathers information from the database and analyzes it to make sure that it Utlu111i.sql This script, also known as the Pre-Upgrade Information Tool, In this example, I’m upgrading from an Oracle Database 10g releaseĭatabase to Oracle Database 11g and would need to use the following scripts in turn to perform the manual upgrade.įollowing is a summary of the functions performed by each of the upgrade scripts: Scripts you must use, depending on the release number of the database you’re To upgrade oracle database manually from 10g to 11g, we need to use Oracle-supplied pre- and post-upgrade scripts.