Monday 28 May 2018

How to apply CPU OCT 2015 patch on 10.1.3 in r12.1.3

Hey DBA-Mates…
Hope you all doing well. CPU patches is little bit different than other patches but as I always says we/you can do it just need time and patient. 
Recently one of my colleague applied CPU Oct2015 apps patches 10.1.3.5 in R12.1.3
This below steps which guided to him and patches applied successfully. 
So, I thought to share with you all. Hope this may useful and helpful in your career. 
It is almost from basic and each point is provided.
I would like to request one more thing, please always read and follow the patches either readme.txt or readme.html which is very important. So, let’s see the below steps:
Check for OS details for downloading correct patch:
OS version details:
$ uname -a
SunOS hostname 5.xx $$.$$ sun4v sparc sun4v

$ cat /etc/release
                            Oracle Solaris $$.$ SPARC
  Copyright (c) 1983, 2017, Oracle and/or its affiliates.  All rights reserved.
                            Assembled 05 October 2017
$ isainfo -b
64 (bit)

$ opatch version
Oracle Interim Patch Installer version 1.0.0.0.64
Copyright (c) 2011 Oracle Corporation. All Rights Reserved..
Oracle recommends you to use the latest OPatch version
and read the OPatch documentation available in the OPatch/docs
directory for usage. For information about the latest OPatch and
other support-related issues, refer to document ID 293369.1
available on My Oracle Support (https://myoraclesupport.oracle.com)

OPatch Version: 1.0.0.0.64

Note: Always read patch either readme.txt or readme.html and follow that.
Note: As per readme.html Opatch version should be min 1.0.0.0.63, here in our case it is 1.0.0.0.64

$ cd $INST_TOP/ora/10.1.3
$ pwd
/apps/ebs/inst/apps/TEST_hostname/ora/10.1.3

$ echo $ORACLE_HOME
/apps/ebs/apps/tech_st/10.1.2   ## it should be point to 10.1.3
$ ls -ltr
total 15
drwxr-xr-x   3 applmgr  oinstall    network
drwxr-xr-x   3 applmgr  oinstall    Apache
drwxr-xr-x   3 applmgr  oinstall    javacache
drwxr-xr-x   6 applmgr  oinstall    j2ee
drwxr-xr-x   2 applmgr  oinstall    deconfig
drwxr-xr-x   2 applmgr  oinstall    config
drwxr-xr-x   5 applmgr  oinstall    opmn
drwxr-xr-x   2 applmgr  oinstall    cfgtoollogs
drwx------   3 applmgr  oinstall    ccr
-rw-r--r--   1 applmgr  oinstall    TEST_hostname.env

$ . ./TEST_hostname.env

$ echo $ORACLE_HOME
/apps/ebs/apps/tech_st/10.1.3
$

Pre check as it is applied or not:
$ opatch lsinventory | grep 21845960  [Main Patch number which no need output]

$ opatch lsinventory | grep 21845942  [Sub-patches if applied should show in output, which we will check after applying the patches]

$ pwd
/apps/ebs/apps/tech_st/10.1.3/opatches/21845960

$ echo $ORACLE_HOME
/apps/ebs/apps/tech_st/10.1.3

$ echo $IAS_ORACLE_HOME
/apps/ebs/apps/tech_st/10.1.3
$ echo $TWO_TASK
TEST
$
As per readme.html these below path should be mentioned in $PATH
$ ls -ltr /usr/bin/ld
-r-xr-xr-x   1 root     bin        24688 Mar 24 10:29 /usr/bin/ld
$ ls -ld /usr/bin/ar
-r-xr-xr-x   1 root     bin        43904 Mar 24 10:29 /usr/bin/ar
$ ls -ld /usr/bin/nm
-r-xr-xr-x   1 root     bin        48128 Mar 24 10:30 /usr/bin/nm
$ ls -ld /usr/bin/make
-rwxr-xr-x   1 root     bin       212988 May 25  2017 /usr/bin/make
$
If it now included in PATH then need to export as below shown:

$ export PATH=$PATH:/usr/bin/ld:/usr/bin/ar:/usr/bin/nm:/usr/bin/make

$ echo $PATH
$ pwd
/apps/ebs/apps/tech_st/10.1.3/opatches/21845960
$ which opatch
/apps/ebs/apps/tech_st/10.1.3/OPatch/opatch
$ echo $ORACLE_HOME
/apps/ebs/apps/tech_st/10.1.3
$ echo $TWO_TASK
TEST
$ pwd
/apps/ebs/apps/tech_st/10.1.3/opatches/21845960
$ ls -ltr
total 70
drwxr-xr-x   4 applmgr  oinstall       5 Oct 13  2015 21845942
-rwxr-xr-x   1 applmgr  oinstall    2258 Oct 13  2015 remove_demo.sh
-rw-r--r--   1 applmgr  oinstall      67 Oct 13  2015 README.txt
drwxr-xr-x   5 applmgr  oinstall       7 Oct 13  2015 21815758
drwxr-xr-x   4 applmgr  oinstall       5 Oct 13  2015 9273888
drwxr-xr-x   5 applmgr  oinstall      10 Oct 13  2015 10011970
drwxr-xr-x   5 applmgr  oinstall       6 Oct 13  2015 10036362
drwxr-xr-x   5 applmgr  oinstall       6 Oct 13  2015 14123312
-rw-rw-r--   1 applmgr  oinstall   57215 Oct 19  2015 README.html
$
Check for Invalid Objects:

SQL> select object_name,object_type,owner from dba_objects where status='INVALID'
$ pwd
/apps/ebs/apps/tech_st/10.1.3/opatches/21845960
$opatch napply

Note: Here napply we are using for multiple patches to ally as shown above under the cpu patches there were many patches.

After that it will ask many times as Y/N, read once I always provided Y as shown below like:
Please respond Y|N > Y

Once OPatch succeeded Then check for applied or not as below command:
$opatch lsinventory | grep 21845942
  2) Patch  21845942 applied on Sun May 27 02:17:58 GMT-05:00 2018
      [ Bug fixes: 17232193 7215134 12434146 21845942 21843498 9173042 7457583 19647609 15930322 17232255 17988318 6406333 6855621 18272601 19952531 18855617 7576325 6768420 16264435 14003474 20034700 13564298 16021033 19288606 17232750 17250040 17643943 9481810 17664485 17631115 16802872 6768427 16193586 20900385 6032064 8806540 7632951 16021138 13564285 17664561 12434225 18746609 14251913 16802900 18272665 14110089 14010533 19947918 17329650 19319912 12959528 8800528 19320420  ]

