- Download maintenance wizard Live patch # 7479670
- Set the following variables,
ORACLE_HOME=/u04/oracle/10.2.0; export ORACLE_HOME PATH=$ORACLE_HOME/bin:$PATH; export PATH TWO_TASK=MAINWIZ;export TWO_TASK TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN EOF_HOME=$ORACLE_HOME/eof; export EOF_HOME IAS_HOME=/u04/oracle/10.1.3; export IAS_HOME
- Change directory to $EOF_HOME and execute the environment file
. ./EOF.env
- Edit the $IAS_HOME/Apache/Apache/httpd.conf to change Timeout parameter to a value of 10800 (3 hours)
- Unzip the livepatch.zip file using the following command,
unzip -o $EOF_HOME/p7479670_R12_GENERIC.zip
- Stop iAS
$IAS_HOME/opmn/bin/opmnctl stopall
- Run the upload_livepatch.sh script using the following commands,
cd $EOF_HOME/livepatch ./upload_livepatch.sh
- Review the $EOF_HOME/livepatch/LivePatch.log for errors and warnings
- Start iAS
$IAS_HOME/opmn/bin/opmnctl startall
- Login to the tool using the following URL and the pre-assigned username and password that we assigned it
sysadmin/mainwiz (http://hostname.domain:ApachePort/EOF/ )
- Use LiveUpdate tab in wizard to see the newfeatures of the LivePatch - 2.13
Showing posts with label upgrade. Show all posts
Showing posts with label upgrade. Show all posts
Monday, July 13, 2009
Sunday, July 12, 2009
Upgrading from 10.2.0.1 to 10.2.0.3
- Install the 10.2.0.3 (5337014 ) patch set on the top of the installed oracle home in $ORACLE_HOME
- Apply patch 5257698 (Opatch)
- Shutdown the database
- Set the following environment variables - ORACLE_HOME (New) - ORACLE_SID
- cd $ORACLE_HOME/rdbms/admin sqlplus ' /as sysdba' startup upgrade
- SQL> spool upgrade.log SQL> @catupgrd.sql
(Note # "execute dbms_registry.gather_stats(null)" will take time to run, just leave it, which is called from $ORACLE_HOME/rdbms/admin/cmpdbmig.sql)
- Run $ORACLE_HOME/rdbms/admin/utlu102s.sql to check the upgraded versions
- Restart the database: SQL> shutdown immediate (DO NOT use "shutdown abort" !!!) SQL> startup
- Run utlrp.sql to recompile any remaining stored PL/SQL and Java code. (Approx 156 invalid objects)
SQL> @utlrp.sql
- Apply patch 5257698 (Opatch)
- Shutdown the database
- Set the following environment variables - ORACLE_HOME (New) - ORACLE_SID
- cd $ORACLE_HOME/rdbms/admin sqlplus ' /as sysdba' startup upgrade
- SQL> spool upgrade.log SQL> @catupgrd.sql
(Note # "execute dbms_registry.gather_stats(null)" will take time to run, just leave it, which is called from $ORACLE_HOME/rdbms/admin/cmpdbmig.sql)
- Run $ORACLE_HOME/rdbms/admin/utlu102s.sql to check the upgraded versions
- Restart the database: SQL> shutdown immediate (DO NOT use "shutdown abort" !!!) SQL> startup
- Run utlrp.sql to recompile any remaining stored PL/SQL and Java code. (Approx 156 invalid objects)
SQL> @utlrp.sql
Tuesday, February 24, 2009
'ORA-01918:user 'ADSEUL_US' does not exist' during application of patch 5726010
patch 5726010 is one of the pre requisite patches for the upgrade to R12 from 11i. This script has 2 sql scripts (adgncons.sql and adgrants.sql) which are to be run against the instance. additionally, a third script(adcrtbsp.sql), generated by adgncons should also be run.
adgncons.sql has run successfully. but the following error is thrown during the adcrtbsp.sql run.
============================================
ORA-01918: user 'ADSEUL_US' does not exist
============================================
This error can be safely ignored. ADSEUL_US is a demo EUL for Discoverer.
The one that is needed is EUL_US, which is a standard EUL used when you run / create workbooks in Business Intelligence, for example :
Financials Intelligence, HRMS Intelligence, Purchasing Intelligence etc
adgncons.sql has run successfully. but the following error is thrown during the adcrtbsp.sql run.
============================================
ORA-01918: user 'ADSEUL_US' does not exist
============================================
This error can be safely ignored. ADSEUL_US is a demo EUL for Discoverer.
The one that is needed is EUL_US, which is a standard EUL used when you run / create workbooks in Business Intelligence, for example :
Financials Intelligence, HRMS Intelligence, Purchasing Intelligence etc
Tuesday, December 23, 2008
Oracle database upgrade paths.
8.1.7.X.X
8.1.7.X.X TO 8.1.7.4.0
8.1.7.X.X TO 9.2.0.1.0
8.1.7.X.X TO 9.2.0.2.0
8.1.7.X.X TO 9.2.0.3.0
8.1.7.X.X TO 9.2.0.4.0
8.1.7.X.X TO 9.2.0.5.0
8.1.7.X.X TO 9.2.0.6.0
8.1.7.X.X TO 9.2.0.7.0
8.1.7.X.X TO 9.2.0.8.0
8.1.7.X.X TO 10.1.0.2.0
8.1.7.X.X TO 10.1.0.3.0
8.1.7.X.X TO 10.1.0.4.0
8.1.7.X.X TO 10.1.0.5.0
8.1.7.X.X TO 10.2.0.1.0
8.1.7.X.X TO 10.2.0.2.0
8.1.7.X.X TO 10.2.0.3.0
8.1.7.X.X TO 10.2.0.4.0
8.1.7.X.X TO 11.1.0.6.0
8.1.7.X.X TO 11.1.0.7.0
9.2.0.X.X
9.2.0.X.0 TO 9.2.0.3.0
9.2.0.X.0 TO 9.2.0.4.0
9.2.0.X.0 TO 9.2.0.5.0
9.2.0.X.0 TO 9.2.0.6.0
9.2.0.X.0 TO 9.2.0.7.0
9.2.0.X.0 TO 9.2.0.8.0
9.2.0.X.0 TO 10.1.0.2.0
9.2.0.X.0 TO 10.1.0.5.0
9.2.0.X.0 TO 10.2.0.1.0
9.2.0.X.0 TO 10.2.0.2.0
9.2.0.X.0 TO 10.2.0.3.0
9.2.0.X.0 TO 10.2.0.4.0
9.2.0.X.0 TO 11.1.0.6.0
9.2.0.X.0 TO 11.1.0.7.0
10.1.0.X.0
10.1.0.X.0 TO 10.1.0.3.0
10.1.0.X.0 TO 10.1.0.4.0
10.1.0.X.0 TO 10.1.0.5.0
10.1.0.X.0 TO 10.2.0.1.0
10.1.0.X.0 TO 10.2.0.2.0
10.1.0.X.0 TO 10.2.0.3.0
10.1.0.X.0 TO 10.2.0.4.0
10.1.0.X.0 TO 11.1.0.6.0
10.1.0.X.0 TO 11.1.0.7.0
10.2.0.X.0
10.2.0.X.0 TO 10.2.0.2.0
10.2.0.X.0 TO 10.2.0.3.0
10.2.0.X.0 TO 10.2.0.4.0
10.2.0.X.0 TO 11.1.0.6.0
10.2.0.X.0 TO 11.1.0.7.0
11.1.0.X.0
11.1.0.X.0 TO 11.1.0.6.0
11.1.0.X.0 TO 11.1.0.7.0
NOTE :Downloading Patchsets requires a My Oracle Support (formerly Metalink) username and password.
Downloading Base software requires an Oracle Technology Network (OTN) username and password.
8.1.7.X.X
8.1.7.X.X TO 8.1.7.4.0
1. Install the 8.1.7.4.0 patchset on top of the existing 8.1.7.X.X ORACLE_HOME
Patchset number is : 2376472
http://updates.oracle.com/download/2376472.html
2. Finish the post installation steps as per the patchset README (patch_note.htm).
8.1.7.X.X TO 9.2.0.1.0
1. Install the 9.2.0.1.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/oracle9i/index.html
For installation requirements, refer to the following note :
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Upgrade the database to 9.2.0.1.0.
Refer to the following note for different upgrade methods :
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 159657.1 : Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9iR2 (9.2.0)
REFERENCE:
Known issues and alerts affecting 9.2.0.1 Note 353912.1
8.1.7.X.X TO 9.2.0.2.0
1. Install the 9.2.0.1.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/oracle9i/index.html
For installation requirements refer to the following note :
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 9.2.0.2.0 patchset on top of the existing 9.2.0.1.0 ORACLE_HOME
Patchset number is : 2632931
http://updates.oracle.com/download/2632931.html
3. Upgrade the database to 9.2.0.2.0.
Refer the following note for different upgrade methods :
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 159657.1 : Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9iR2 (9.2.0)
REFERENCE:
Known issues and alerts affecting 9.2.0.2 Note 246010.1
List of fixes added in 9.2.0.2 Note 246017.1
8.1.7.X.X TO 9.2.0.3.0
1. Install 9.2.0.1.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/oracle9i/index.html
For installation requirements refer to the following note :
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 9.2.0.3.0 patchset on top of the existing 9.2.0.1.0 ORACLE_HOME
Patchset number is : 2761332
http://updates.oracle.com/download/2761332.html
3. Upgrade the database to 9.2.0.3.0.
Refer to the following note for different upgrade methods :
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 159657.1 : Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9iR2 (9.2.0)
REFERENCE:
Known issues and alerts affecting 9.2.0.3Note 246001.1
List of fixes added in 9.2.0.3 Note 245939.1
8.1.7.X.X TO 9.2.0.4.0
1.Install 9.2.0.1.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/oracle9i/index.html
For installation requirements refer to the following note :
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 9.2.0.4.0 patchset on top of the existing 9.2.0.1.0 ORACLE_HOME
Patchset number is : 3095277
http://updates.oracle.com/download/3095277.html
3. Upgrade the database to 9.2.0.4.0.
Refer to the following note for different upgrade methods :
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 159657.1 : Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9iR2 (9.2.0)
REFERENCE:
Known issues and alerts affecting 9.2.0.4 Note 245984.1
List of fixes added in 9.2.0.4 Note 245758.1
8.1.7.X.X TO 9.2.0.5.0
1. Install 9.2.0.1.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/oracle9i/index.html
For installation requirements refer to the following note :
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 9.2.0.5.0 patchset on top of the existing 9.2.0.1.0 ORACLE_HOME
Patchset number is : 3501955
http://updates.oracle.com/download/3501955.html
3. Upgrade the database to 9.2.0.5.0.
Refer to the following note for different upgrade methods :
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 159657.1 : Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9iR2 (9.2.0)
REFERENCE:
Known issues and alerts affecting 9.2.0.5 Note 263792.1
List of fixes added in 9.2.0.5 Note 263791.1
8.1.7.X.X TO 9.2.0.6.0
1. Install 9.2.0.1.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/oracle9i/index.html
For installation requirements refer to the following note :
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 9.2.0.6.0 patchset on top of the existing 9.2.0.1.0 ORACLE_HOME
Patchset number is : 3948480
http://updates.oracle.com/download/3948480.html
3. Upgrade the database to 9.2.0.6.0.
Refer to the following note for different upgrade methods :
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 159657.1 : Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9iR2 (9.2.0)
REFERENCE:
Known issues and alerts affecting 9.2.0.6 Note 283899.1
List of fixes added in 9.2.0.6 Note 283897.1
8.1.7.X.X TO 9.2.0.7.0
1. Install 9.2.0.1.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/oracle9i/index.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 9.2.0.7.0 patchset on top of the existing 9.2.0.1.0 ORACLE_HOME
Patchset number is : 4163445
http://updates.oracle.com/download/4163445.html
3. Upgrade the database to 9.2.0.7.0.
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 159657.1 : Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9iR2 (9.2.0)
REFERENCE:
Known issues and alerts affecting 9.2.0.7 Note 308895.1
List of fixes added in 9.2.0.7 Note 308894.1
8.1.7.X.X TO 9.2.0.8.0
1. Install 9.2.0.1.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/oracle9i/index.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 9.2.0.8.0 patchset on top of the existing 9.2.0.1.0 ORACLE_HOME
Patchset number is : 4547809
http://updates.oracle.com/download/4547809.html
3. Upgrade the database to 9.2.0.8.0.
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 159657.1 : Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9iR2 (9.2.0)
REFERENCE:
Known issues and alerts affecting 9.2.0.8 Note 388281.1
List if fixes added in 9.2.0.8 Note 358776.1
8.1.7.X.X TO 10.1.0.2.0
1. Install 10.1.0.2.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/oracle10g/10gr1.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1) .
2. Upgrade the database to 10.1.0.2.0.
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 263809.1 : Complete checklist for manual upgrades to 10gR1 (10.1.0.x)
REFERENCE:
Known issues and alerts affecting 10.1.0.2 Note 263729.1
8.1.7.X.X TO 10.1.0.3.0
1. Install 10.1.0.2.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/oracle10g/10gr1.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 10.1.0.3.0 patchset on top of the existing 10.1.0.2.0 ORACLE_HOME
Patchset number is : 3761843
http://updates.oracle.com/download/3761843.html
3. Upgrade the database to 10.1.0.3.0.
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 263809.1 : Complete checklist for manual upgrades to 10gR1 (10.1.0.x)
REFERENCE:
Known issues and alerts affecting 10.1.0.3 Note 280554.1
List of fixes added in 10.1.0.3 Note 280552.1
8.1.7.X.X TO 10.1.0.4.0
1. Install 10.1.0.2.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/oracle10g/10gr1.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 10.1.0.4.0 patchset on top of 10.1.0.2.0 oracle Home
Patchset number is : 4163362
http://updates.oracle.com/download/4163362.html
3. Upgrade the database to 10.1.0.4.0.
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 263809.1 : Complete checklist for manual upgrades to 10gR1 (10.1.0.x)
REFERENCE:
Known issues and alerts affecting 10.1.0.4 Note 302663.1
List of fixes added in 10.1.0.4 Note 295763.1
8.1.7.X.X TO 10.1.0.5.0
1. Install 10.1.0.2.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/oracle10g/10gr1.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 10.1.0.5.0 patchset on top of the existing 10.1.0.2.0 ORACLE_HOME
Patchset number is : 4505133
http://updates.oracle.com/download/4505133.html
3. Upgrade the database to 10.1.0.5.0.
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 263809.1 : Complete checklist for manual upgrades to 10gR1 (10.1.0.x)
REFERENCE:
Known issues and alerts affecting 10.1.0.5 Note 356201.1
List of fixes added in 10.1.0.5 Note 335869.1
8.1.7.X.X TO 10.2.0.1.0
1. Install 10.2.0.1.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/index.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
The minimum version required to upgrade to 10.2.X.X.X is 8.1.7.4
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
If your oracle database is of a lower version than 8.1.7.4.0 , then upgrade the database to 8.1.7.4.0 first.
Steps to upgrade to 8.1.7.4.0 (Click here)
2. Upgrade the database to 10.2.0.1.0
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 316889.1 : Complete checklist for manual upgrades to 10gR2
REFERENCE:
Known issues and alerts affecting 10.2.0.1 Note 316901.1
8.1.7.X.X TO 10.2.0.2.0
1. Install 10.2.0.1.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/index.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 10.2.0.2.0 patchset on top of the existing10.2.0.1.0 ORACLE_HOME
Patchset number is : 4547817
http://updates.oracle.com/download/4547817.html
The minimum version required to upgrade to 10.2.X.X.X is 8.1.7.4
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
If your oracle database is of a lower version than 8.1.7.4.0 , then upgrade the database to 8.1.7.4.0 first.
Steps to upgrade to 8.1.7.4.0 (Click hereUpgrade the database to 10.2.0.2.0
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 316889.1 : Complete checklist for manual upgrades to 10gR2
REFERENCE:
List of fixes included in 10.2.0.2 Note 358749.1
Known issues and alerts affecting 10.2.0.2 Note 359415.1
8.1.7.X.X TO 10.2.0.3.0
1. Install 10.2.0.1.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/index.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 10.2.0.3.0 patchset on top of the existing10.2.0.1.0 ORACLE_HOME
Patchset number is : 5337014
http://updates.oracle.com/download/5337014.html
The minimum version required to upgrade to 10.2.X.X.X is 8.1.7.4
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
If your oracle database is of a lower version than 8.1.7.4.0 , then Upgrade the database to 8.1.7.4.0 first.
Steps to upgrade to 8.1.7.4.0 (Click here)
3. Upgrade the database to 10.2.0.3.0
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 316889.1 Complete checklist for manual upgrades to 10gR2
REFERENCE:
List of fixes included in 10.2.0.3 Note 391116.1
Known issues and alerts affecting 10.2.0.3 Note 401435.1
8.1.7.X.X TO 10.2.0.4.0
1. Install 10.2.0.1.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/index.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 10.2.0.4.0 patchset on top of the existing 10.2.0.1.0 ORACLE_HOME
Patchset number is : 6810189
http://updates.oracle.com/download/6810189.html
The minimum version required to upgrade to 10.2.X.X.X is 8.1.7.4
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
If your oracle database is of a lower version than 8.1.7.4.0 , then Upgrade the database to 8.1.7.4.0 first.
Steps to upgrade to 8.1.7.4.0 (Click here)
3. Upgrade the database to 10.2.0.4.0
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 316889.1 : Complete checklist for manual upgrades to 10gR2
REFERENCE:
List of fixes included in 10.2.0.4 Note 401436.1
Known issues and alerts affecting 10.2.0.4 Note 555579.1
8.1.7.X.X TO 11.1.0.6.0
1. Install 11.1.0.6.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/index.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
The minimum version required to upgrade to 11.1.0.X.X is 9.2.0.4.0.
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
If your oracle database is of a lower version than 9.2.0.4.0. , then upgrade the database to 9.2.0.4.0. first.
Oracle recommends to install the latest 9.2 patchset ie 9.2.0.8.0
Steps to upgrade to 9.2.0.8.0 (Click here)
2. Upgrade the database to 11.1.0.6.0
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 429825.1 Complete Checklist for Manual Upgrades to 11gR1
REFERENCE:
Availability and Known issues for 11.1.0.6 Note 454506.1
8.1.7.X.X TO 11.1.0.7.0
1. Install 11.1.0.6.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/index.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 11.1.0.7.0 patchset on top of the existing 11.1.0.6.0 ORACLE_HOME
Patchset number is : 6890831
http://updates.oracle.com/download/6890831.html
The minimum version required to upgrade to 11.1.0.X.X is 9.2.0.4.0.
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
If your oracle database is of a lower version than 9.2.0.4.0. , then upgrade the database to 9.2.0.4.0. first.
Oracle recommends to install the latest 9.2 patchset ie 9.2.0.8.0
Steps to Upgrade to 9.2.0.8.0 (Click here)
3. Upgrade the database to 11.1.0.7.0
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 429825.1 Complete Checklist for Manual Upgrades to 11gR1
REFERENCE:
Availability and Known issues for 11.1.0.7 Note 738538.1
9.2.0.X.X
9.2.0.X.0 TO 9.2.0.3.0
1. Install the 9.2.0.3.0 patchset on top of the existing 9.2.0.X.0 ORACLE_HOME
Patchset number is : 2761332
http://updates.oracle.com/download/2761332.html
2. Finish the post installation steps as per the patchset README (patch_note.htm).
REFERENCE:
Known issues and alerts affecting 9.2.0.3Note 246001.1
List of fixes added in 9.2.0.3 Note 245939.1
9.2.0.X.0 TO 9.2.0.4.0
1. Install the 9.2.0.4.0 patchset on top of the existing 9.2.0.X.0 ORACLE_HOME
Patchset number is : 3095277
http://updates.oracle.com/download/3095277.html
2. Finish the post installation steps as per the patchset README (patch_note.htm).
REFERENCE:
Known issues and alerts affecting 9.2.0.4 Note 245984.1
List of fixes added in 9.2.0.4 Note 245758.1
9.2.0.X.0 TO 9.2.0.5.0
1. Install the 9.2.0.5.0 patchset on top of the existing 9.2.0.X.0 ORACLE_HOME
Patchset number is : 3501955
http://updates.oracle.com/download/3501955.html
2. Finish the post installation steps as per the patchset README (patch_note.htm).
REFERENCE:
Known issues and alerts affecting 9.2.0.5 Note 263792.1
List of fixes added in 9.2.0.5 Note 263791.1
9.2.0.X.0 TO 9.2.0.6.0
1. Install the 9.2.0.6.0 patchset on top of the existing 9.2.0.X.0 ORACLE_HOME
Patchset number is : 3948480
http://updates.oracle.com/download/3948480.html
2. Finish the post installation steps as per the patchset README (patch_note.htm).
REFERENCE:
Known issues and alerts affecting 9.2.0.6 Note 283899.1
List of fixes added in 9.2.0.6 Note 283897.1
9.2.0.X.0 TO 9.2.0.7.0
1. Install the 9.2.0.7.0 patchset on top of the existing 9.2.0.X.0 ORACLE_HOME
Patchset number is : 4163445
http://updates.oracle.com/download/4163445.html
2. Finish the post installation steps as per the patchset README (patch_note.htm).
REFERENCE:
Known issues and alerts affecting 9.2.0.7 Note 308895.1
List of fixes added in 9.2.0.7 Note 308894.1
9.2.0.X.0 TO 9.2.0.8.0
1. Install the 9.2.0.8.0 patchset on top of the existing 9.2.0.X.0 ORACLE_HOME
Patchset number is : 4547809
http://updates.oracle.com/download/4547809.html
2. Finish the post installation steps as per the patchset README (patch_note.htm).
REFERENCE:
Known issues and alerts affecting 9.2.0.8 Note 388281.1
List if fixes added in 9.2.0.8 Note 358776.1
9.2.0.X.0 TO 10.1.0.2.0
1. Install 10.1.0.2.0 software.
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/oracle10g/10gr1.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Upgrade the database to 10.1.0.2.0.
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 263809.1 : Complete checklist for manual upgrades to 10gR1 (10.1.0.x)|
REFERENCE:
Known issues and alerts affecting 10.1.0.2 Note 263729.1
9.2.0.X.0 TO 10.1.0.3.0
1. Install 10.1.0.2.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/oracle10g/10gr1.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 10.1.0.3.0 patchset on top of 10.1.0.X.0 ORACLE_HOME
Patchset number is : 3761843
http://updates.oracle.com/download/3761843.html
3. Upgrade the database to 10.1.0.3.0.
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 263809.1 : Complete checklist for manual upgrades to 10gR1 (10.1.0.x)
REFERENCE:
Known issues and alerts affecting 10.1.0.3 Note 280554.1
List of fixes added in 10.1.0.3 Note 280552.1
9.2.0.X.0 TO 10.1.0.4.0
1. Install 10.1.0.2.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/oracle10g/10gr1.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 10.1.0.4.0 patchset on top of 10.1.0.X.0 ORACLE_HOME
Patchset number is : 4163362
http://updates.oracle.com/download/4163362.html
3. Upgrade the database to 10.1.0.40.
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 263809.1 : Complete checklist for manual upgrades to 10gR1 (10.1.0.x)
REFERENCE:
Known issues and alerts affecting 10.1.0.4 Note 302663.1
List of fixes added in 10.1.0.4 Note 295763.1
9.2.0.X.0 TO 10.1.0.5.0
1. Install 10.1.0.2.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/oracle10g/10gr1.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 10.1.0.5.0 patchset on top of 10.1.0.X.0 ORACLE_HOME
Patchset number is : 4505133
http://updates.oracle.com/download/4505133.html
3. Upgrade the database to 10.1.0.5.0.
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 263809.1 : Complete checklist for manual upgrades to 10gR1 (10.1.0.x)
REFERENCE:
Known issues and alerts affecting 10.1.0.5 Note 356201.1
List of fixes added in 10.1.0.5 Note 335869.1
9.2.0.X.0 TO 10.2.0.1.0
1. Install 10.2.0.1.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/index.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
The minimum version required to upgrade to 10.2.X.X.X is 9.2.0.4.0
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
If your oracle database is of a lower version than 9.2.0.4.0 , then upgrade the database to 9.2.0.4.0 first.
Steps to upgrade to 9.2.0.4.0 (Click Here)
2. Upgrade the database to 10.2.0.1.0
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 316889.1 Complete checklist for manual upgrades to 10gR2
REFERENCE:
Known issues and alerts affecting 10.2.0.1 Note 316901.1
9.2.0.X.0 TO 10.2.0.2.0
1. Install 10.2.0.1.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/index.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 10.2.0.2.0 patchset on top of 10.2.0.1.0 ORACLE_HOME
Patchset number is : 4547817
http://updates.oracle.com/download/4547817.html
The minimum version required to upgrade to 10.2.X.X.X is 9.2.0.4.0
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
If your oracle database is of a lower version than 9.2.0.4.0 , then upgrade the database to 9.2.0.4.0 first.
Steps to Upgrade to 9.2.0.4.0 (Click Here)
3. Upgrade the database to 10.2.0.2.0
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 316889.1 Complete checklist for manual upgrades to 10gR2
REFERENCE:
List of fixes included in 10.2.0.2 Note 358749.1
Known issues and alerts affecting 10.2.0.2 Note 359415.1
9.2.0.X.0 TO 10.2.0.3.0
1. Install 10.2.0.1.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/index.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 10.2.0.3.0 patchset on top of 10.2.0.1.0 ORACLE_HOME
Patchset number is : 5337014
http://updates.oracle.com/download/5337014.html
The minimum version required to upgrade to 10.2.X.X.X is 9.2.0.4.0
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
If your oracle database is of a lower version than 9.2.0.4.0 , then upgrade the database to 9.2.0.4.0 first.
Steps to upgrade to 9.2.0.4.0 (Click Here)
3. Upgrade the database to 10.2.0.3.0
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 316889.1 Complete checklist for manual upgrades to 10gR2
REFERENCE:
List of fixes included in 10.2.0.3 Note 391116.1
Known issues and alerts affecting 10.2.0.3 Note 401435.1
9.2.0.X.0 TO 10.2.0.4.0
1. Install 10.2.0.1.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/index.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 10.2.0.4.0 patchset on top of 10.2.0.1.0 oracle Home
Patchset number is : 6810189
http://updates.oracle.com/download/6810189.html
The minimum version required to upgrade to 10.2.X.X.X is 9.2.0.4.0
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
If your oracle database is of a lower version than 9.2.0.4.0 , then Upgrade the database to 9.2.0.4.0 first.
Steps to upgrade to 9.2.0.4.0 (Click Here)
3. Upgrade the database to 10.2.0.4.0
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 316889.1 Complete checklist for manual upgrades to 10gR2
REFERENCE:
List of fixes included in 10.2.0.4 Note 401436.1
Known issues and alerts affecting 10.2.0.4 Note 555579.1
9.2.0.X.0 TO 11.1.0.6.0
1. Install 11.1.0.6.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/index.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
The minimum version required to upgrade to 11.1.0.X.X is 9.2.0.4.0
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
If your oracle database is of a lower version than 9.2.0.4.0 , then upgrade the database to 9.2.0.4.0 first.
Steps to upgrade to 9.2.0.4.0 (Click Here)
3. Upgrade the database to 11.1.0.6.0
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 429825.1 : Complete Checklist for Manual Upgrades to 11gR1
REFERENCE:
Availability and Known issues for 11.1.0.6 Note 454506.1
9.2.0.X.0 TO 11.1.0.7.0
1. Install 11.1.0.6.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/index.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 11.1.0.7.0 patchset on top of the 11.1.0.6.0 Oracle Home
Patchset number is : 6890831
http://updates.oracle.com/download/6890831.html
The minimum version required to upgrade to 11.1.0.X.X is 9.2.0.4.0.
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
If your oracle database is of a lower version than 9.2.0.4.0. , then upgrade the database to 9.2.0.4.0. first.
Oracle recomends to install the latest 9.2 patchset ie 9.2.0.8.0
Steps to Upgrade to 9.2.0.8.0 (Click here)
3. Upgrade the database to 11.1.0.7.0
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 429825.1 Complete Checklist for Manual Upgrades to 11gR1
REFERENCE:
Availability and Known issues for 11.1.0.7 Note 738538.1
10.1.0.X.0
10.1.0.X.0 TO 10.1.0.3.0
1. Install the 10.1.0.3.0 patchset on top of the existing 10.1.0.X.0 ORACLE_HOME
Patchset number is : 3761843
http://updates.oracle.com/download/3761843.html
2. Finish the post installation steps as per the patchset README (patch_note.htm).
REFERENCE:
Known issues and alerts affecting 10.1.0.3 Note 280554.1
List of fixes added in 10.1.0.3 Note 280552.1
10.1.0.X.0 TO 10.1.0.4.0
1. Install the 10.1.0.4.0 patchset on top of the existing 10.1.0.X.0 ORACLE_HOME
Patchset number is : 4163362
http://updates.oracle.com/download/4163362.html
2. Finish the post installation steps as per the patchset README (patch_note.htm).
REFERENCE:
Known issues and alerts affecting 10.1.0.4 Note 302663.1
List of fixes added in 10.1.0.4 Note 295763.1
10.1.0.X.0 TO 10.1.0.5.0
1.Install the 10.1.0.5.0 patchset on top of the existing 10.1.0.X.0 ORACLE_HOME
Patchset number is : 4505133
http://updates.oracle.com/download/4505133.html
2. Finish the post installation steps as per the patchset README (patch_note.htm)
REFERENCE:
Known issues and alerts affecting 10.1.0.5 Note 356201.1
List of fixes added in 10.1.0.5 Note 335869.1
10.1.0.X.0 TO 10.2.0.1.0
1. Install 10.2.0.1.0 software
The software can be downloaded from the following link : http://www.oracle.com/technology/software/products/database/index.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Upgrade the database to 10.2.0.1.0
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 316889.1 : Complete checklist for manual upgrades to 10gR2
REFERENCE:
Known issues and alerts affecting 10.2.0.1 Note 316901.1
10.1.0.X.0 TO 10.2.0.2.0
1. Install 10.2.0.1.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/index.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 10.2.0.2.0 patchset on top of 10.2.0.1.0 ORACLE_HOME
Patchset number is : 4547817
http://updates.oracle.com/download/4547817.html
3. Upgrade the database to 10.2.0.2.0
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 316889.1 : Complete checklist for manual upgrades to 10gR2
REFERENCE:
List of fixes included in 10.2.0.2 Note 358749.1
Known issues and alerts affecting 10.2.0.2 Note 359415.1
10.1.0.X.0 TO 10.2.0.3.0
1. Install 10.2.0.1.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/index.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 10.2.0.3.0 patchset on top of 10.2.0.1.0 ORACLE_HOME
Patchset number is : 5337014
http://updates.oracle.com/download/5337014.html
3. Upgrade the database to 10.2.0.3.0
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 316889.1 : Complete checklist for manual upgrades to 10gR2
REFERENCE:
List of fixes included in 10.2.0.3 Note 391116.1
Known issues and alerts affecting 10.2.0.3 Note 401435.1
10.1.0.X.0 TO 10.2.0.4.0
1. Install 10.2.0.1.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/index.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 10.2.0.4.0 patchset on top of 10.2.0.1.0 ORACLE_HOME
Patchset number is : 6810189
http://updates.oracle.com/download/6810189.html
3. Upgrade the database to 10.2.0.4.0
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 316889.1 : Complete checklist for manual upgrades to 10gR2
REFERENCE:
List of fixes included in 10.2.0.4 Note 401436.1
Known issues and alerts affecting 10.2.0.4 Note 555579.1
10.1.0.X.0 TO 11.1.0.6.0
1. Install 11.1.0.6.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/index.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Upgrade the database to 11.1.0.6.0
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 429825.1 : Complete Checklist for Manual Upgrades to 11gR1
REFERENCE:
Availability and Known issues for 11.1.0.6 Note 454506.1
10.1.0.X.0 TO 11.1.0.7.0
1. Install 11.1.0.6.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/index.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 11.1.0.7.0 patchset on top of the 11.1.0.6.0 ORACLE_HOME
Patchset number is : 6890831
http://updates.oracle.com/download/6890831.html
3. Upgrade the database to 11.1.0.7.0
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 429825.1 Complete Checklist for Manual Upgrades to 11gR1
REFERENCE:
Availability and Known issues for 11.1.0.7 Note 738538.1
10.2.0.X.0
10.2.0.X.0 TO 10.2.0.2.0
1. Install the 10.2.0.2.0 patchset on top of 10.2.0.X.0 ORACLE_HOME
Patchset number is : 4547817
http://updates.oracle.com/download/4547817.html
2. Finish the post installation steps as per the patchset README (patch_note.htm)
REFERENCE:
List of fixes included in 10.2.0.2 Note 358749.1
Known issues and alerts affecting 10.2.0.2 Note 359415.1
10.2.0.X.0 TO 10.2.0.3.0
1. Install the 10.2.0.3.0 patchset on top of 10.2.0.X.0 ORACLE_HOME
Patchset number is : 5337014
http://updates.oracle.com/download/5337014.html
2. Finish the post installation steps as per the patchset README (patch_note.htm)
REFERENCE:
List of fixes included in 10.2.0.3 Note 391116.1
Known issues and alerts affecting 10.2.0.3 Note 401435.1
10.2.0.X.0 TO 10.2.0.4.0
1. Install the 10.2.0.4.0 patchset on top of 10.2.0.X.0 ORACLE_HOME
Patchset number is : 6810189
http://updates.oracle.com/download/6810189.html
2. Finish the post installation steps as per the patchset README (patch_note.htm)
REFERENCE:
List of fixes included in 10.2.0.4 Note 401436.1
Known issues and alerts affecting 10.2.0.4 Note 555579.1
10.2.0.X.0 TO 11.1.0.6.0
1. Install 11.1.0.6.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/index.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Upgrade the database to 11.1.0.6.0
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 429825.1 : Complete Checklist for Manual Upgrades to 11gR1
REFERENCE:
Availability and Known issues for 11.1.0.6 Note 454506.1
10.2.0.X.0 TO 11.1.0.7.0
1. Install 11.1.0.6.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/index.html
Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
2. Install the 11.1.0.7.0 patchset on top of the 11.1.0.6.0 ORACLE_HOME
Patchset number is : 6890831
http://updates.oracle.com/download/6890831.html
3. Upgrade the database to 11.1.0.7.0
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 429825.1 Complete Checklist for Manual Upgrades to 11gR1
REFERENCE:
Availability and Known issues for 11.1.0.7 Note 738538.1
11.1.0.X.0
11.1.0.X.0 TO 11.1.0.6.0
The BASE release of Oracle 11g Release 1 is 11.1.0.6.
11.1.0.X.0 TO 11.1.0.7.0
1. Install the 11.1.0.7.0 patchset on top of the 11.1.0.6.0 ORACLE_HOME
Patchset number is : 6890831
http://updates.oracle.com/download/6890831.html
2. Finish the post installation steps as per the patchset README (patch_note.htm).
REFERENCE:
Availability and Known issues for 11.1.0.7 Note 738538.1
Subscribe to:
Posts (Atom)