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
No comments:
Post a Comment