$ opatch lsinventory | grep 21815758
  3) Patch  21815758 applied on Sun May 27 02:10:56 GMT-05:00 2018

$  opatch lsinventory | grep 9273888
  1) Patch  9273888 applied on Sun May 27 02:19:55 GMT-05:00 2018

      [ Bug fixes: 9273888  ]

$ opatch lsinventory | grep 10011970
  5) Patch  10011970 applied on Sun May 27 01:50:07 GMT-05:00 2018
      [ Bug fixes: 6912255 6790178 7428561 6433471 5397517 3645912 5724681 4473073 6682888 7157442 8416899 6080374 6471931 6912781 7552946 5453754 6018059 6150541 9336949 5999450 5740055 7021360 7335185 6713795 5477073 6134487 7196121 7430171 6080307 5259451 6655345 10011970 7146872 5697416 6024000 6153975 7353810 5932346 7519011 7195030 6844221 5979883 5486768 7127677 7229577 5985742 6852049 4635520 6917549 5871130 7004606 6237650 5573438 6681624 6772953 6816068 7574599 5763122 6526074 5902630 7113141  ]

$ opatch lsinventory | grep 10036362  [ There is no problem if not showing, during applying it will show as Opatch success just check alert log.]

$ opatch lsinventory | grep 14123312
  4) Patch  14123312 applied on Sun May 27 02:06:07 GMT-05:00 2018
      [ Bug fixes: 14123312  ]
$
Or

Note: After applying the above patch, please check the readme.html where is mentioned the Post steps.

Hope this may useful and helpful. Please let us know for any suggestions or correction in our either comment box or contact us @ora-data.blogspot.com

Some more useful links:





Regards,

14 comments:

  1. Thank you so much for sharing such informative content. I would love to suggest this Oracle dba

    ReplyDelete
  2. Some truly interesting details you have written.Helped me a lot,
    just what I was searching for :D.

    ReplyDelete
    Replies

    1. Dear User,

      Thank you for your feedback.

      Regards,
      ora-data Team

      Delete
  3. It is a very informative and useful post thanks it is good material to read this post increases my knowledge. Oracle dba

    ReplyDelete
    Replies

    1. Dear William Hurt,

      Thank you very much for your valuable words and feedback.
      I have visited your website looks great. All the best.

      Regards,
      ora-data Team

      Delete
  4. magnificent pоints aⅼtogether, you ѕimply wonn a new reader.

    Ꮤhat may you recomend in гegards to yor рublish thst you simply
    made a few days in the past? Any certain?

    ReplyDelete
  5. The general method is rather simple - by way of tying the curtain panel into a loose knot.
    If you understand the function of the lever and floater,
    it is possible to solve any running toilet in no time.
    The easiest, simplest and a lot effective way to handle
    situation is but one quick call towards the best Encinitas plumber a day a
    day.

    ReplyDelete
  6. A Safeway Construction will inspect and connect your chimneys for maximum performance.
    Before you start trying to find roofing companies CT to get a new
    roof, it is important that you initially call a repair contractor, as this professional
    can rule in and out the possibility of fixing the existent problems.
    As all of us are aware that there are different tile roofing according to
    the climate and geographical conditions.

    ReplyDelete
  7. I¡¦ve in recent times started off a web page,
    the details you offer on this internet site helps others vastly.
    Thanks a lot for each of your time period & get the job done.

    ReplyDelete
  8. I¡¦ve practice a a small number of suitable equipment right here.

    Well worth bookmarking with regard to revisiting.

    We big surprise ways a lot of time and effort you'd put
    for making this sort of remarkable informative site.

    ReplyDelete
  9. warm regards web site internet pages.

    ReplyDelete
  10. Heya i'm for the first time here. I came across this board and I find It really useful & it helped me out a lot.

    I hope to give something back and help others like you aided me.

    ReplyDelete
  11. Really a nice post for DBA's. This is very informative and step by step things . Thanks for such a wonderful blog.

    ReplyDelete

Thank you for your comments and suggestions. It's good to talk you.