1 Latest Autoconfig patch 6372396
2 10g Operability patch 4653225
3 Developer 6i - Patchset 17
4 Installation of 10g software
5 Installation of 10g companion products
6 Installation of patchset 10.2.0.4 ( 6810189)
7 Run 10g preupgrade check file in 9i database ( utlu102i.sql ) and (utltzuv2.sql)
8 Fix the things as suggested by script ulu102i.sql
9 gather dictionary stats
10 Analyze dictionary objects for possible corruption
11 Create a list of invalid objects after running utlrp
12 Create a list of users having connect role
13 use $ORACLE_HOME/nls/data/old/cr9idata.pl script to create the $ORACLE_HOME/nls/data/9idata directory in 10g home
14 Copy and modify the init.ora file from 9i Oracle home to new 10g Oracle Home
15 Create SYSAUX Tablespace
16 Set environment for the new Database 10g
17 Cold backup of 9i database
18 Start 9i database from 10g Oracle Home in upgrade mode
19 run catupgrd.sql
20 run utlu102s.sql
21 run utlrp.sql
22 Apply the Patch 5005469, to fix the KOREAN_MORPH_LEXER
23 run adgrants.sql
24 run AD_TOP/patch/115/sql/adctxprv.sql as sqlplus apps/pwd @adctxprv.sql manager CTXSYS
25 Implement the changes to CONTEXT_FILE with respect to new Oracle Home
26 run adstats.sql in restrict mode
27 Re-create custom database links.
28 Re-create grants and synonyms.
29 Apply Oracle Receivables patch 5753621.
30 Start the Application Tier.
31 Gather Schema stats with 10% estimate
Tuesday, 21 April 2009
Upgrade Rel 10.2.0.3 – 12.0.4 Oracle Applications database to version 10.2.0.4
Upgrade Rel 10.2.0.3 – 12.0.4 Oracle Applications database to version 10.2.0.4
1.) Install Oracle database patch 10.2.0.4 (Time: 1 hour)
a. Create 10.2 stage directory, cd to Disk1 directory and execute ./runInstaller.
2.) Apply database patches to 10.2.0.4 home (Time: 1 hour)
a. 4247037
b. 6870937
c. 7014646
d. 8362683
e. 7411865
f. 7038750 --- only available for 64 bit OS
g. 5386204
h. 7197637
i. 7496435 – all the patches in this bundle patch are covered by 8362683
( Please check the below patches are not covered in 8362683 if not pl apply)
Note: - patch #7278117 which is a part of 8362683 was giving a following error while applying. It has a conflict with the patch 7014646. As patch #7014646 is mentioned in the interop doc 454750.1, I chose to install 7014646 over 7278117.
Error:-
The following warnings have occurred during OPatch execution:
1) OUI-67301:
Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :
7014646 7278117
4) Prepare DB for Upgrade (Time: 20 minutes)
a. Shutdown all application services
b. Verify that 10.2.0.3 database is defined in /var/opt/oracle/oratab file.
Upgrade database {Time: 2 Hrs)
c. Run dbua from 10.2.0 Oracle Home/bin directory.
i. Choose database to be upgraded
ii. Choose not to backup database.
Used catupgrd.sql to upgrade the database because DBUA screen was dead slow and not responding. After that I executed utlrp.sql for compiling the components.
Post Upgrade {Time: 2Hr}
d. Add 10gR3 release specific parameters to the init.ora file and remove obsolete parameters follow the doc 216205.1 -- None required
e. Run changeperm.sh from $ORACLE_HOME/install.
f. Select comp_name,version,status from dba_registry;
In the out put ,status of all components should be Valid. If there is any invalid check the note 565600.1
g. Run autoconfig on db.
h. Copy $APPL_TOP/admin/adstats.sql to $ORACLE_HOME/appsutil/admin directory.
i. Shutdown database and startup in restricted mode and run adstats.sql as sysdba. Then shutdown database again and startup in normal mode.(make sure we have atleast 1.5GB)
j. Start the new database listener.
k. select owner, table_name, stattype_locked from dba_tab_statistics
where stattype_locked is not null
If there are any schemas (which has tables with locked statistics)
other than SYS, SYSTEM execute
the following command:
exec dbms_stats.unlock_schema_stats('');
or exec dbms_stats.unlock_schema_stats ('&name');
l. Run Gather statistics on fixed tables using the below sql
exec dbms_stats.gather_fixed_objects_stats;
m. Run adadmin and run program “recreate grants and synonyms”.
n. Startup application services and test login.
o. Run Gather Schema Stats (timings are exclusive of this step )
References: Metalink Doc. 454750.1 and For issues 555579.1
1.) Install Oracle database patch 10.2.0.4 (Time: 1 hour)
a. Create 10.2 stage directory, cd to Disk1 directory and execute ./runInstaller.
2.) Apply database patches to 10.2.0.4 home (Time: 1 hour)
a. 4247037
b. 6870937
c. 7014646
d. 8362683
e. 7411865
f. 7038750 --- only available for 64 bit OS
g. 5386204
h. 7197637
i. 7496435 – all the patches in this bundle patch are covered by 8362683
( Please check the below patches are not covered in 8362683 if not pl apply)
Note: - patch #7278117 which is a part of 8362683 was giving a following error while applying. It has a conflict with the patch 7014646. As patch #7014646 is mentioned in the interop doc 454750.1, I chose to install 7014646 over 7278117.
Error:-
The following warnings have occurred during OPatch execution:
1) OUI-67301:
Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :
7014646 7278117
4) Prepare DB for Upgrade (Time: 20 minutes)
a. Shutdown all application services
b. Verify that 10.2.0.3 database is defined in /var/opt/oracle/oratab file.
Upgrade database {Time: 2 Hrs)
c. Run dbua from 10.2.0 Oracle Home/bin directory.
i. Choose database to be upgraded
ii. Choose not to backup database.
Used catupgrd.sql to upgrade the database because DBUA screen was dead slow and not responding. After that I executed utlrp.sql for compiling the components.
Post Upgrade {Time: 2Hr}
d. Add 10gR3 release specific parameters to the init.ora file and remove obsolete parameters follow the doc 216205.1 -- None required
e. Run changeperm.sh from $ORACLE_HOME/install.
f. Select comp_name,version,status from dba_registry;
In the out put ,status of all components should be Valid. If there is any invalid check the note 565600.1
g. Run autoconfig on db.
h. Copy $APPL_TOP/admin/adstats.sql to $ORACLE_HOME/appsutil/admin directory.
i. Shutdown database and startup in restricted mode and run adstats.sql as sysdba. Then shutdown database again and startup in normal mode.(make sure we have atleast 1.5GB)
j. Start the new database listener.
k. select owner, table_name, stattype_locked from dba_tab_statistics
where stattype_locked is not null
If there are any schemas (which has tables with locked statistics)
other than SYS, SYSTEM execute
the following command:
exec dbms_stats.unlock_schema_stats('
or exec dbms_stats.unlock_schema_stats ('&name');
l. Run Gather statistics on fixed tables using the below sql
exec dbms_stats.gather_fixed_objects_stats;
m. Run adadmin and run program “recreate grants and synonyms”.
n. Startup application services and test login.
o. Run Gather Schema Stats (timings are exclusive of this step )
References: Metalink Doc. 454750.1 and For issues 555579.1
Subscribe to:
Posts (Atom)