Oracle DBA Tips and Techniques

By Arjun Raja

“ENTERPRISE MANAGER BASE PLATFORM – OMS 12.1.0.2.2 PSU (GENERIC)” PATCH INSTALLATION

Posted by Arjun Raja on April 26, 2013

Installation of PSU path for OMS Cloud Control to upgrade OMS from  12.1.0.2.0 to 12.1.0.2.2

Download patch from My Oracle Support and unzip it in staging area on OMS server.

p16236221_121020_Generic.zip

emrep:/u01/oracle/Middleware/oms/OPatch> echo $ORACLE_HOME
/u01/oracle/Middleware/oms

emrep:/u01/oracle/Middleware/oms/OPatch> which opatch
/u01/oracle/Middleware/oms/OPatch/opatch

emrep:/u01/oracle/Middleware/oms/OPatch> which unzip
/u01/oracle/Middleware/oms/bin/unzip

emrep:/u01/oracle/Middleware/oms/OPatch> opatch lsinventory
Oracle Interim Patch Installer version 11.1.0.9.8
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/oracle/Middleware/oms
Central Inventory : /u01/oracle/oraInventory
from           : /u01/oracle/Middleware/oms/oraInst.loc
OPatch version    : 11.1.0.9.8
OUI version       : 11.1.0.9.0
Log file location : /u01/oracle/Middleware/oms/cfgtoollogs/opatch/opatch2013-04-26_07-57-22AM_1.log

OPatch detects the Middleware Home as “/u01/oracle/Middleware”

Lsinventory Output file location : /u01/oracle/Middleware/oms/cfgtoollogs/opatch/lsinv/lsinventory2013-04-26_07-57-22AM.txt

——————————————————————————–
Installed Top-level Products (1):

EM Platform (OMS)                                                    12.1.0.2.0
There are 1 products installed in this Oracle Home.

Interim patches (3) :

Patch  14149721     : applied on Thu Dec 06 09:39:16 WST 2012
Unique Patch ID:  15496341
Created on 20 Sep 2012, 07:18:10 hrs PST8PDT
Bugs fixed:
14149721

Patch  13983293     : applied on Fri Nov 23 08:32:41 WST 2012
Unique Patch ID:  14779750
Created on 25 Apr 2012, 02:18:06 hrs PST8PDT
Bugs fixed:
13587457, 13425845, 11822929

Patch  12742388     : applied on Fri Nov 23 08:32:39 WST 2012
Unique Patch ID:  13995252
Created on 3 Aug 2011, 03:35:00 hrs US/Pacific
Bugs fixed:
12742388

——————————————————————————–

OPatch succeeded.
emrep:/u01/oracle/Middleware/oms/OPatch>

cd /u01/oracle/stage/omspatch/16236221

(Prerequisite Only for Patch Installation) Ensure that the PSU does not conflict with the already-installed one-off patches. To do so, run the following command to generate a report that lists all conflicting patches.

cd /u01/oracle/stage/omspatch/16236221>

opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/oracle/stage/omspatch/16236221

Oracle Interim Patch Installer version 11.1.0.9.8
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/oracle/Middleware/oms
Central Inventory : /u01/oracle/oraInventory
from           : /u01/oracle/Middleware/oms/oraInst.loc
OPatch version    : 11.1.0.9.8
OUI version       : 11.1.0.9.0
Log file location : /u01/oracle/Middleware/oms/cfgtoollogs/opatch/opatch2013-04-26_07-59-29AM_1.log

OPatch detects the Middleware Home as “/u01/oracle/Middleware”

Invoking prereq “checkconflictagainstohwithdetail”

Prereq “checkConflictAgainstOHWithDetail” passed.

OPatch succeeded.
emrep:/u01/oracle/stage/omspatch/16236221>

emrep:/u01/oracle> cd $ORACLE_HOME/bin

emrep:/u01/oracle/Middleware/oms/bin> ./emctl stop oms
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
Stopping WebTier…
WebTier Successfully Stopped
Stopping Oracle Management Server…
Oracle Management Server Successfully Stopped
Oracle Management Server is Down

