Oracle DBA Tips and Techniques

By Arjun Raja

Archive for April, 2013

“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>

Posted in EM Grid Control | Leave a Comment »

suspended on broken target error in 12c cloud control.

Posted by Arjun Raja on April 12, 2013

If you get this error while running jobs via cloud control on a particular database – “suspended on broken target” – this is the fix.

We just need to configure the target again – in case of this error.

No need to remove the target beforehand

simply click on targets/databases, choose the database and click configure – uses already saved dbsnmp password so simply click Next and proceed.

Run job again – it should go through.

Posted in Uncategorized | Leave a Comment »