em cloud control 12c 安装PSU

郑全 · 发表于 2020-2-3 20:34:12

1. Prerequisites
Before you install or deinstall the patch, ensure that you meet the following requirements:
Note:
In case of a multi-OMS environment, you need to perform steps 3 to 10 on each of the OMS hosts.
Steps 7 and 8 are applicable only during patch installation.
Ensure that the Oracle WebLogic Administration server that hosts the OMS is up and running.
Ensure that the Oracle Database, which houses the Management Repository and its Listener, is up and running.
Ensure that you have the latest version of OPatch 11.1 on all OMS instance platform homes.
To upgrade OPatch to the latest version available in My Oracle Support, refer to OPatch Upgrade Steps.
Ensure that you set the ORACLE_HOME environment variable to the Oracle Home of the core OMS, which is the <%MIDDLEWARE_HOME%>/oms.
Ensure that you set the PATH environment variable to include the location of the unzip executable, the <ORACLE_HOME>/bin, and the <ORACLE_HOME>/OPatch directories present in the Oracle Home of the OMS.
To use the OPatchauto functionality, you must set the WebLogic Administration Server credential access. To avoid setting the credentials every time, you can update the property file with the necessary information. To do so, refer to Creating a Property File.
Maintain a location for storing the contents of the patch ZIP file. In the rest of the document, this location (absolute path) is referred to as <PATCH_TOP_DIR>.
Extract the contents of the patch ZIP file to the location you created in Step (7). To do so, run the following command:
$ unzip -d <PATCH_TOP_DIR> p30592609_121050_Generic.zip
Run the following command on each OMS instance home to ensure that you do not have any issues with configuration and binary prerequisite checks:
$ cd <PATCH_TOP_DIR>/30592609
While Installing the System patch
$ opatchauto apply –analyze [–property_file <location of property file>]
While Deinstalling the System patch
$ opatchauto rollback -analyze -id 30592609 [-property_file <location of property file>]
Note:
The Analyze step does not install and deploy the patch. It just checks if the System patch can be installed. If the Analyze step fails on a Windows operating system, then check the log files to see if there is binary prerequisite failure due to checkActiveFilesAndExecutables.
For more information, refer to the guide for Patching Oracle Management Service available at: http://docs.oracle.com/cd/E24628 ... to_oms.htm#BABGGIHG
If any errors are reported by the opatchauto command, contact Oracle Support.
Ensure that you shut down the OMS by running the following command:
$emctl stop oms

2.Installing the System Patch
To install the patch, follow these steps:
Navigate to the <PATCH_TOP_DIR>/30592609 directory:
$ cd <PATCH_TOP_DIR>/30592609
Install the patch by running the following command:
On Unix:
$ opatchauto apply [–property_file <location of property file>]

3.确认
[oracle@dbserver 30592609]$ opatchauto lspatches
OPatch Automation Tool
Copyright (c) 2014, Oracle Corporation. All rights reserved.

Oracle Home:/u01/app/middle/oms
30592609;EMBP Patch Set Update 12.1.0.5.200114

The following groups of patch(es) are applied as System Patch bundle(s):
30592609
For more details on installed patch(es) in platform, plugin homes, Please do "/u01/app/middle/oms/OPatch/opatch lsinventory -details -oh <desired home path>".

4.Connect to Repository Database as SYS user and execute following steps:
Execute the SQL file <PATCH_TOP_DIR>/30592609/30592609/revoke_privilege.sql.
Execute the following ALTER statement: ALTER SESSION SET CURRENT_SCHEMA=SYSMAN_RO;
Execute the file: <ORACLE_HOME>/sysman/admin/emdrep/sql/core/latest/readonly/collections_meteval_ro_user_pkgbody.sql
where ORACLE_HOME is the Oracle Home of the core OMS.
Execute the following ALTER statement: ALTER SESSION SET CURRENT_SCHEMA=MGMT_VIEW;
Execute the file: <ORACLE_HOME>/sysman/admin/emdrep/sql/core/latest/collections/collections_meteval_view_user_pkgbody.sql
where ORACLE_HOME is the Oracle Home of the core OMS.
Note:
If revoke_privilege.sql has been executed as SYS user when the previous PSU Patch from 23087400 or 24316675 or 24897692 or 25387190 or 25904769 or 27336914 or 28026487 or 28595534 or 28970508 or 29433895 or 29835388 was applied, then there is no need to execute the script again.
Start the OMS by running the following command:
$ emctl start oms
Note:
In case of a multi-OMS environment, you must start all the OMSes.
Run the following command on all the emcli installations:
$ emcli sync

郑全 · 发表于 2020-2-3 20:35:05

附具体执行：
[oracle@dbserver 30592609]$ opatchauto apply
OPatch Automation Tool
Copyright (c) 2014, Oracle Corporation.  All rights reserved.

