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