Upgrading Oracle Apps 11i Database to Oracle Database 10g Release 2 (10.2.0) - Step 1

Upgrading Oracle Apps 11i Database to Oracle Database 10g Release 2 (10.2.0) - Step 1
1.
OS : Enterprise Linux Enterprise Linux AS release 4 (October Update 6)
Oracle Application Version : 11.5.10 CU2
Oracle Database Version : 9.2.0.6

2.
SQL> select release_name "Apps Version",product_group_type "Group Type" from apps.fnd_product_groups;
Apps Version Group Type
------------- ------------------------------
11.5.10.2 Standard

3.
SQL> select name,log_mode from v$database;
NAME LOG_MODE
--------- ------------
VIS NOARCHIVELOG

4.
SQL> select host_name,version from v$instance;
HOST_NAME VERSION
-------------------- -----------------
sys22.doyen.in 9.2.0.6.0

5.
SQL> select banner from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
PL/SQL Release 9.2.0.6.0 - Production
CORE 9.2.0.6.0 Production
TNS for Linux: Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 - Production

6.
SQL> select comp_name,version from dba_registry;
COMP_NAME VERSION
----------------------------------- ------------------------------
Oracle9i Catalog Views 9.2.0.6.0
Oracle9i Packages and Types 9.2.0.6.0
Oracle9i Real Application Clusters 9.2.0.6.0
JServer JAVA Virtual Machine 9.2.0.6.0
Oracle XDK for Java 9.2.0.8.0
Oracle9i Java Packages 9.2.0.6.0
Oracle interMedia 9.2.0.6.0
Spatial 9.2.0.6.0
Oracle Text 9.2.0.6.0
OLAP Analytic Workspace 9.2.0.6.0
Oracle OLAP API 9.2.0.6.0
OLAP Catalog 9.2.0.6.0
Oracle Data Mining 9.2.0.6.0
Oracle XML Database 9.2.0.6.0

7.
[applmgr@sys22 ~]$ $ORACLE_HOME/bin/f60gen help=y grep Forms
Forms 6.0 (Form Compiler) Version 6.0.8.25.2 (Production)
Forms 6.0 (Form Compiler): Release - Production
Forms_Doc=NO Print Forms Doc report

Oracle Forms 6.0(6.0.8.25.2) Patch 16

========================================

1.Upgrade Oracle Application(11i)

SQL> select release_name "Apps Version",product_group_type "Group Type" from apps.fnd_product_groups;
Apps Version Group Type
------------- ------------------------------
11.5.10.2 Standard

SQL> select count(*) from apps.ad_bugs where bug_number = '4653225';
COUNT(*)
----------
1

Continue Upgrading Oracle Apps 11i Database to Oracle Database 10g Release 2 (10.2.0) - Step 2