Oracle Application DBA Portal

Procedure followed to Upgrade 11.5.9 to 11.5.10.2

Documents followed
Metalink Oracle Document ID : 316365.1 – Oracle Applications Release 11.5.10.2 Main. Pack Instlation Instructions
Instructions
Metalink Oracle Document ID : 259484.1 - Release 11.5.10 Maintenance Pack Installation

Reference
216205 – Database Initilization Parameters and Conf for Oracle Apps 11i

Basic Maintenance

1. Check the Disk space – Minimum space required 3 – 4 GB Free space.
2. Add additional table space for this tablespace BISD, IGFD,ARD,AHLX,OZFX,OKSX,OKCD,IGSX,PNX

ALTER DATABASE DATAFILE ‘path/okcd01.dbf’ RESIZE 150M; / EXTEND ON etc.

3. Check the Invalid Objects
4. Check the Missing files
5. Recompile Apps Schema, Forms, Reports etc
6. Regenerate Env, Jar Files etc.
7. Check hostname, domainname
8. Check file-max, Limit Processors etc.
9. Check the kernel parameters

1. Apply latest AD utility Patch – 4712852

2. Apply patch 4238286 – TUMS MP

3. Apply necessary patches as reported by TUMS

4. Apply 4709948 – Technology Stack Validation Report

5. Apply 3072811 – Oracle HTTP server patch [Stop the apache server and apply, before applying
a. To stop apache $COMMON_TOP/admin/scripts/sid_host/adapcctl.sh stop
a. export ORACLE_HOME = IAS_ORACLE_HOME path
b. ./patch.sh install
c. Unzip oprocmgr – check
d. Start apache -$COMMON_TOP/admin/scripts/sid_hos/adappctl.sh start

6. In Application Tier – In context file – SID_host.xml in $APPL_TOP/admin dir
Symbolic link pointing to $COMMON_TOP, $JAVA_TOP, PORTAL to be replaced with direct link not through symbolic link for ex.

/erpp – is s a symbolic link to /data/erpp & is available in / file system

In Context file it might have mentioned as /erpp/erppcomn/html to be replaced with /data/erpp/erppcomn

7. s_html, s_javatop, s_pt,s_oemcomment,s_toplevel domain - comment these lines in SID_host.xml – Application Context file.

8. Apply patch 4318672 – Technology Stack Validation Utility

9. _system_trig_enabled=false – initSID.ora

10. REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE –initSID.ora

11. orapwd file = /erpp/erppdb/9.2.0/dbs/orapw password=admin

12. Grant sysdba to apps

13. perl Txkrun.pl –script –InstSSLFix

14. Apply 4948577 – Release 6i patch 18

15. Apply 3966092 – one off patch 8.1.7.4 – IAS_ORACLE_HOME

16. Apply 4968700 – Additional Developer 6i patch

17. Apply 4261542 -

18. Apply 4888294 - Application Interoperability patch for Developer 6i patch 18

19. Apply 2376472 - 8.1.7.4 patchset for Oracle Data Server [Application].
[8.0.6 Oracle Database used in 11.5.9 is obsolete].

20. Apply 4029076 - Delivery of http client.jar [1022A],OJSP 11352 provider jar and SSL patch for IAS Technology Stack.

21. Copy perl directory from SIDora/Apache to /SIDdb/9.2.0/Apache [Problems faced in perl installation available in SIDdb directory].

22. DIRECTORY ACCESSBILITY=FALSE – initSID.ora

23. _B_TREE_BITMAP_PLANS=FALSE – initSID.ora

24. ALTER TABLESPACE SYSTEM ADD datafile ‘path/system12.dbf’ size 1024M;

25. Apply patch 5035661 – Oracle Universal Installer 2.2

26. Apply patch 4163445 - Database upgrade 9.2.0.3 to 9.2.0.7

27. Apply 2617419 – O Patch

28. Apply 4483951 – Query gives wrong results in 9.2.0.7 version

29. Ensure 750 MB Free rollback segment space is available

30. Ensure 512 Max Extents ??

31. Apply patch 3180164 – Migrate to New table space system followed by 11.5.10.2

32. Apply patch 3348000 – Maintenace Pack 11.5.10.2 – CU2 patch. [After applying the patch, patch itself will take care of
a. Compiling Invalid Objects
b. Running Auto Config
c. Compile Flexfield
d. Recreate grants and synonyms
e. Main. Multiple Reporting Currencies etc.

33. In Application Context file of apps tier and change the following
"s_options_symlinks" from "Options -FollowSymLinks"
"s_options_symlinks" to "Options FollowSymLinks"

34. Start the Application Services

Labels: Upgrade 11.5.9 to 11.5.10.2

posted by Srinivasan .R @ 11:39 AM

1 Comments:

At May 24, 2010 at 11:53 PM, RAJ said…

Hi,

First of all, you have done a great job in posting so much info.

My question is regarding

19. Apply 2376472 - 8.1.7.4 patchset for Oracle Data Server [Application].

Going through Patch readme, it appears we can apply patch binaries on iAS 1022 home but regarding database portion of patch, how do we handle ?

In the readme of patch set 2376472 do we ignore the database related steps as our Applications database is on 9.2.0.8 ?

Any help is greatly appreciated. Thanks so much
My email is information2100@yahoo.com