This is Just stuff I find on various echnologies ranging from databases to Cloud related tech. This Blog will have topics and content based on things i learn.
I can also be found at http://www.twitter.com/fuadar

Wednesday, March 02, 2011

Upgrade From Oracle 10.2.0.4 to Oracle 11.2.0.2

Below is a simple GUI Method to upgrade your Database from 10.2.0.4 to 11.2.0.2
As part of the upgrade Process from 10.2.0.4 the First Step will be to check the Database for issues.
The Process will be to first install the 11.2.0.2 Software. And the run the @utlu112i.sql which is available in your new Software Home $NEW_ORACLE_HOME/rdbms/admin
Once you run this against your old system
You will see a result like this
-- Start Oracle Upgrade Tool --

Oracle Database 11.2 Pre-Upgrade Information Tool 02-23-2011 13:44:07Script Version: 11.2.0.2.0 Build: 001Database:--> name: DTESTDB--> version: 10.2.0.4.0--> compatible: 10.2.0.4--> blocksize: 8192--> platform: AIX-Based Systems (64-bit)--> timezone file: V4Tablespaces: [make adjustments in the current environment]--> SYSTEM tablespace is adequate for the upgrade..... minimum required size: 2635 MB--> SYSAUX tablespace is adequate for the upgrade..... minimum required size: 440 MB--> TEMP tablespace is adequate for the upgrade..... minimum required size: 61 MB--> UNDO_01 tablespace is adequate for the upgrade..... minimum required size: 32 MB.**********************************************************************Update Parameters: [Update Oracle Database 11.2 init.ora or spfile]Note: Pre-upgrade tool was run on a lower version 64-bit database.**********************************************************************--> If Target Oracle is 32-Bit, refer here for Update Parameters:-- No update parameter changes are required..--> If Target Oracle is 64-Bit, refer here for Update Parameters:-- No update parameter changes are required..**********************************************************************Renamed Parameters: [Update Oracle Database 11.2 init.ora or spfile]**********************************************************************-- No renamed parameters found. No changes are required..**********************************************************************Obsolete/Deprecated Parameters: [Update Oracle Database 11.2 init.ora or spfile]**********************************************************************Remove all Parameterw listed in here.**********************************************************************Components: [The following database components will be upgraded or installed]**********************************************************************Check If anything is Invalid .**********************************************************************Miscellaneous Warnings**********************************************************************WARNING: --> Database contains INVALID objects prior to upgrade..... The list of invalid SYS/SYSTEM objects was written to.... registry$sys_inv_objs..... The list of non-SYS/SYSTEM objects was written to.... registry$nonsys_inv_objs..... Use utluiobj.sql after the upgrade to identify any new invalid.... objects due to the upgrade..... USER PUBLIC has 7 INVALID objects.WARNING: --> Your recycle bin is turned on and currently contains no objects..... Because it is REQUIRED that the recycle bin be empty prior to upgrading.... and your recycle bin is turned on, you may need to execute the command:PURGE DBA_RECYCLEBIN.... prior to executing your upgrade to confirm the recycle bin is empty..**********************************************************************Recommendations**********************************************************************Oracle recommends gathering dictionary statistics prior to upgrading the database.To gather dictionary statistics execute the following commandwhile connected as SYSDBA:EXECUTE dbms_stats.gather_dictionary_stats;**********************************************************************Oracle recommends removing all hidden parameters prior to upgrading.To view existing hidden parameters execute the following commandwhile connected AS SYSDBA:SELECT name,description from SYS.V$PARAMETER WHERE nameLIKE '\_%' ESCAPE '\'Changes will need to be made in the init.ora or spfile.**********************************************************************Oracle recommends reviewing any defined events prior to upgrading.To view existing non-default events execute the following commandswhile connected AS SYSDBA:Events:SELECT (translate(value,chr(13)||chr(10),' ')) FROM sys.v$parameter2WHERE UPPER(name) ='EVENT' AND isdefault='FALSE'Trace Events:SELECT (translate(value,chr(13)||chr(10),' ')) from sys.v$parameter2WHERE UPPER(name) = '_TRACE_EVENTS' AND isdefault='FALSE'--- End Oracle Upgrade Tool -----
After The Process is complete . Start ./dbua

As part of the Upgrade you have an option to Move the datafiles. In this we have chosen no
If you are fine with this Please Proceed . it is recommended that you upgrade your TimeZone File
Please Select Next and A warning will show up if you have decided not to turn off archiving
Select the new Values for you FRA & Diag Dest
Select Grid Control of DB Control Options
Add in the Passwords
It will provide with a summary
Oracle will now start the upgrade Process
This will complete and