APPLY PATCH

cd /u01/oracle/stage/omspatch/16236221

opatch lsinventory

emrep:/u01/oracle/stage/omspatch/16236221> opatch apply
Oracle Interim Patch Installer version 11.1.0.9.8
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/oracle/Middleware/oms
Central Inventory : /u01/oracle/oraInventory
from           : /u01/oracle/Middleware/oms/oraInst.loc
OPatch version    : 11.1.0.9.8
OUI version       : 11.1.0.9.0
Log file location : /u01/oracle/Middleware/oms/cfgtoollogs/opatch/16236221_Apr_26_2013_08_35_36/apply2013-04-26_08-35-36AM_1.log

OPatch detects the Middleware Home as “/u01/oracle/Middleware”

Applying interim patch ‘16236221’ to OH ‘/u01/oracle/Middleware/oms’
Verifying environment and performing prerequisite checks…
All checks passed.
Backing up files…
Patching component oracle.sysman.oms.core, 12.1.0.2.0…
Verifying the update…
Patch 16236221 successfully applied
Log file location: /u01/oracle/Middleware/oms/cfgtoollogs/opatch/16236221_Apr_26_2013_08_35_36/apply2013-04-26_08-35-36AM_1.log

OPatch succeeded.
emrep:/u01/oracle/stage/omspatch/16236221>

emrep:/u01/oracle/stage/omspatch/16236221> opatch lsinventory
Oracle Interim Patch Installer version 11.1.0.9.8
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/oracle/Middleware/oms
Central Inventory : /u01/oracle/oraInventory
from           : /u01/oracle/Middleware/oms/oraInst.loc
OPatch version    : 11.1.0.9.8
OUI version       : 11.1.0.9.0
Log file location : /u01/oracle/Middleware/oms/cfgtoollogs/opatch/opatch2013-04-26_08-38-44AM_1.log

OPatch detects the Middleware Home as “/u01/oracle/Middleware”

Lsinventory Output file location : /u01/oracle/Middleware/oms/cfgtoollogs/opatch/lsinv/lsinventory2013-04-26_08-38-44AM.txt

——————————————————————————–
Installed Top-level Products (1):

EM Platform (OMS)                                                    12.1.0.2.0
There are 1 products installed in this Oracle Home.

Interim patches (4) :

Patch  16236221     : applied on Fri Apr 26 08:37:58 WST 2013
Unique Patch ID:  16246314
Patch description:  “ENTERPRISE MANAGER BASE PLATFORM – OMS 12.1.0.2.2 PSU (GENERIC)”
Created on 4 Apr 2013, 04:37:26 hrs PST8PDT
Bugs fixed:
16249001, 15882400, 16050320, 14550814, 14763575, 14761108, 14845582
14541496, 14342208, 15845393, 14666763, 14580616, 14598372, 14735169
14010647, 14345046, 10096491, 14749579, 14838874, 14587300, 15830769
14804073, 14235923, 16195634, 14299157, 15872430, 14306214, 14762857
13079372, 14727947, 14285253, 14687246, 13508023, 14745153, 16036046
15887936, 14495973, 14304836, 14336237, 16173939, 14630733, 14594247
14833587, 14508416, 14526341, 14394014, 15890511, 14521115, 14728398
14096173, 13849711, 14557951, 14846905, 14377038, 14794550, 14788062
14588625, 13894390, 14355479, 14408052, 14461107, 14786608, 14335511
14563656, 14519924, 14709740, 13564862, 14756522, 13923303, 14208766
16201338, 15943462, 14315126, 14685375, 14672991, 14646978, 15897575
14623310, 16295882, 15962488, 14777653, 14385641, 16236221, 14480859
14812404, 14568969, 13038747, 14636925, 14685307, 14559710, 14791371
14463440, 14351499, 10367113, 14270937, 14473422, 14763683, 14543562
14691873, 14475316, 14695367, 14697257, 14585884, 14544587, 14594990
14763611, 16194290, 15875808, 14693191, 14807598, 15955206, 13588621
14807230, 14562085, 14032756, 14357531, 14508734, 14258259, 14473509
14520274, 14769075, 14728061, 16384695, 14527469, 14776583, 14793497
16060571, 14673451, 14397242, 14761661, 14360903, 15939396, 14681479
10422783, 14326585, 14293602, 14586919, 14651399, 16399409, 14693204
14571497, 14485604, 14791323, 14693208, 14763632, 14235906, 16162621
13891094, 14729169, 14477373, 14356241, 16007962, 14582201, 14708698
14795109, 14681848, 14767273, 15964986, 14683668, 15861782, 14840279
15859144, 14775943, 14673182, 14182184, 14604267, 14571792