OPatchauto version : 11.1.0.12.9
OUI version       : 11.1.0.13.0
Running from    : /u01/app/middle/oms
Log file location  : /u01/app/middle/oms/cfgtoollogs/opatch/opatch2020-02-03_20-27-48PM_1.log
OPatchauto log file: /u01/app/middle/oms/cfgtoollogs/opatchauto/30592609/opatch_oms_2020-02-03_20-27-50PM_deploy.log
Please enter OMS weblogic admin server URL(t3s://dbserver.sztech.com:7102):>
Please enter OMS weblogic admin server username:> weblogic
Please enter OMS weblogic admin server password:>

Configuration Validation: Success

Running apply prerequisite checks for sub-patch(es) "30592609" and Oracle Home "/u01/app/middle/oms"...
Please monitor OPatch log file: /u01/app/middle/oms/cfgtoollogs/opatch/30592609_Feb_03_2020_20_27_48/ApplyPrereq2020-02-03_20-28-03PM_2.log
Sub-patch(es) "30592609" are successfully analyzed for Oracle Home "/u01/app/middle/oms"
To continue, OPatchauto will do the following:
[Patch and deploy artifacts] : Apply sub-patch(es) [ 30592609 ] to Oracle Home "/u01/app/middle/oms";
                              Apply RCU artifact with patch "/u01/app/middle/oms/.patch_storage/30592609_Jan_6_2020_09_12_32/original_patch";
                              Register MRS artifact "swlib";
                              Register MRS artifact "targetType";
                              Register MRS artifact "storeTargetType";
                              Register MRS artifact "default_collection"

Do you want to proceed? [y|n]
y
User Responded with: Y
Applying sub-patch "30592609" to Oracle Home "/u01/app/middle/oms"...
Please monitor OPatch log file: /u01/app/middle/oms/cfgtoollogs/opatch/30592609_Feb_03_2020_20_27_48/apply2020-02-03_20-28-09PM_4.log
Updating repository with RCU reference file "/u01/app/middle/oms/.patch_storage/30592609_Jan_6_2020_09_12_32/original_patch"
Registering service "swlib" with register file "/u01/app/middle/oms/sysman/metadata/swlib/patch"...
Registering service "targetType" with register file "/u01/app/middle/oms/sysman/metadata/targetType/oldVersions/host/12.1.0.4/host.xml"...
Registering service "storeTargetType" with register file "/u01/app/middle/oms/sysman/metadata/targetType/oldVersions/host/12.1.0.4/host.xml"...
Registering service "default_collection" with register file "/u01/app/middle/oms/sysman/metadata/default_collection/oldVersions/host/12.1.0.4/host.xml"...
Complete Summary
================

All log file names referenced below can be accessed from the directory "/u01/app/middle/oms/cfgtoollogs/opatch/2020-02-03_20-27-48PM_SystemPatch_30592609_1"
Patching summary:
-----------------
Binaries of the following sub-patch(es) have been applied successfully:
  Oracle Home Name Sub-patches                                  Log file
  ---------------- -----------                                  --------
         oms12c1    30592609 30592609_apply2020-02-03_20-28-09PM_4.log
Deployment summary:
-------------------
The following artifact(s) have been successfully deployed:
            Artifacts                                                    Log file
            ---------                                                    --------
                  SQL    rcu_applypatch_original_patch_2020-02-03_20-29-06PM.log
            MRS-swlib             emctl_register_swlib_2020-02-03_20-30-10PM.log
      MRS-targetType          emctl_register_targetType_2020-02-03_20-30-19PM.log
   MRS-storeTargetType    emctl_register_storeTargetType_2020-02-03_20-30-34PM.log
  MRS-default_collection emctl_register_default_collection_2020-02-03_20-30-39PM.log

Log file location: /u01/app/middle/oms/cfgtoollogs/opatchauto/30592609/opatch_oms_2020-02-03_20-27-50PM_deploy.log
OPatchauto succeeded.

郑全 · 发表于 2020-2-3 20:36:20

郑全发表于 2020-2-3 20:35
附具体执行：
[oracle@dbserver 30592609]$ opatchauto apply
OPatch Automation Tool

安装PSU后，
[oracle@dbserver 30592609]$ /u01/app/middle/oms/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 11.1.0.12.9
Copyright (c) 2020, Oracle Corporation.  All rights reserved.

Oracle Home    : /u01/app/middle/oms
Central Inventory : /u01/app/oraInventory
from          : /u01/app/middle/oms/oraInst.loc
OPatch version : 11.1.0.12.9
OUI version    : 11.1.0.13.0
Log file location : /u01/app/middle/oms/cfgtoollogs/opatch/opatch2020-02-03_18-18-11PM_1.log

OPatch detects the Middleware Home as "/u01/app/middle"
Lsinventory Output file location : /u01/app/middle/oms/cfgtoollogs/opatch/lsinv/lsinventory2020-02-03_18-18-11PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
EM Platform (OMS)                                                 12.1.0.5.0
There are 1 products installed in this Oracle Home.

Interim patches (1) :
Patch  30592609    : applied on Mon Feb 03 18:13:57 CST 2020
Unique Patch ID:  23291094
Patch description:  "EMBP Patch Set Update 12.1.0.5.200114"
Created on 6 Jan 2020, 09:12:32 hrs PST8PDT
Bugs fixed:
   23705752, 25219896, 21318948, 24953203, 21381700, 28595534, 18630800
   22029514, 30295734, 21462884, 24897692, 30295800, 30300408, 21094050
   30300505, 22782770, 27186708, 20515302, 21561441, 23338260, 30300452
   30295633, 22215321, 21762922, 29049300, 21164387, 26957222, 30300483
   20389704, 20952699, 28703948, 30295723, 20925913, 21984260, 23237869
   27829797, 22143858, 22757169, 20421152, 21836777, 21437683, 20827982
   22570344, 20438417, 21486051, 19645675, 21879760, 23205638, 16689505
   30300318, 20928434, 20861693, 22146782, 22494327, 22596695, 23743109
   30295648, 30300496, 25354849, 23087400, 19953061, 19194333, 29489025
   22685988, 20929261, 24753427, 20251039, 21865826, 30300515, 21477557
   22115901, 30300360, 20751948, 22324488, 19888665, 22636912, 22878048
   20369347, 23123399, 30300428, 19585130, 21894897, 30313332, 21358443
   30295654, 30300327, 27336914, 17603679, 21192416, 23336093, 30300308
   30295752, 28970508, 28026487, 21937908, 22287775, 30300473, 20537139
   20698566, 21393534, 30300416, 25121818, 30300392, 29746848, 20021966
   20836766, 21376507, 25904769, 21450977, 21496097, 29433895, 23215219
   20093530, 20592805, 20806405, 23627787, 18150714, 19586898, 30295772
   22648945, 22885947, 18553177, 30295671, 24380740, 25190630, 20672821
   25873874, 20850152, 21067380, 21912210, 21026842, 30592609, 27776754
   22928600, 20936744, 20983998, 21562961, 20616490, 27137831, 25341210
   25387190, 30295745, 20691151, 30295696, 21061986, 22109907, 22385361
   18411036, 26542313, 23229699, 21330117, 22210175, 22045521, 21967458
   21151030, 21106415, 21120551, 30300524, 30300531, 23288798, 21510150
   22762681, 22561957, 22728457, 22815942, 30295728, 21429472, 20985421
   24342949, 29835388, 30300491, 30295664, 21956911, 30295755, 21355200
   28695777, 18391707, 22312019, 25615522, 22845575, 21227822, 21495795
   21850038, 20985360, 20623344, 30295787, 23147274, 21093418, 21692727
   23287847, 21938820, 18418209, 21171255, 19193857, 30295737, 23146068
   24316675, 21229490, 20781757, 25701178, 22983809, 21242727, 22708832, 21427005

--------------------------------------------------------------------------------
OPatch succeeded.

郑全 · 发表于 2020-2-3 20:40:29

郑全发表于 2020-2-3 20:36
安装PSU后，
[oracle@dbserver 30592609]$ /u01/app/middle/oms/OPatch/opatch lsinventory
Oracle Int ...

执行脚本：

[oracle@dbserver 30592609]$ . oraenv
ORACLE_SID = [orcl] ? emrep
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 is /u01/app/oracle
[oracle@dbserver 30592609]$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Mon Feb 3 20:36:52 2020
Copyright (c) 1982, 2014, Oracle.  All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> show parameter db_name
NAME                               TYPE       VALUE
------------------------------------ ----------- ------------------------------
db_name                            string    emrep

SQL> @/u01/setup/omspsu/30592609/30592609/revoke_privilege.sql
Revoke succeeded.
SQL> ALTER SESSION SET CURRENT_SCHEMA=SYSMAN_RO;
Session altered.
SQL> @/u01/app/middle/oms/sysman/admin/emdrep/sql/core/latest/readonly/collections_meteval_ro_user_pkgbody.sql
Package body created.
No errors.
SQL> ALTER SESSION SET CURRENT_SCHEMA=MGMT_VIEW;
Session altered.
SQL> @/u01/app/middle/oms/sysman/admin/emdrep/sql/core/latest/collections/collections_meteval_view_user_pkgbody.sql
Package body created.
No errors.
SQL> exit

帐号		自动登录	找回密码
密码			注册