Upgrade 11.1.0.7 to 11.2.0.3 on R12

Wednesday, July 31, 2013 · 0 comments

SELF NOTES: Upgrade 11.1.0.7 to 11.2.0.3 on R12

1. Install Oracle 11.2.0.3 software only, and follow installing the examples CD.

2. Copy the 11.1.0.7 old necessary binary file to the new 11.2.0.3 files, they are:
                - init file from dbs (edit and replance env to new home)
                - copy the appsutil directory (edit and replance env to new home)
                - copy the network/admin/<Context_name> (edit and replance env to new home)
                - copy the env file (edit and replance env to new home)

3. Apply the AD patches.
8919489 
9062910 
9738085 
9852070 
9868229
10163753 
11071569 
12686610 

4. From AD_TOP/bin directory create the appsutil directory for DB and then FTP/Copy and unzip –o to the database 11.2.0.3

5. On 11.2.0.3 home, apply additional 11.2.0.3 RDBMS patches :
Apply the following patches (OPATCH) for all UNIX/Linux platforms:
NOTE: Do not run any of the post install instructions as those will be done after the upgrade.

a) 4247037
cd $ORACLE_HOME/md/admin
connect to the database using sqlplus / as sysdba
sqlplus> @catmgdidcode

b) 9858539
Run following files as sysdba
cd $ORACLE_HOME/rdbms/admin
@catnomtt.sql
@catnomta.sql
@dbmsmeta.sql
@dbmsmeti.sql
@dbmsmetu.sql
@dbmsmetb.sql
@dbmsmetd.sql
@dbmsmet2.sql
@catmeta.sql
@prvtmeta.plb
@prvtmeti.plb
@prvtmetu.plb
@prvtmetb.plb
@prvtmetd.plb
@prvtmet2.plb
@catmet2.sql
-- recompile dbms_metadata_int to enable the diffing code
alter package dbms_metadata_int compile plsql_ccflags = 'ku$xml_enabled:true';
-- recompile dbms_metadata_util to enable the xmlschema load code
alter package dbms_metadata_util compile plsql_ccflags = 'ku$xml_enabled:true';

c) 12942119
d) 12960302
e) 12985184
f) 13001379
connect / as sysdba
execute sys.dbms_metadata_util.load_stylesheets;

g) 14275605 (will be rollback: 9858539)
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT
3343438  13696216  13923374  14275605

h) 13004894
i) 13258936
cd $ORACLE_HOME/ctx/admin/ctxpatch/
sqlplus / as sysdba
@ctxpatch11203.sql

j) 13366268
 ALTER SESSION SET CURRENT_SCHEMA=CTXSYS
@/ctx/admin/drisgp.plb
@/ctx/admin/drvddl.plb
@/ctx/admin/drvxtab.plb

6.Run utlu112isql.
- Source the 11.1.0.7 db envplsql_native_library_dir
- Shutdown the listener
- Copy the file /11.2.0/rdbms/admin/utlu112i.sql to a different location ‘/usr/tmp/’
- Run the script as sysdba, ensuring the output is spooled to a file.
                        - Increase sysaux tablespace 600mb
                        - comment out parameters: plsql_native_library_dir, plsql_native_library_subdir_count
                        - purge dba_recyclebin;
                        - Follow all recommendations.

7. Shutdown Application Server and DB listener.

8. Ensure in /etc/oratab file the OLD Oracle home and sid is set.

9. Ensure no ENV file is set and Invoke DBUA from 11.2.0.3 home/bin:
 ./dbua -initParam "_disable_fast_validate=TRUE"

10. Source the 11.1.0.7 DB env file, and then:
Go to 11.2.0.3 ORACLE_HOME/nls/data/old
Run “perl cr9idata.pl”

11. Correct sqlplus issue on DB tier (ORA_TZFILE)
Connecting sqlplus will give you error:
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
                        Edit the 11.2.03.Oracle_home/appsutil/script/$CONTEXT_NAME/adautocfg.sh
                        Replace 11.1.0 with 11.2.0


11. Run all the post installation steps as per instruction no. 5

12. Run the utlrp.sql and verify the invalid objects.
  
13. Source DB environment file and run scripts:
sqlplus / as sysdba @$APPL_TOP/admin/adgrants.sql apps
sqlplus apps/apps @$AD_TOP/patch/115/sql/adctxprv.sql manager CTXSYS
exec ctxsys.ctx_adm.set_parameter('file_access_role', 'public');
sqlplus apps/apps @$FND_TOP/patch/115/sql/wfaqupfix.sql apps apps

14. Run DB autoconfig.

15. Gather SYS statistics
sqlplus "/ as sysdba"
alter system enable restricted session;
sqlplus / as sysdba @$APPL_TOP/admin/adstats.sql
alter system disable restricted session;

16. Recreate grants and synonyms.

17. Check the DB alert log file

18. Restart the EBS instance




Search This Blog

About Me

I am an Oracle certified DBA and Apps DBA, totally loving my field of work. I have created this blog in order to save my studies in my field and share it with all.

View Asif Muhammad's profile on LinkedIn

Which is the most featurized database???

Followers

Site Traffic