Tuesday, December 30, 2008

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.

How to enable Forms sessions monitoring through Oracle Applications Manager and FND_FORM_SESSION_V view in release 12 implementations


1. In order to enable the Forms Session monitoring we need to do the following steps


2. Change the following profile options as follows through Oracle EBS - > System Administrator - > Profile - > System


Sign-On:Audit Level – FORM
AuditTrail:Activate – YES


3. The forms currently logged wont be captured, so please logoff and login to EBS


4. Now we’ll be able to see the forms sessions through Oracle Applications Manager (Oracle Applications Manager - > Site Map - > Monitoring - > Forms Sessions - >)

5. We can also monitor it through the view FND_FORM_SESSIONS_V

Sunday, December 28, 2008

Applying Patches to Oracle Management Server (OMS) and Agent Home

Applying a patch on the OMS HOME

1. Set the ORACLE_HOME environment variable
ORACLE_HOME=
export ORACLE_HOME

2. Include /OPatch in the $PATH environment variable
PATH=.$PATH$ORACLE_HOME/OPatch
export PATH

3. Shut down the OMS Server

4. Navigate to the directory where the patch is located and run OPatch

$ cd patch number

$ opatch apply

5. The applied patch can be checked through,

$ opatch lsinventory

6. Start the OMS

Applying a patch on the AGENT HOME

1. Set the ORACLE_HOME environment variable

ORACLE_HOME=
export ORACLE_HOME

2. Include /OPatch in the $PATH environment variable
PATH=.$PATH$ORACLE_HOME/OPatch
export PATH

3. Shut down the agent.

4. Navigate to the directory where the patch is located and run OPatch

$ cd patch number

$ opatch apply

5. The applied patch can be checked through,

$ opatch lsinventory

6. Start the agent

If prompted by OPatch to "Rollback" existing patch, hit "y" and continue.

Patch Deinstallation Instructions (Both OMS and Agent)

Use the following command

cd patch number/

opatch rollback -id patch number

Friday, December 26, 2008

Create a custom top and a corresponding user



- Create the directory structure of the new custom top
cd $APPL_TOP
mkdir cust
cd cust
mkdir 11.5.0
cd 11.5.0
mkdir bin
mkdir forms
mkdir forms/US
mkdir sql
mkdir reports
mkdir log
mkdir admin
mkdir admin/sql
mkdir admin/odf
mkdir resource
mkdir reports/US

- Register the custom appliaction in Oracle Applications
login to oracle applications
System administrator -> Application -> Register
Application - Custom development
Base path - XXXX_CUST_TOP
Short name - CUST
Description - Custom Top
save the record

- Add Application to a Data Group
Navigate to system administrator -> Security: Oracle -> DataGroup
Data Group = standard
Description = standard data group
click on "Copy Applications from" and pick Standard data Group, then add following entry.
Application = Custom development
Oracle ID = APPS
Description = Custom Application
save the record

- Edit the context file and add an entery for the newly created custom directory
cd $APPL_TOP/admin
vi VISN11_nglinux05.xml
insert the following entry
/u10/oracle/visn11appl/cust/11.5.0
save and quit file

- Run autoconfig
cd $COMMON_TOP/admin/scripts/context_name
sh adstpall.sh apps/****
sh adautocfg.sh apps/****
sh adstrtal.sh apps/****

- Change the OS level write permissions for the cust directory (execute as root user or the apps file system owner)
cd $APPL_TOP
chmod -R 775 cust

- Create the OS user to transfer the files to the custom top (execute as root user)
groupadd appldev
useradd -g appldev -d /home/appldev
use "passwd" utility to set the password for the user created

How to Get the Forms,PLL,LDT,Reports Version from O/S level

Login in as the user who owns the application file system,

1. Forms

When considering forms one needs to get the version from $JA_TOP and $AU_TOP as well.


Navigate to cd $JA_TOP/forms/US

Execute command --- > strings -a grep '$Header'

Example

strings -a JAINPORE.fmx grep '$Header'

Navigate to cd $AU_TOP/forms/US

Execute command --- > strings -a grep '$Header'

Example

strings -a JAINPORE.fmb grep '$Header'

2. Reports

Navigate to cd $JA_TOP/reports/US


Execute command --- > strings -a grep '$Header'

Example

strings -a JAINARDR.rdf grep '$Header'

3. Library files

Navigate to cd $AU_TOP/resource

Execute command --- > strings -a grep '$Header'

Example

strings -a CUSTOM.pll grep '$Header'

4. LDT

Navigate to cd $JA_TOP/patch/115/import/US

Execute command --- > strings -a grep '$Header'

Example

strings -a jai115cp_F.ldt grep '$Header'

Thursday, December 25, 2008

Oracle whitepaper for reducing database size

A new Oracle whitepaper is now available that describes the best practices to keep database sizes and in turn, the systems data footprint and their associated costs to a minimum by discussing strategies in archiving, information purging and information lifecycle management.

This whitepaper can be found in metalink note 752322.1 (Reducing Your Oracle E-Business Suite Data Footprint using Archiving, Purging, and Information Lifecycle Management)

How To Add Workflow Worklist To EBusiness Suite Home Page

1. Please set the following profile options for the user who performs the Home Page personalizations,

Personalize Self Service Definition - Yes

FND: Personalization Region Link - Yes


2. Login to Applications Home Page and select the 'Personalize Page' link


3. Click on Personalize "Home Contenttable" link


4. In the "Row Layout: Home Content Row" row, click on Personalize icon (pencil)


5. Change the rendered attribute to True in the "Site" column.


6. Click on Apply


7. Log off the applications


8. Log in to the applications


9. The worklist should appear this time.


10. Once confirmed please revert the profile options as follows,


Personalize Self Service Definition - No

FND: Personalization Region Link - No

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