Patch  14149721     : applied on Thu Dec 06 09:39:16 WST 2012
Unique Patch ID:  15496341
Created on 20 Sep 2012, 07:18:10 hrs PST8PDT
Bugs fixed:
14149721

Patch  13983293     : applied on Fri Nov 23 08:32:41 WST 2012
Unique Patch ID:  14779750
Created on 25 Apr 2012, 02:18:06 hrs PST8PDT
Bugs fixed:
13587457, 13425845, 11822929

Patch  12742388     : applied on Fri Nov 23 08:32:39 WST 2012
Unique Patch ID:  13995252
Created on 3 Aug 2011, 03:35:00 hrs US/Pacific
Bugs fixed:
12742388

——————————————————————————–

OPatch succeeded.
emrep:/u01/oracle/stage/omspatch/16236221>

emrep:/u01/oracle/stage/omspatch/16236221> sh ./post_deploy.sh

Post deploy OMS automation script [Version: 11.1.0.9.9, Build date: November 12, 2012]
_______________________________________________________________________________________

Please enter Patch Location: /u01/oracle/stage/omspatch/16236221/
Please enter SYSMAN password:

The script will run the following command(s):

/u01/oracle/Middleware/oms/bin/emctl applypatch repos -patchHome /u01/oracle/stage/omspatch/16236221/
/u01/oracle/Middleware/oms/bin/emctl register oms metadata -service namedsql -file /u01/oracle/Middleware/oms/sysman/metadata/namedsql/loader_report_sql.xml -core
/u01/oracle/Middleware/oms/bin/emctl register oms metadata  -service report -file /u01/oracle/Middleware/oms/sysman/metadata/reports/Loader_Statistic.xml -core
/u01/oracle/Middleware/oms/bin/emctl register oms metadata -service swlib -file /u01/oracle/Middleware/oms/sysman/metadata/swlib/multioms -core
/u01/oracle/Middleware/oms/bin/emctl register oms metadata -service swlib -file /u01/oracle/Middleware/oms/sysman/metadata/swlib/patch -core

Please monitor log file “/u01/oracle/stage/omspatch/16236221/log/2013-04-26-08-47-52.log”…

Script completed successfully.
emrep:/u01/oracle/stage/omspatch/16236221>

Script completed successfully.
emrep:/u01/oracle/stage/omspatch/16236221> cd $ORACLE_HOME/bin
emrep:/u01/oracle/Middleware/oms/bin> ./emctl start oms
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
Starting Oracle Management Server…
Starting WebTier…
WebTier Successfully Started
Oracle Management Server Successfully Started
Oracle Management Server is Up
emrep:/u01/oracle/Middleware/oms/bin>

Finally  emcli sync.

emrep:/u01/oracle/Middleware/oms/bin> emcli sync
Error: Session expired. Run emcli login to establish a session.
emrep:/u01/oracle/Middleware/oms/bin> emcli login -username=sysman -password=xxxxxxxxx
Login successful
emrep:/u01/oracle/Middleware/oms/bin> emcli sync
Synchronized successfully
emrep:/u01/oracle/Middleware/oms/bin>

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: