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.
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,
