Please see DOC ID 735276.1 more information.
Brief Overview
--------------
Current environment - Redhat Linux ES 4 and R12 Base release 12.0.0
I have upgraded the 12.0.0 release to 12.0.4, use Patch 6435000.It took 4 hours.
Following patches are must
1.6928236
2.6400501
3.12.0.4 Consolidated Patch 1 7207440
4.Time Zone patch 5632264.
5.Oracle Applications DBA Release Update Pack 4 (R12.AD.A.DELTA.4) patch
6.6435000
7.7486407
8.7684818
Steps
-----
1.Apply Patches
Apply the patches in the following order
Oracle Applications DBA Release Update Pack 4 (R12.AD.A.DELTA.4) patch
6435000
6928236
6400501
12.0.4 Consolidated Patch 1 7207440
7486407
7684818
2.I am not changing the Port or any db specific configuration.
3.Install 11.1.0.6 on separate home
4.Upgrade 11.1.0.6 to 11.1.0.7. Download patch 6890831
5.Install Oracle Database 11g product 11.1.0.6 on to new Oracle home
6.upgrade 11g product 11.1.0.6 to 11.1.0.7 using the same patch 6890831
7.create nls/data/9idata directory to map to 11G home
8.Shutdown Apps Tiers,Listeners and DB
9.Take a Cold backup of the current database (10.2.0.2)
10.Have enough free space for the SYSAUX (600MB) and SYSTEM (600MB)Tablespaces
11.APPLSYS.FND_STATTAB table has to be upgraded after the database upgrade
12.create pfile from OLD OH/dbs and copy this to the new OH/dbs folder
13.update the following init.ora parameters
_disable_fast_validate=TRUE
event="31151 trace name context forever, level 0x100"
set diagnostic_dest to Oracle_base and comment all back ground destinations like
udump,bdump etc
compatible=’11.1.0′
14.Set the Environment variables like ORACLE_HOME,LD_LIBRARY_PATH,PATH,ORACLE_SID etc...
15. startup the database from Old Oracle home and run the following script from new Oracle_home/rdbms/admin directory
SQL> @utlu111i.sql
Oracle Database 11.1 Pre-Upgrade Information Tool 10-04-2009 21:17:34
.
**********************************************************************
Database:
**********************************************************************
--> name: RAC
--> version: 10.2.0.2.0
--> compatible: 10.2.0
--> blocksize: 8192
--> platform: Linux IA (32-bit)
--> timezone file: V3
.
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
--> SYSTEM tablespace is adequate for the upgrade.
.... minimum required size: 9815 MB
--> CTXD tablespace is adequate for the upgrade.
.... minimum required size: 15 MB
--> ODM tablespace is adequate for the upgrade.
.... minimum required size: 10 MB
--> APPS_UNDOTS1 tablespace is adequate for the upgrade.
.... minimum required size: 1057 MB
--> APPS_TS_TX_DATA tablespace is adequate for the upgrade.
.... minimum required size: 3889 MB
--> APPS_TS_QUEUES tablespace is adequate for the upgrade.
.... minimum required size: 86 MB
--> OLAP tablespace is adequate for the upgrade.
.... minimum required size: 16 MB
--> SYSAUX tablespace is adequate for the upgrade.
.... minimum required size: 334 MB
.
**********************************************************************
Update Parameters: [Update Oracle Database 11.1 init.ora or spfile]
**********************************************************************
-- No update parameter changes are required.
.
**********************************************************************
Renamed Parameters: [Update Oracle Database 11.1 init.ora or spfile]
**********************************************************************
-- No renamed parameters found. No changes are required.
.
**********************************************************************
Obsolete/Deprecated Parameters: [Update Oracle Database 11.1 init.ora or spfile]
**********************************************************************
--> "background_dump_dest" replaced by "diagnostic_dest"
--> "user_dump_dest" replaced by "diagnostic_dest"
--> "core_dump_dest" replaced by "diagnostic_dest"
.
**********************************************************************
Components: [The following database components will be upgraded or installed]
**********************************************************************
--> Oracle Catalog Views [upgrade] VALID
--> Oracle Packages and Types [upgrade] VALID
--> JServer JAVA Virtual Machine [upgrade] VALID
--> Oracle XDK for Java [upgrade] VALID
--> Real Application Clusters [upgrade] INVALID
--> OLAP Analytic Workspace [upgrade] VALID
--> OLAP Catalog [upgrade] VALID
--> Oracle Text [upgrade] VALID
--> Oracle XML Database [upgrade] VALID
--> Oracle Java Packages [upgrade] VALID
--> Oracle interMedia [upgrade] VALID
--> Spatial [upgrade] VALID
--> Data Mining [upgrade] VALID
--> Oracle OLAP API [upgrade] VALID
.
**********************************************************************
Miscellaneous Warnings
**********************************************************************
WARNING: --> Database is using an old timezone file version.
.... Patch the 10.2.0.2.0 database to timezone file version 4
.... BEFORE upgrading the database. Re-run utlu111i.sql after
.... patching the database to record the new timezone file version.
WARNING: --> Database contains stale optimizer statistics.
.... Refer to the 11g Upgrade Guide for instructions to update
.... statistics prior to upgrading the database.
.... Component Schemas with stale statistics:
.... SYS
.... OLAPSYS
.... CTXSYS
.... XDB
.... ORDSYS
.... MDSYS
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 APPS has 1 INVALID objects.
WARNING: --> Database contains schemas with objects dependent on network
packages.
.... Refer to the 11g Upgrade Guide for instructions to configure Network ACLs.
.... USER APPS has dependent objects.
.
PL/SQL procedure successfully completed.
You can see the warning message related to Network ACLs. This is related to XML DB and Fine grain Access control to external Network services. Please refer to the Oracle upgrade document for more information.
16. SQL> select * from v$timezone_file;
FILENAME VERSION
------------ ----------
timezlrg.dat 4
This value will be 3 if Patch 5632264 (for 10.2.0.2) not applied.
17.Fine tune your 10.2.0.2 database before this upgrade like log buffer,buffer cache,shared pool, java pool, logfile size with enough groups.
You can disable the archive mode for more optimal performance.
18.Shutdown the database (from Old Oracle home)
19.startup the database in upgrade mode from new Oracle 11G home
20.upgrade the database using the script utlu111s.sql
SQL> startup pfile=init11g.ora upgrade
ORACLE instance started.
Total System Global Area 8142679040 bytes
Fixed Size 1314580 bytes
Variable Size 1452985068 bytes
Database Buffers 5660944384 bytes
Redo Buffers 27435008 bytes
Database mounted.
Database opened.
SQL> spool 11g_upgrade.log
SQL> !ls -ltr $ORACLE_HOME/rdbms/admin/catupgrd.sql
-rw-r--r-- 1 oracle oinstall 4026 Apr 2 2007 /u02/app/oracle/product/11g//rdbms/admin/catupgrd.sql
SQL> @$ORACLE_HOME/rdbms/admin/catupgrd.sql
DOC>#######################################################################
DOC>#######################################################################
DOC>
DOC> The first time this script is run, there should be no error messages
DOC> generated; all normal upgrade error messages are suppressed.
DOC>
DOC> If this script is being re-run after correcting some problem, then
DOC> expect the following error which is not automatically suppressed:
DOC>
DOC> ORA-00001: unique constraint (
DOC> possibly in conjunction with
DOC> ORA-06512: at "
DOC>
DOC> These errors will automatically be suppressed by the Database Upgrade
DOC> Assistant (DBUA) when it re-runs an upgrade.
This upgrade took approx 1 hr
But after the upgrade, there were 150K invalid objects, which took approx 4 hours to compile.
Will post soon.
