Creating FRD (Forms Runtime Diagnostic) log in Oracle Applications R12

Forms Runtime Diagnostic (FRD) is a runtime event-based logging system intended to aid in the debugging of Forms applications. FRD is enabled at runtime on a user by user basis. When a form is run with FRD enabled, a combination of external user-application interactions and internal Forms processing events are written in chronological order to a log on the file system.

The following steps shows how to create a FRD (Forms Runtime Diagnostic) Log in EBusiness Suite R12 using Forms 10g

1. Make the USER value for profile option 'ICX: Forms Launcher' the same as the SITE value

e.g. copy value of ICX: Forms Launcher for the SITE

"http://testserver.oracle.com:8005/forms/frmservlet"

to be the value for the USER.

2. Append the USER value of ICX: Forms Launcher with the "?record=collect" (without the quotes)

e.g. update the value of ICX: Forms Launcher for the user to be

"http://testserver.oracle.com:8005/forms/frmservlet?record=collect"

3. Save this change at the USER level.

4. Logout and Log back in again, for this profile to take effect. When you login again, a message box pops up, which alerts you that Diagnostics is enabled.

5. Go to Help->About Oracle Applications, go to the section

----------------------------------------

Forms Server Environment Variables

----------------------------------------

There you should see a FORMS_TRACE_DIR. Note the value of this variable.

P.S: If you find that the FORMS_TRACE_DIR is not defined, then ask your sysadmin to bring down the forms server, define this environment variable in the middle tier (form tier) to point to a valid directory, and then bring the forms-sever back up .

6. Reproduce the Forms-Issue, which you are trying to diagnose.

7. Go to the directory specified in the FORMS_TRACE_DIR variable. List the latest files. The FRD Log should be the one with the string "collect" in its name.

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