pat98's always & forever

마찬가지로 10g도 해당 URL 따라가도 10년이상 지난 버전이라 다운 받을수 없다. 개별 화일은 전부 개인적으로 소장중..

download 시 구분용으로 기록해 놓는다.

Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86

http://download.oracle.com/otn/linux/oracle10g/10201/10201_database_linux32.zip
http://download.oracle.com/otn/linux/oracle10g/10201/10201_client_linux32.zip

http://download.oracle.com/otn/linux/oracle10g/10201/10201_clusterware_linux32.zip
http://download.oracle.com/otn/linux/oracle10g/10201/10201_gateways_linux32.zip

Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86-64

http://download.oracle.com/otn/linux/oracle10g/10201/10201_database_linux_x86_64.cpio.gz
http://download.oracle.com/otn/linux/oracle10g/10201/10201_client_linux_x86_64.cpio.gz
http://download.oracle.com/otn/linux/oracle10g/10201/10201_clusterware_linux_x86_64.cpio.gz
http://download.oracle.com/otn/linux/oracle10g/10201/10201_gateways_linux_x86_64.cpio.gz

Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)

http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_client_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_clusterware_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_gateways_win32.zip

Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (x64)

http://download.oracle.com/otn/nt/oracle10g/10201/102010_win64_x64_database.zip
http://download.oracle.com/otn/nt/oracle10g/10201/102010_win64_x64_client.zip
http://download.oracle.com/otn/nt/oracle10g/10201/102010_win64_x64_clusterware.zip

win7 64-bit 인 경우

http://download.oracle.com/otn/nt/oracle10g/10204/10204_vista_w2k8_x64_production_db.zip

Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for AIX5L

http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_database.cpio.gz
http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_client.cpio.gz
http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_cluster.cpio.gz
http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_gateways.cpio.gz

Oracle Database 10g Release 2 (10.2.0.2) Enterprise/Standard Edition for Solaris Operating System (x86)

http://download.oracle.com/otn/solaris/oracle10g/10202/10202_database_solx86.zip
http://download.oracle.com/otn/solaris/oracle10g/10202/10202_client_solx86.zip
http://download.oracle.com/otn/solaris/oracle10g/10202/10202_clusterware_solx86.zip

Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Solaris Operating System (x86-64)

http://download.oracle.com/otn/solaris/oracle10g/10201/x8664/10201_database_solx86_64.zip
http://download.oracle.com/otn/solaris/oracle10g/10201/x8664/10201_client_solx86_64.zip
http://download.oracle.com/otn/solaris/oracle10g/10201/x8664/10201_clusterware_solx86_64.zip

패치작업 19.15.0.0.220419 (GI PSU 33803476)

Database Patch Set Update : 19.15.0.0.220419 (33806152)
OCW Patch Set Update      : 19.15.0.0.220419 (33815596)
ACFS Patch Set Update     : 19.15.0.0.220419 (33815607)
Tomcat Release Update     : 19.0.0.0.0       (33911149)
DBWLM Release Update      : 19.0.0.0.0       (33575402)

Oracle Grid Infrastructure Patch Set Update 19.15.0.0.220419 
-------------------------------------
GI_HOME, ORACLE_HOME 을 개별로 각각 할때

- grid 유저
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/33803476/33806152
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/33803476/33815596
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/33803476/33815607
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/33803476/33575402
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/33803476/33911149

- oracle 유저
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/33803476/33806152
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/33803476/33815596

(oracle)
$ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location> -n <node name>

(root 유저)
export GI_HOME=/u01/app/19.3.0.0/grid
$GI_HOME/crs/install/rootcrs.sh -prepatch 

(grid 유저)
export GI_HOME=/u01/app/19.3.0.0/grid
cd /u01/install
$GI_HOME/OPatch/opatch apply -oh $GI_HOME -local ./33803476/33815596 -silent
$GI_HOME/OPatch/opatch apply -oh $GI_HOME -local ./33803476/33815607 -silent
$GI_HOME/OPatch/opatch apply -oh $GI_HOME -local ./33803476/33806152 -silent
$GI_HOME/OPatch/opatch apply -oh $GI_HOME -local ./33803476/33575402 -silent
$GI_HOME/OPatch/opatch apply -oh $GI_HOME -local ./33803476/33911149 -silent

(oracle 유저)
export ORACLE_HOME=/u01/app/oracle/product/19.3.0.0/dbhome_1
cd /u01/install
./33803476/33815596/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./33803476/33815596 -silent
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./33803476/33806152 -silent
./33803476/33815596/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME 

(root 유저)
export GI_HOME=/u01/app/19.3.0.0/grid
$GI_HOME/rdbms/install/rootadd_rdbms.sh
$GI_HOME/crs/install/rootcrs.sh -postpatch 

(oracle)
$ <ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location> -n <node name> 

- Loading Modified SQL Files into the Database
sqlplus /nolog
SQL> conect / as sysdba
SQL> startup
SQL> quit
cd $ORACLE_HOME/OPatch
./datapatch -verbose

### [롤백하는 경우] ###########

(oracle)
$ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location> -n <node name>

GI Home
(root로)
$GI_HOME/crs/install/rootcrs.sh -prepatch -rollback

(grid 유저로)
export GI_HOME=/u01/app/19.3.0.0/grid
cd /u01/install
$GI_HOME/OPatch/opatch nrollback -local -id 33815596,33815607,33806152,33575402,33911149 -oh $GI_HOME -silent

(oracle 유저로)
export ORACLE_HOME=/u01/app/oracle/product/19.3.0.0/dbhome_1
cd /u01/install
./33803476/33815596/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME 
$ORACLE_HOME/OPatch/opatch nrollback -local -id 33815596,33806152 -oh /u01/app/oracle/product/19.3.0.0/dbhome_1 -silent
./33803476/33815596/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME

Run post script
(root로)
export GI_HOME=/u01/app/19.3.0.0/grid
$GI_HOME/rdbms/install/rootadd_rdbms.sh
$GI_HOME/crs/install/rootcrs.sh -postpatch -rollback

(oracle)
$ <ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location> -n <node name>

sqlplus /nolog
SQL> conect / as sysdba
SQL> startup
SQL> quit
cd $ORACLE_HOME/OPatch
./datapatch -verbose

Reconfiguring & Recreating The 11gR2/12cR1 Restart/OHAS/SIHA Stack Configuration (Standalone) / How to Reconfigure Oracle Restart (Doc ID 1422517.1)

테스트 환경은 19.3

Oracle Restart (Single ASM환경) 는 deconfig 시 -keepdg 옵션이 없기 때문에 deconfig 해도 재구성시 Diskgroup 정상적으로 물고 올라오는지 
확인하기 위해 테스트 함.

해당문서상의 ./roothas.pl 명령어는 오래되서 업데이트가 안된건지 12c 이상이므로 ./roothas.sh 로 바꾸어서 실행해야 한다.

- 현재 상태

[TEST]oracle@singleasm:/home/oracle# crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       singleasm                STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       singleasm                STABLE
ora.asm
               ONLINE  ONLINE       singleasm                Started,STABLE
ora.ons
               OFFLINE OFFLINE      singleasm                STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssdex
      1        ONLINE  ONLINE       singleasm                STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       singleasm                STABLE
ora.test.db
      1        ONLINE  ONLINE       singleasm                Open,HOME=/u01/app/o
                                                             racle/product/19.3.0
                                                             .0/dbhome_1,STABLE

우선 Reconfigure 작업전 기본 필요정보는 백업을 받아 놓도록 한다.

1. ASM pfile 
show parameter pfile
+DATA/ASM/ASMPARAMETERFILE/registry.253.1101819307

cd/u01/app/19.3.0.0/grid/dbs
sqlplus "/as sysasm"
create pfile from spfile;


2.Database pfile 
show parameter pfile
+DATA/TEST/PARAMETERFILE/spfile.266.1101821921

cd /u01/app/oracle/product/19.3.0.0/dbhome_1/dbs
sqlplus "/as sysdba"
create pfile from spfile;


root@singleasm:/u01/app/19.3.0.0/grid/crs/install# ./roothas.sh -deconfig -force
Using configuration parameter file: /u01/app/19.3.0.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/oracle/crsdata/singleasm/crsconfig/hadeconfig.log
2022/04/15 16:07:14 CLSRSC-332: CRS resources for listeners are still configured
2022/04/15 16:07:29 CLSRSC-337: Successfully deconfigured Oracle Restart stack

root@singleasm:/u01/app/19.3.0.0/grid/crs/install# ./roothas.sh
Using configuration parameter file: /u01/app/19.3.0.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/oracle/crsdata/singleasm/crsconfig/roothas_2022-04-15_03-25-10PM.log
2022/04/15 15:25:12 CLSRSC-363: User ignored prerequisites during installation
LOCAL ADD MODE 
Creating OCR keys for user 'oracle', privgrp 'dba'..
Operation successful.
LOCAL ONLY MODE 
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node singleasm successfully pinned.
2022/04/15 15:25:19 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'

singleasm     2022/04/15 15:26:15     /u01/app/oracle/crsdata/singleasm/olr/backup_20220415_152615.olr     724960844     
2022/04/15 15:26:16 CLSRSC-327: Successfully configured Oracle Restart for a standalone server

재구성이 되면 Resource 를 확인한다.

--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ons
               OFFLINE OFFLINE      singleasm                STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        OFFLINE OFFLINE                               STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  INTERMEDIATE singleasm                STABLE
--------------------------------------------------------------------------------

- cssd 를 기동시켜 준다. (cssd는 AUTO_START 기본속성이 never 이다)
root@singleasm:/u01/app/19.3.0.0/grid/bin#./crsctl start resource "ora.cssd" -unsupported

- ASM 을 start 한다.
srvctl add asm -spfile +DATA/ASM/ASMPARAMETERFILE/registry.253.1101819307
srvctl start asm

- ASM 인스턴스로 접속해서 Diskgroup 을 마운트 해준다.

[TEST]oracle@singleasm:/home/oracle# . oraenv
ORACLE_SID = [TEST] ? +ASM
ORACLE_HOME = [/home/oracle] ? /u01/app/19.3.0.0/grid
The Oracle base remains unchanged with value /u01/app/oracle

SQL> alter diskgroup DATA mount;
Diskgroup altered.

- 자동으로 Start 안되어 있을 경우 Diskgroup 기동
srvctl start diskgroup -diskgroup DATA

srvctl add database -d TEST -oraclehome /u01/app/oracle/product/19.3.0.0/dbhome_1
srvctl start database -d TEST

srvctl add listener -l LISTENER -endpoints "TCP:1521" -oraclehome /u01/app/19.3.0.0/grid
srvctl start listener

- 정상 구성됨을 최종적으로 확인
[+ASM]oracle@singleasm:/home/oracle# crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       singleasm                STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       singleasm                STABLE
ora.asm
               ONLINE  ONLINE       singleasm                Started,STABLE
ora.ons
               OFFLINE OFFLINE      singleasm                STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       singleasm                STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       singleasm                STABLE
ora.test.db
      1        ONLINE  ONLINE       singleasm                Open,HOME=/u01/app/o
                                                             racle/product/19.3.0
                                                             .0/dbhome_1,STABLE
--------------------------------------------------------------------------------

- 테스트 끝!!

(테스트 환경은 Single ASM 19.3)

Oracle Restart 환경(Single ASM)에서 정상적으로 설치했음에도 ORACLE_HOME 의 Inventory 정보가 제대로 들어가지 않는 경우가 있다. 

이 경우에 opatch lsinventory 정보를 확인하면 경로를 못 찾아서 해당 에러가 발생함.

[TEST]oracle@singleasm:/home/oracle# opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2022, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/19.3.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.3.0.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0.0/dbhome_1/cfgtoollogs/opatch/opatch2022-04-15_14-12-38PM_1.log

List of Homes on this system:

  Home name= OraGI19Home1, Location= "/u01/app/19.3.0.0/grid"
LsInventorySession failed: RawInventory gets null OracleHomeInfo

OPatch failed with error code 73

- 확인해 보면 GRID 는 있으나 ORACLE_HOME 경로가 없음..

[TEST]oracle@singleasm:/u01/app/oraInventory/ContentsXML# cat inventory.xml
<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 1999, 2022, Oracle and/or its affiliates.
All rights reserved. -->
<!-- Do not modify the contents of this file by hand. -->
<INVENTORY>
<VERSION_INFO>
   <SAVED_WITH>12.2.0.7.0</SAVED_WITH>
   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME="OraGI19Home1" LOC="/u01/app/19.3.0.0/grid" TYPE="O" IDX="1" CRS="true"/>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>

- 조치방법은 단순히 ORACLE_HOME 를 attach 해주기만 하면 됨.

[TEST]oracle@singleasm:/u01/app/oracle/product/19.3.0.0/dbhome_1/oui/bin# ./attachHome.sh
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 8191 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
You can find the log of this install session at:
 /u01/app/oraInventory/logs/AttachHome2022-04-15_02-35-37PM.log
'AttachHome' was successful.

- 다시 확인해 보면 ORACLE_HOME 정보가 들어가 있다.

root@singleasm:/u01/app/oraInventory/ContentsXML# vi inventory.xml
<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 1999, 2022, Oracle and/or its affiliates.
All rights reserved. -->
<!-- Do not modify the contents of this file by hand. -->
<INVENTORY>
<VERSION_INFO>
   <SAVED_WITH>12.2.0.7.0</SAVED_WITH>
   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME="OraGI19Home1" LOC="/u01/app/19.3.0.0/grid" TYPE="O" IDX="1" CRS="true"/>
<HOME NAME="OraDB19Home1" LOC="/u01/app/oracle/product/19.3.0.0/dbhome_1" TYPE="O" IDX="2"/>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>

- Inventory 정보도 정상적으로 조회된다.

[TEST]oracle@singleasm:/home/oracle# opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2022, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/19.3.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.3.0.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0.0/dbhome_1/cfgtoollogs/opatch/opatch2022-04-15_14-36-52PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/19.3.0.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2022-04-15_14-36-52PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: singleasm
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1): 

Oracle Database 19c                                                  19.0.0.0.0
There are 1 products installed in this Oracle Home.
Interim patches (2) :

Patch  29585399     : applied on Thu Apr 18 16:21:33 KST 2019
Unique Patch ID:  22840393
Patch description:  "OCW RELEASE UPDATE 19.3.0.0.0 (29585399)"
   Created on 9 Apr 2019, 19:12:47 hrs PST8PDT
   Bugs fixed:
     27222128, 27572040, 27604329, 27760043, 27877830, 28302580, 28470673
     28621543, 28642469, 28699321, 28710663, 28755846, 28772816, 28785321
     28800508, 28808652, 28815557, 28847541, 28847572, 28870496, 28871040
     28874416, 28877252, 28881191, 28881848, 28888083, 28911140, 28925250
     28925460, 28935956, 28940472, 3, 28942694, 28951332, 28963036, 28968779
     28980448, 28995287, 29003207, 29003617, 29016294, 29018680, 29024876
     29026154, 29027933, 29047127, 29052850, 29058476, 29111631, 29112455
     29117337, 29123444, 29125708, 29125786, 29129476, 29131772, 29132456
     29139727, 29146157, 29147849, 29149170, 29152603, 29152752, 29154631
     29154636, 29154829, 29159216, 29159661, 29160462, 29161923, 29169540
     29169739, 29170717, 29173618, 29181568, 29182920, 29183298, 29186091
     29191827, 29201143, 29201695, 29209545, 29210577, 29210610, 29210624
     29210683, 29213641, 29219627, 29224294, 29225861, 29229839, 29235934
     29242906, 29243749, 29244495, 29244766, 29244968, 29248723, 29249583
     29251564, 29255616, 29260224, 29261695, 29271019, 29273360, 29282090
     29282666, 29285453, 29285621, 29290235, 29292232, 29293806, 29294753
     29299830, 29307090, 29307109, 29311336, 29329675, 29330791, 29339299
     29357821, 29360467, 29360775, 29367971, 29368725, 29379299, 29379381
     29380527, 29381000, 29382296, 29391301, 29393649, 29402110, 29411931
     29413360, 29457319, 29465047

Patch  29517242     : applied on Thu Apr 18 16:21:17 KST 2019
Unique Patch ID:  22862832
Patch description:  "Database Release Update : 19.3.0.0.190416 (29517242)"
   Created on 17 Apr 2019, 23:27:10 hrs PST8PDT
   Bugs fixed:
     29515240, 14735102, 19697993, 20313356, 21965541, 25806201, 25883179
     25986062, 26476244, 26611353, 26872233, 27369515, 27423500, 27666312
     27710072, 27846298, 27957203, 28064977, 28072567, 28129791, 28181021
     28210681, 28279456, 28313275, 28350595, 28371123, 28379065, 28431445
     28463226, 28489419, 28502773, 28513333, 28534475, 28561704, 28569897
     28572533, 28572544, 28587723, 28593682, 28594086, 28597221, 28601957
     28605066, 28606598, 28625862, 28627033, 28636532, 28643718, 28644549
     28645570, 28646200, 28646939, 28649388, 28655209, 28663782, 28673945
     28692275, 28694872, 28696373, 28705231, 28710385, 28710734, 28714461
     28718469, 28730079, 28740708, 28760206, 28772390, 28774416, 28777214
     28789531, 28791852, 28795551, 28802734, 28804517, 28810381, 28811560
     28815123, 28815355, 28819640, 28824482, 28833912, 28835937, 28862532
     28863432, 28873575, 28876253, 28876639, 28884931, 28888327, 28892794
     28897512, 28899663, 28901126, 28905457, 28907196, 28912691, 28915561
     28917080, 28918429, 28919145, 28922227, 28922532, 28922608, 28925634
     28925880, 28933158, 28936114, 28937717, 28938698, 28940179, 28940281
     28941901, 28942455, 28945421, 28945994, 28951533, 28952168, 28954762
     28955606, 28957292, 28957723, 28962775, 28965231, 28966444, 28974083
     28977322, 28983095, 28983486, 28986326, 28986481, 28988482, 28989306
     28993295, 28994307, 28996376, 29000000, 29001888, 29002927, 29003738
     29006318, 29006621, 29007321, 29007775, 29008035, 29011936, 29013475
     29014076, 29015118, 29017265, 29018655, 29019121, 29021063, 29021352
     29024552, 29026582, 29026606, 29027456, 29027694, 29027940, 29031575
     29031600, 29032234, 29032457, 29032607, 29033052, 29033145, 29033200
     29033280, 29034587, 29037290, 29038528, 29039089, 29039510, 29043554
     29043651, 29043725, 29044763, 29044954, 29047850, 29048289, 29048498
     29048605, 29050560, 29050765, 29051702, 29052726, 29053783, 29056024
     29056270, 29056560, 29059011, 29061959, 29062692, 29062848, 29062860
     29062868, 29110526, 29110783, 29110790, 29110797, 29110802, 29110805
     29111598, 29113282, 29113305, 29117526, 29117642, 29119077, 29120223
     29122224, 29122254, 29123297, 29123432, 29123482, 29124368, 29125380
     29126345, 29127957, 29128935, 29129450, 29129497, 29129712, 29130219
     29131539, 29132938, 29134447, 29136111, 29138641, 29141316, 29141341
     29141685, 29142667, 29144995, 29145214, 29145730, 29149829, 29150338
     29151520, 29152357, 29155099, 29157389, 29158680, 29158899, 29159909
     29159936, 29160174, 29162095, 29163415, 29163437, 29163524, 29163567
     29167111, 29167342, 29167374, 29167940, 29168219, 29168433, 29169073
     29169215, 29171942, 29172618, 29172826, 29173140, 29173373, 29173817
     29174004, 29176318, 29177466, 29177543, 29177886, 29178385, 29180313
     29180455, 29180559, 29180893, 29181153, 29181231, 29181620, 29181743
     29181923, 29182019, 29183912, 29184297, 29184666, 29185193, 29186456
     29189302, 29189307, 29189889, 29190235, 29190474, 29190740, 29191541
     29192419, 29192468, 29192685, 29193207, 29194205, 29194367, 29194493
     29194827, 29195279, 29195337, 29195758, 29196725, 29199635, 29199733
     29200316, 29200700, 29201494, 29201539, 29202104, 29202850, 29203122
     29203166, 29203425, 29203443, 29203604, 29205281, 29205323, 29205419
     29205463, 29205767, 29205918, 29206109, 29206605, 29207073, 29208260
     29208732, 29211457, 29211724, 29212012, 29212433, 29212611, 29213351
     29213775, 29213850, 29213879, 29214561, 29214960, 29216746, 29216984
     29217294, 29217472, 29217828, 29217848, 29218570, 29219205, 29219273
     29220079, 29221248, 29221891, 29222031, 29222784, 29223833, 29223859
     29223967, 29224065, 29224605, 29225076, 29227602, 29228869, 29229164
     29229754, 29229844, 29229955, 29230252, 29230565, 29231133, 29232117
     29232154, 29234123, 29237538, 29240307, 29241345, 29242017, 29242884
     29243958, 29245137, 29245160, 29246163, 29247415, 29247712, 29247906
     29248552, 29248835, 29248858, 29249991, 29250059, 29251259, 29253184
     29253871, 29254031, 29254930, 29255178, 29255273, 29255431, 29255435
     29256426, 29259119, 29259320, 29261906, 29262512, 29262887, 29265448
     29266248, 29266899, 29267292, 29268412, 29269171, 29270585, 29273539
     29273735, 29273847, 29274428, 29274564, 29274627, 29275461, 29278218
     29279658, 29279751, 29279854, 29282898, 29285503, 29285788, 29285956
     29286037, 29287130, 29287705, 29292837, 29293072, 29297863, 29297915
     29298220, 29299049, 29299082, 29299844, 29301566, 29302963, 29303918
     29304781, 29311588, 29312310, 29312734, 29312753, 29313347, 29313417
     29313525, 29314539, 29318410, 29319441, 29321489, 29323946, 29324568
     29325087, 29325105, 29325257, 29325993, 29327044, 29329087, 29331209
     29331380, 29331493, 29332771, 29333500, 29337310, 29338315, 29338453
     29338780, 29338913, 29339155, 29341209, 29343086, 29346943, 29347620
     29348176, 29350052, 29351386, 29351716, 29351749, 29352867, 29353271
     29355654, 29356547, 29356752, 29358828, 29360672, 29361801, 29363151
     29364171, 29364177, 29367019, 29367561, 29368253, 29373418, 29373588
     29374179, 29377986, 29378029, 29379978, 29382784, 29385652, 29386502
     29386635, 29386660, 29387274, 29388094, 29388524, 29388830, 29389889
     29390435, 29394140, 29394749, 29397954, 29398863, 29399100, 29399121
     29405012, 29405651, 29412066, 29412269, 29417884, 29423826, 29429264
     29429566, 29431485, 29435652, 29438736, 29439522, 29450421, 29451386
     29452576, 29452953, 29457807, 29460252, 29462957, 29486181, 29507616
     29521748, 29530812, 29531654, 29557336, 29558975, 29601461
--------------------------------------------------------------------------------
OPatch succeeded.

TCPS 프로토콜 사용 설정 테스트

테스트 환경 19.10

=== 서버쪽 설정====== (RAC 인 경우는 각 노드에서 모두 수행하여야 한다. 1번꺼 복사가 아님..)

1. autologin 설정 및 인증서 export (autologin은 이미 설정되어 있으면 생략가능)
orapki wallet create -wallet /u01/app/oracle/admin/TEST/wallet/ -auto_login -pwd "welcome1"

orapki wallet add -wallet /u01/app/oracle/admin/TEST/wallet -dn 'CN=root_test_CA,C=US' -keysize 2048 -self_signed -validity 3650 -pwd "welcome1"

orapki wallet export -wallet  /u01/app/oracle/admin/TEST/wallet/ -dn 'CN=root_test_CA,C=US' -cert /u01/app/oracle/admin/TEST/wallet/root_test_CA.cert

chmod 660 /u01/app/oracle/admin/TEST/wallet/cwallet.sso
chmod 660 /u01/app/oracle/admin/TEST/wallet/ewallet.p12

(oracle)
orapki wallet display -wallet /u01/app/oracle/admin/TEST/wallet/
keytool -printcert -file /u01/app/oracle/admin/TEST/wallet/root_test_CA.cert


2. Listener 설정

GI_HOME listener.ora

WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/u01/app/oracle/admin/TEST/wallet)))
SSL_CLIENT_AUTHENTICATION = FALSE

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCPS)(HOST = 192.168.56.92)(PORT = 4521))
      )
    )
  )

- GI_HOME 에 sqlnet.ora
WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/u01/app/oracle/admin/TEST/wallet)))
SSL_CLIENT_AUTHENTICATION = FALSE

- ORACLE_HOME 에 sqlnet.ora
WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/u01/app/oracle/admin/TEST/wallet)))
SSL_CLIENT_AUTHENTICATION = FALSE

3. listener 재기동

srvctl stop listener
srvctl start listener

[+ASM1]oracle@rac1:/home/oracle# lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 17-AUG-2021 22:06:41

Copyright (c) 1991, 2020, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                17-AUG-2021 22:06:18
Uptime                    0 days 0 hr. 0 min. 22 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/19.3.0.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/rac1/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=192.168.56.92)(PORT=4521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.90)(PORT=3521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.92)(PORT=3521)))
Services Summary...
Service "TEST" has 1 instance(s).
  Instance "TEST1", status READY, has 1 handler(s) for this service...
Service "TESTXDB" has 1 instance(s).
  Instance "TEST1", status READY, has 1 handler(s) for this service...
The command completed successfully

=== 클라이언트쪽 설정======
1. wallet 디렉토리 생성
/home/oracle/wallet_client

2. 인증서를 해당 위치에 복사 후 권한 변경
[root@ora19c wallet_client]# chmod 600 root_test_CA.cert
[root@ora19c wallet_client]# chown oracle:dba root_test_CA.cert

3. wallet 생성 및 Import 
orapki wallet create -wallet /home/oracle/wallet_client -auto_login -pwd "welcome1"
orapki wallet add -wallet /home/oracle/wallet_client -trusted_cert -cert /home/oracle/wallet_client/root_test_CA.cert -pwd "welcome1"

[TEST]oracle@ora19c:/home/oracle/wallet_client# ls -al
total 12
drwxr-xr-x  2 oracle dba  115 Aug 17 22:20 .
drwx------. 9 oracle dba  279 Aug 17 22:14 ..
-rw-------  1 oracle dba 1021 Aug 17 22:21 cwallet.sso
-rw-------  1 oracle dba    0 Aug 17 22:20 cwallet.sso.lck
-rw-------  1 oracle dba  976 Aug 17 22:21 ewallet.p12
-rw-------  1 oracle dba    0 Aug 17 22:20 ewallet.p12.lck
-rw-------  1 oracle dba 1029 Aug 17 22:17 root_test_CA.cert

4. sqlnet.ora 화일 구성
WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/home/oracle/wallet_client)))

5. tnsnamess.ora
TCPS =
    (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCPS)(HOST = 192.168.56.92)(PORT = 4521))
        (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = TEST)
        )
    )
 
 === 클라이언트에서 연결 테스트!! ========
vi  /oracle/app/oracle/product/19.0.0/network/admin/tnsnames.ora
 
 TCPS =
    (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCPS)(HOST = 192.168.56.92)(PORT = 4521))
        (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = TEST)
        )
    )
 
 tnsping TCPS
 
 Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCPS)(HOST = 192.168.56.92)(PORT = 4521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = TEST)))
OK (50 msec)
     
sqlplus system/welcome1@TCPS
 
[TEST]oracle@ora19c:/oracle/app/oracle/product/19.0.0/network/admin# sqlplus system/welcome1@TCPS

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Aug 17 23:57:02 2021
Version 19.12.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.

Last Successful login time: Tue Aug 17 2021 23:50:27 +09:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0

SQL> SELECT SYS_CONTEXT('USERENV', 'network_protocol') FROM DUAL;

SYS_CONTEXT('USERENV','NETWORK_PROTOCOL')
--------------------------------------------------------------------------------
tcps

ORA-28864: SSL connection closed gracefully



=======================================================

srvctl modify listener -endpoints "TCP:3521/TCPS:4521"

alter system set local_listener='(ADDRESS = (PROTOCOL=TCP)(HOST=192.168.56.92)(PORT = 3521)','(ADDRESS = (PROTOCOL=TCPS)(HOST=192.168.56.92)(PORT = 4521))' scope=both;

alter system set local_listener='(ADDRESS = (PROTOCOL=TCP)(HOST=192.168.56.93)(PORT = 3521)','(ADDRESS = (PROTOCOL=TCPS)(HOST=192.168.56.93)(PORT = 4521))' scope=both;

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.92)(PORT = 3521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER))
      (ADDRESS = (PROTOCOL = TCPS)(HOST =192.168.56.92)(PORT = 4521))
    )
  )

SECURE_REGISTER_LISTENER = (IPC,TCPS)

SQL> SELECT SYS_CONTEXT('USERENV', 'network_protocol') FROM DUAL;

 

Enterprise Manager 13.5.0.0 -> 13.5.0.4 로 Oracle Management Service 패치작업 테스트

준비물
p33715883_135000_Generic,zip (1066M) (13.5.0.4)
p19999993_135000_Generic.zip (856K) (13.9.5.2.0)

1. 현재  omspatch 버전 확인
[oracle:/u01/app/Middleware/OMSPatcher]#./omspatcher version
OMSPatcher Version: 13.9.4.4.0
OPlan Version: 12.2.0.1.16
OsysModel build: Tue Apr 28 18:16:31 PDT 2020

OMSPatcher succeeded.

2. download 한 화일을 압축해제
cd /u01/app/Middleware
unzip p19999993_135000_Generic.zip

[oracle:/u01/app/Middleware/OMSPatcher]#./omspatcher version
OMSPatcher Version: 13.9.5.2.0
OPlan Version: 12.2.0.1.16
OsysModel build: Tue Apr 28 18:16:31 PDT 2020

OMSPatcher succeeded.

cd /u01/install/p33715883_135000_Generic.zip
unzip p33715883_135000_Generic.zip

3. ORACLE_HOME을 OMS_HOME 의 위치로 바꾸어 주고 패치 적용
export ORACLE_HOME=/u01/app/Middleware
cd /u01/install/33715883
/u01/app/Middleware/OMSPatcher/omspatcher apply /u01/install/33715883

4. 전부 다 내리는게 아니다. oms 만 내리고 작업한다. (weblogic admin server 는 기동되어 있어야 함)

   Repository DB, Listener 도 기동한 상태에서 진행..

   서버사양이 안 좋을수록 작업시간은 더 오래걸린다..Mem 16G인데 대략 1시간 정도 소요된 듯..

[oracle:/u01/install/33715883]#emctl stop oms
Oracle Enterprise Manager Cloud Control 13c Release 5  
Copyright (c) 1996, 2021 Oracle Corporation.  All rights reserved.
Stopping Oracle Management Server...
Oracle Management Server Successfully Stopped
Oracle Management Server is Down
JVMD Engine is Down

[oracle:/u01/install/33715883]#omspatcher apply .
OMSPatcher Automation Tool
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


OMSPatcher version : 13.9.5.2.0
OUI version        : 13.9.4.0.0
Running from       : /u01/app/Middleware
Log file location  : /u01/app/Middleware/cfgtoollogs/omspatcher/opatch2022-03-21_14-29-35PM_1.log

OMSPatcher log file: /u01/app/Middleware/cfgtoollogs/omspatcher/33715883/omspatcher_2022-03-21_14-29-37PM_deploy.log

Please enter OMS weblogic admin server URL(t3s://em13c:7102):> 엔터
Please enter OMS weblogic admin server username(weblogic):> 엔터
Please enter OMS weblogic admin server password:> 암호입력

Enter SYS Password : 암호입력
Checking if current repository database is a supported version
Current repository database version is supported


Prereq "checkComponents" for patch 33567409 passed.
Prereq "checkComponents" for patch 33567476 passed.
Prereq "checkComponents" for patch 33567462 passed.
Prereq "checkComponents" for patch 33567414 passed.
Prereq "checkComponents" for patch 33567421 passed.
Prereq "checkComponents" for patch 33567450 passed.
Configuration Validation: Success


Running apply prerequisite checks for sub-patch(es) "33567421,33567409,33567476,33567462,33567414,33567450" and Oracle Home "/u01/app/Middleware"...
Sub-patch(es) "33567421,33567409,33567476,33567462,33567414,33567450" are successfully analyzed for Oracle Home "/u01/app/Middleware"

To continue, OMSPatcher will do the following:
[Patch and deploy artifacts]   : Apply sub-patch(es) [ 33567409 33567414 33567421 33567450 33567462 33567476 ]
                                 Apply RCU artifact with patch "/u01/app/Middleware/.omspatcher_storage/33567409_Jan_27_2022_23_33_59/original_patch";
                                 Apply RCU artifact with patch "/u01/app/Middleware/.omspatcher_storage/33567476_Jan_27_2022_23_45_08/original_patch";
                                 Apply RCU artifact with patch "/u01/app/Middleware/.omspatcher_storage/33567462_Jan_27_2022_23_45_35/original_patch";
                                 Apply RCU artifact with patch "/u01/app/Middleware/.omspatcher_storage/33567414_Jan_27_2022_23_45_53/original_patch";
                                 Apply RCU artifact with patch "/u01/app/Middleware/.omspatcher_storage/33567421_Jan_27_2022_23_46_35/original_patch";
                                 Apply RCU artifact with patch "/u01/app/Middleware/.omspatcher_storage/33567450_Jan_27_2022_23_47_17/original_patch";
                                 Register MRS artifact "commands";
                                 Register MRS artifact "targetType";
                                 Register MRS artifact "storeTargetType";
                                 Register MRS artifact "default_collection";
                                 Register MRS artifact "omsPropertyDef";
                                 Register MRS artifact "jobTypes";
                                 Register MRS artifact "SecurityClassManager";
                                 Register MRS artifact "swlib";
                                 Register MRS artifact "procedures";
                                 Register MRS artifact "systemStencil";
                                 Register MRS artifact "discovery";
                                 Register MRS artifact "gccompliance";
                                 Register MRS artifact "EcmMetadataOnlyRegistration";
                                 Register MRS artifact "CredstoreMetadata";
                                 Register MRS artifact "namedQuery";
                                 Register MRS artifact "eventSpecificCustmzn";
                                 Register MRS artifact "derivedAssocs"


Do you want to proceed? [y|n]
y
User Responded with: Y
Stopping the OMS.....
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/stop_oms_2022-03-21_14-33-29PM.log


Applying sub-patch(es) "33567409,33567414,33567421,33567450,33567462,33567476"
Please monitor log file: /u01/app/Middleware/cfgtoollogs/opatch/opatch2022-03-21_14-30-07PM_1.log


Updating repository with RCU reference file "/u01/app/Middleware/.omspatcher_storage/33567409_Jan_27_2022_23_33_59/original_patch"

Updating repository with RCU reference file "/u01/app/Middleware/.omspatcher_storage/33567476_Jan_27_2022_23_45_08/original_patch" for plugin home "/u01/app/Middleware/plugins/oracle.sysman.cfw.oms.plugin_13.5.1.0.0"

Updating repository with RCU reference file "/u01/app/Middleware/.omspatcher_storage/33567462_Jan_27_2022_23_45_35/original_patch" for plugin home "/u01/app/Middleware/plugins/oracle.sysman.si.oms.plugin_13.5.1.0.0"

Updating repository with RCU reference file "/u01/app/Middleware/.omspatcher_storage/33567414_Jan_27_2022_23_45_53/original_patch" for plugin home "/u01/app/Middleware/plugins/oracle.sysman.emas.oms.plugin_13.5.1.0.0"

Updating repository with RCU reference file "/u01/app/Middleware/.omspatcher_storage/33567421_Jan_27_2022_23_46_35/original_patch" for plugin home "/u01/app/Middleware/plugins/oracle.sysman.db.oms.plugin_13.5.1.0.0"

Updating repository with RCU reference file "/u01/app/Middleware/.omspatcher_storage/33567450_Jan_27_2022_23_47_17/original_patch" for plugin home "/u01/app/Middleware/plugins/oracle.sysman.xa.oms.plugin_13.5.1.0.0"

Registering service "commands" with register file "/u01/app/Middleware/sysman/metadata/commands/CScommand.xml" for plugin id as "core"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_commands_2022-03-21_14-42-58PM.log


Registering service "commands" with register file "/u01/app/Middleware/plugins/oracle.sysman.db.oms.plugin_13.5.1.0.0/metadata/commands/commands.xml" for plugin id as "oracle.sysman.db"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_commands_2022-03-21_14-43-04PM.log


Registering service "commands" with register file "/u01/app/Middleware/plugins/oracle.sysman.xa.oms.plugin_13.5.1.0.0/metadata/commands/commands.xml" for plugin id as "oracle.sysman.xa"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_commands_2022-03-21_14-43-11PM.log


Registering service "targetType" with register file "/u01/app/Middleware/sysman/metadata/targetType/oracle_emd.xml" for plugin id as "core"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_targetType_2022-03-21_14-43-18PM.log


Registering service "targetType" with register file "/u01/app/Middleware/plugins/oracle.sysman.si.oms.plugin_13.5.1.0.0/patched_metadata/13.5.1.0.0/targetType/33567462/network_hw/oracle_si_netswitch.xml" for plugin id as "oracle.sysman.si"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_targetType_2022-03-21_14-44-02PM.log


Registering service "targetType" with register file "/u01/app/Middleware/plugins/oracle.sysman.si.oms.plugin_13.5.1.0.0/patched_metadata/13.5.1.0.0/targetType/33567462/network_hw/oracle_ib/oracle_si_switch_oracle_ib_snmp.xml" for plugin id as "oracle.sysman.si"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_targetType_2022-03-21_14-44-27PM.log


Registering service "targetType" with register file "/u01/app/Middleware/plugins/oracle.sysman.emas.oms.plugin_13.5.1.0.0/patched_metadata/13.5.1.0.0/targetType/32971629/websphere_j2eeserver.xml" for plugin id as "oracle.sysman.emas"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_targetType_2022-03-21_14-44-36PM.log


Registering service "targetType" with register file "/u01/app/Middleware/plugins/oracle.sysman.db.oms.plugin_13.5.1.0.0/patched_metadata/13.5.1.0.0/targetType/32835412/oracle_cloud_atp.xml" for plugin id as "oracle.sysman.db"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_targetType_2022-03-21_14-44-48PM.log


Registering service "storeTargetType" with register file "/u01/app/Middleware/sysman/metadata/targetType/oracle_emd.xml" for plugin id as "core"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_storeTargetType_2022-03-21_14-49-30PM.log


Registering service "storeTargetType" with register file "/u01/app/Middleware/plugins/oracle.sysman.si.oms.plugin_13.5.1.0.0/patched_metadata/13.5.1.0.0/targetType/33567462/network_hw/oracle_si_netswitch.xml" for plugin id as "oracle.sysman.si"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_storeTargetType_2022-03-21_14-49-41PM.log


Registering service "storeTargetType" with register file "/u01/app/Middleware/plugins/oracle.sysman.emas.oms.plugin_13.5.1.0.0/patched_metadata/13.5.1.0.0/targetType/33567414/oracle_end_user_service.xml" for plugin id as "oracle.sysman.emas"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_storeTargetType_2022-03-21_14-49-52PM.log


Registering service "storeTargetType" with register file "/u01/app/Middleware/plugins/oracle.sysman.db.oms.plugin_13.5.1.0.0/patched_metadata/13.5.1.0.0/targetType/32971644/osm_instance.xml" for plugin id as "oracle.sysman.db"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_storeTargetType_2022-03-21_14-49-59PM.log


Registering service "default_collection" with register file "/u01/app/Middleware/sysman/metadata/default_collection/oldVersions/oracle_emrep/13.5.0.v/13.5.0.2/oracle_emrep.xml" for plugin id as "core"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_default_collection_2022-03-21_14-50-10PM.log


Registering service "default_collection" with register file "/u01/app/Middleware/plugins/oracle.sysman.si.oms.plugin_13.5.1.0.0/patched_metadata/13.5.1.0.0/default_collection/33567462/network_hw/oracle_si_netswitch.xml" for plugin id as "oracle.sysman.si"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_default_collection_2022-03-21_14-50-33PM.log


Registering service "default_collection" with register file "/u01/app/Middleware/plugins/oracle.sysman.emas.oms.plugin_13.5.1.0.0/patched_metadata/13.5.1.0.0/default_collection/32971629/websphere_j2eeserver.xml" for plugin id as "oracle.sysman.emas"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_default_collection_2022-03-21_14-50-53PM.log


Registering service "default_collection" with register file "/u01/app/Middleware/plugins/oracle.sysman.db.oms.plugin_13.5.1.0.0/patched_metadata/13.5.1.0.0/default_collection/32971644/oracle_pdb.xml" for plugin id as "oracle.sysman.db"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_default_collection_2022-03-21_14-51-03PM.log


Registering service "omsPropertyDef" with register file "/u01/app/Middleware/sysman/metadata/omsProperties/definition/NotificationOMSPropDefinition.xml" for plugin id as "core"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_omsPropertyDef_2022-03-21_14-52-09PM.log


Registering service "omsPropertyDef" with register file "/u01/app/Middleware/plugins/oracle.sysman.db.oms.plugin_13.5.1.0.0/metadata/omsProperties/definition/DBPropDefinition.xml" for plugin id as "oracle.sysman.db"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_omsPropertyDef_2022-03-21_14-52-17PM.log


Registering service "jobTypes" with register file "/u01/app/Middleware/sysman/metadata/jobTypes/core/patch/aru/UpdateARUTables.xml" for plugin id as "core"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_jobTypes_2022-03-21_14-52-25PM.log


Registering service "jobTypes" with register file "/u01/app/Middleware/plugins/oracle.sysman.emas.oms.plugin_13.5.1.0.0/metadata/jobTypes/internalsdk/FusionMiddlewareProcessControl.xml" for plugin id as "oracle.sysman.emas"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_jobTypes_2022-03-21_14-52-36PM.log


Registering service "jobTypes" with register file "/u01/app/Middleware/plugins/oracle.sysman.db.oms.plugin_13.5.1.0.0/metadata/jobTypes/GEFTransferWorker.xml" for plugin id as "oracle.sysman.db"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_jobTypes_2022-03-21_14-52-43PM.log


Registering service "jobTypes" with register file "/u01/app/Middleware/plugins/oracle.sysman.db.oms.plugin_13.5.1.0.0/metadata/jobTypes/GEFTransfer.xml" for plugin id as "oracle.sysman.db"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_jobTypes_2022-03-21_14-52-57PM.log


Registering service "jobTypes" with register file "/u01/app/Middleware/plugins/oracle.sysman.xa.oms.plugin_13.5.1.0.0/metadata/jobTypes/ExadataWarehouseMetering.xml" for plugin id as "oracle.sysman.xa"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_jobTypes_2022-03-21_14-53-03PM.log


Registering service "SecurityClassManager" with register file "/u01/app/Middleware/sysman/metadata/security/SecurityClass/uifwk_dashboard_security_class.xml" for plugin id as "core"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_SecurityClassManager_2022-03-21_14-53-09PM.log


Registering service "swlib" with register file "/u01/app/Middleware/sysman/metadata/swlib/analytics" for plugin id as "core"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_swlib_2022-03-21_14-53-16PM.log


Registering service "swlib" with register file "/u01/app/Middleware/plugins/oracle.sysman.emas.oms.plugin_13.5.1.0.0/metadata/swlib/siteguard" for plugin id as "oracle.sysman.emas"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_swlib_2022-03-21_14-53-26PM.log


Registering service "swlib" with register file "/u01/app/Middleware/plugins/oracle.sysman.db.oms.plugin_13.5.1.0.0/metadata/swlib/common" for plugin id as "oracle.sysman.db"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_swlib_2022-03-21_14-53-35PM.log


Registering service "swlib" with register file "/u01/app/Middleware/plugins/oracle.sysman.xa.oms.plugin_13.5.1.0.0/metadata/swlib/analytics" for plugin id as "oracle.sysman.xa"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_swlib_2022-03-21_14-53-51PM.log


Registering service "procedures" with register file "/u01/app/Middleware/plugins/oracle.sysman.cfw.oms.plugin_13.5.1.0.0/metadata/procedures/CfwHostProvisioningDP.xml" for plugin id as "oracle.sysman.cfw"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_procedures_2022-03-21_14-53-58PM.log


Registering service "procedures" with register file "/u01/app/Middleware/plugins/oracle.sysman.db.oms.plugin_13.5.1.0.0/metadata/procedures/CloudDataMigration.xml" for plugin id as "oracle.sysman.db"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_procedures_2022-03-21_14-54-05PM.log


Registering service "procedures" with register file "/u01/app/Middleware/plugins/oracle.sysman.xa.oms.plugin_13.5.1.0.0/metadata/procedures/Convert12cto13cDatabaseMachinePreRequisiteCheck.xml" for plugin id as "oracle.sysman.xa"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_procedures_2022-03-21_14-54-20PM.log


Registering service "systemStencil" with register file "/u01/app/Middleware/sysman/builtinplugins/oracle.sysman.emrep/metadata/systemStencil/omsSystemStencil.xml" for plugin id as "core"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_systemStencil_2022-03-21_14-54-28PM.log


Registering service "systemStencil" with register file "/u01/app/Middleware/plugins/oracle.sysman.db.oms.plugin_13.5.1.0.0/patched_metadata/13.5.1.0.0/systemStencil/32835412/rac_database.xml" for plugin id as "oracle.sysman.db"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_systemStencil_2022-03-21_14-54-35PM.log


Registering service "discovery" with register file "/u01/app/Middleware/plugins/oracle.sysman.si.oms.plugin_13.5.1.0.0/metadata/discovery/plugin_discovery.xml" for plugin id as "oracle.sysman.si"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_discovery_2022-03-21_14-54-42PM.log


Registering service "discovery" with register file "/u01/app/Middleware/plugins/oracle.sysman.db.oms.plugin_13.5.1.0.0/metadata/discovery/db_discovery.xml" for plugin id as "oracle.sysman.db"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_discovery_2022-03-21_14-54-47PM.log


Registering service "gccompliance" with register file "/u01/app/Middleware/plugins/oracle.sysman.db.oms.plugin_13.5.1.0.0/metadata/gccompliance/exachkComplianceContent.xml" for plugin id as "oracle.sysman.db"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_gccompliance_2022-03-21_14-54-55PM.log


Registering service "EcmMetadataOnlyRegistration" with register file "/u01/app/Middleware/plugins/oracle.sysman.si.oms.plugin_13.5.1.0.0/metadata/snapshot/network_hw/arista/oracle_si_switch_arista_ssh_ecmdef.xml" for plugin id as "oracle.sysman.si"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_EcmMetadataOnlyRegistration_2022-03-21_14-56-21PM.log


Registering service "EcmMetadataOnlyRegistration" with register file "/u01/app/Middleware/plugins/oracle.sysman.db.oms.plugin_13.5.1.0.0/metadata/snapshot/pdb_init_params_config_ecm_metadata.xml" for plugin id as "oracle.sysman.db"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_EcmMetadataOnlyRegistration_2022-03-21_14-56-30PM.log


Registering service "CredstoreMetadata" with register file "/u01/app/Middleware/sysman/metadata/security/CredstoreMetadata/jsonWebKeysCredstore.xml" for plugin id as "core"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_CredstoreMetadata_2022-03-21_14-56-38PM.log


Registering service "CredstoreMetadata" with register file "/u01/app/Middleware/plugins/oracle.sysman.xa.oms.plugin_13.5.1.0.0/metadata/security/CredstoreMetadata/ExadataWarehouseStripe.xml" for plugin id as "oracle.sysman.xa"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_CredstoreMetadata_2022-03-21_14-56-44PM.log


Registering service "namedQuery" with register file "/u01/app/Middleware/sysman/metadata/namedQuery/dashboards_named_query.xml" for plugin id as "core"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_namedQuery_2022-03-21_14-56-50PM.log


Registering service "eventSpecificCustmzn" with register file "/u01/app/Middleware/plugins/oracle.sysman.emas.oms.plugin_13.5.1.0.0/metadata/events/custmzn/metric_alert_oracle_end_user_service.xml" for plugin id as "oracle.sysman.emas"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_eventSpecificCustmzn_2022-03-21_14-56-56PM.log


Registering service "derivedAssocs" with register file "/u01/app/Middleware/plugins/oracle.sysman.db.oms.plugin_13.5.1.0.0/metadata/derivedAssocs/dg_assoc_rules.xml" for plugin id as "oracle.sysman.db"...
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-33-29PM_SystemPatch_33715883_9/emctl_register_derivedAssocs_2022-03-21_14-57-03PM.log

The job_queue_processes parameter is set to 0 in the repository database. Resetting the job_queue_processes parameter to default value 50 in the repository database to start the OMS. If 50 is not your default value for the job_queue_processes parameter, you should reset it to the preferred value post OMS patching.
Starting the oms
Please monitor log file: /u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-57-20PM_SystemPatch_33715883_63/start_oms_2022-03-21_14-57-20PM.log


Complete Summary
================


All log file names referenced below can be accessed from the directory "/u01/app/Middleware/cfgtoollogs/omspatcher/2022-03-21_14-57-20PM_SystemPatch_33715883_63"

Patching summary:
-----------------

Binaries of the following sub-patch(es) have been applied successfully:

                        Featureset                                             Sub-patches                                                                                  Log file
                        ----------                                             -----------                                                                                  --------
  oracle.sysman.top.oms_13.5.0.0.0   33567409,33567414,33567421,33567450,33567462,33567476   33567409,33567414,33567421,33567450,33567462,33567476_opatch2022-03-21_14-30-07PM_1.log


The following sub-patches are incompatible with components installed in the OMS system:
33424187,33567457,32972412,33567429,33567433,33567441,33567426,33567454,33567469

Deployment summary:
-------------------

The following artifact(s) have been successfully deployed:

                        Artifacts                                                               Log file
                        ---------                                                               --------
                              SQL                rcu_applypatch_original_patch_2022-03-21_14-37-04PM.log
                              SQL                rcu_applypatch_original_patch_2022-03-21_14-40-39PM.log
                              SQL                rcu_applypatch_original_patch_2022-03-21_14-41-07PM.log
                              SQL                rcu_applypatch_original_patch_2022-03-21_14-41-30PM.log
                              SQL                rcu_applypatch_original_patch_2022-03-21_14-42-00PM.log
                              SQL                rcu_applypatch_original_patch_2022-03-21_14-42-33PM.log
                     MRS-commands                      emctl_register_commands_2022-03-21_14-42-58PM.log
                     MRS-commands                      emctl_register_commands_2022-03-21_14-43-04PM.log
                     MRS-commands                      emctl_register_commands_2022-03-21_14-43-11PM.log
                   MRS-targetType                    emctl_register_targetType_2022-03-21_14-43-18PM.log
                   MRS-targetType                    emctl_register_targetType_2022-03-21_14-44-02PM.log
                   MRS-targetType                    emctl_register_targetType_2022-03-21_14-44-27PM.log
                   MRS-targetType                    emctl_register_targetType_2022-03-21_14-44-36PM.log
                   MRS-targetType                    emctl_register_targetType_2022-03-21_14-44-48PM.log
              MRS-storeTargetType               emctl_register_storeTargetType_2022-03-21_14-49-30PM.log
              MRS-storeTargetType               emctl_register_storeTargetType_2022-03-21_14-49-41PM.log
              MRS-storeTargetType               emctl_register_storeTargetType_2022-03-21_14-49-52PM.log
              MRS-storeTargetType               emctl_register_storeTargetType_2022-03-21_14-49-59PM.log
           MRS-default_collection            emctl_register_default_collection_2022-03-21_14-50-10PM.log
           MRS-default_collection            emctl_register_default_collection_2022-03-21_14-50-33PM.log
           MRS-default_collection            emctl_register_default_collection_2022-03-21_14-50-53PM.log
           MRS-default_collection            emctl_register_default_collection_2022-03-21_14-51-03PM.log
               MRS-omsPropertyDef                emctl_register_omsPropertyDef_2022-03-21_14-52-09PM.log
               MRS-omsPropertyDef                emctl_register_omsPropertyDef_2022-03-21_14-52-17PM.log
                     MRS-jobTypes                      emctl_register_jobTypes_2022-03-21_14-52-25PM.log
                     MRS-jobTypes                      emctl_register_jobTypes_2022-03-21_14-52-36PM.log
                     MRS-jobTypes                      emctl_register_jobTypes_2022-03-21_14-52-43PM.log
                     MRS-jobTypes                      emctl_register_jobTypes_2022-03-21_14-52-57PM.log
                     MRS-jobTypes                      emctl_register_jobTypes_2022-03-21_14-53-03PM.log
         MRS-SecurityClassManager          emctl_register_SecurityClassManager_2022-03-21_14-53-09PM.log
                        MRS-swlib                         emctl_register_swlib_2022-03-21_14-53-16PM.log
                        MRS-swlib                         emctl_register_swlib_2022-03-21_14-53-26PM.log
                        MRS-swlib                         emctl_register_swlib_2022-03-21_14-53-35PM.log
                        MRS-swlib                         emctl_register_swlib_2022-03-21_14-53-51PM.log
                   MRS-procedures                    emctl_register_procedures_2022-03-21_14-53-58PM.log
                   MRS-procedures                    emctl_register_procedures_2022-03-21_14-54-05PM.log
                   MRS-procedures                    emctl_register_procedures_2022-03-21_14-54-20PM.log
                MRS-systemStencil                 emctl_register_systemStencil_2022-03-21_14-54-28PM.log
                MRS-systemStencil                 emctl_register_systemStencil_2022-03-21_14-54-35PM.log
                    MRS-discovery                     emctl_register_discovery_2022-03-21_14-54-42PM.log
                    MRS-discovery                     emctl_register_discovery_2022-03-21_14-54-47PM.log
                 MRS-gccompliance                  emctl_register_gccompliance_2022-03-21_14-54-55PM.log
  MRS-EcmMetadataOnlyRegistration   emctl_register_EcmMetadataOnlyRegistration_2022-03-21_14-56-21PM.log
  MRS-EcmMetadataOnlyRegistration   emctl_register_EcmMetadataOnlyRegistration_2022-03-21_14-56-30PM.log
            MRS-CredstoreMetadata             emctl_register_CredstoreMetadata_2022-03-21_14-56-38PM.log
            MRS-CredstoreMetadata             emctl_register_CredstoreMetadata_2022-03-21_14-56-44PM.log
                   MRS-namedQuery                    emctl_register_namedQuery_2022-03-21_14-56-50PM.log
         MRS-eventSpecificCustmzn          emctl_register_eventSpecificCustmzn_2022-03-21_14-56-56PM.log
                MRS-derivedAssocs                 emctl_register_derivedAssocs_2022-03-21_14-57-03PM.log


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
The following patches could not be applied during OPatch execution:
**********************************************************************************
  Patch               Reason
*********           *********
33424187    The Plugin or Core Component "oracle.sysman.smf.oms.plugin with version 13.5.1.0.0" for which the patch is intended is not deployed in your Enterprise Manager system.
33567457    The Plugin or Core Component "oracle.sysman.vt.oms.plugin with version 13.5.1.0.0" for which the patch is intended is not deployed in your Enterprise Manager system.
32972412    The Plugin or Core Component "oracle.sysman.empa.oms.plugin with version 13.5.1.0.0" for which the patch is intended is not deployed in your Enterprise Manager system.
33567429    The Plugin or Core Component "oracle.sysman.am.oms.plugin with version 13.5.1.0.0" for which the patch is intended is not deployed in your Enterprise Manager system.
33567433    The Plugin or Core Component "oracle.sysman.bda.oms.plugin with version 13.5.1.0.0" for which the patch is intended is not deployed in your Enterprise Manager system.
33567441    The Plugin or Core Component "oracle.sysman.emct.oms.plugin with version 13.5.1.0.0" for which the patch is intended is not deployed in your Enterprise Manager system.
33567426    The Plugin or Core Component "oracle.sysman.emfa.oms.plugin with version 13.5.1.0.0" for which the patch is intended is not deployed in your Enterprise Manager system.
33567454    The Plugin or Core Component "oracle.sysman.ssa.oms.plugin with version 13.5.1.0.0" for which the patch is intended is not deployed in your Enterprise Manager system.
33567469    The Plugin or Core Component "oracle.sysman.vi.oms.plugin with version 13.5.1.0.0" for which the patch is intended is not deployed in your Enterprise Manager system.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Log file location: /u01/app/Middleware/cfgtoollogs/omspatcher/33715883/omspatcher_2022-03-21_14-29-37PM_deploy.log

OMSPatcher succeeded.

작업이 다 되었다면 확인작업

[oracle:/u01/app/Middleware/OMSPatcher]#./omspatcher lspatches
OMSPatcher Automation Tool
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


OMSPatcher version : 13.9.5.2.0
OUI version        : 13.9.4.0.0
Running from       : /u01/app/Middleware
Log file location  : /u01/app/Middleware/cfgtoollogs/omspatcher/opatch2022-03-21_15-30-29PM_1.log

Component Name/Version                            Component Type      System Patch        (Sub)-Patches       Patch Description
------------------------                          -------------       -------------       --------------      ------------------
oracle.com.fasterxml.jackson.jaxrs.jacks          Core                N/A                 32253037            WLS PATCH SET UPDATE 12.2.1.4.201209
on.jaxrs.base/2.9.9.0.0

oracle.jrf.iau/12.2.1.4.0                         Core                N/A                 31666198            OPSS Bundle Patch 12.2.1.4.200724

oracle.wls.common.cam.wlst/12.2.1.4.0             Core                N/A                 32253037            WLS PATCH SET UPDATE 12.2.1.4.201209

oracle.ohs2/12.2.1.4.0                            Core                N/A                 31808404            OHS (NATIVE) BUNDLE PATCH 12.2.1.4.200826

oracle.com.fasterxml.jackson.jaxrs.jacks          Core                N/A                 32253037            WLS PATCH SET UPDATE 12.2.1.4.201209
on.jaxrs.json.provider/2.9.9.0.0

oracle.com.fasterxml.jackson.core.jackso          Core                N/A                 32253037            WLS PATCH SET UPDATE 12.2.1.4.201209
n.databind/2.9.9.0.0

oracle.sysman.db.oms.plugin/13.5.1.0.0            Plugin              33715883            33567421            Oracle Enterprise Manager for Oracle Database 13c Release 5 Plug-in Update 4 (13.5.1.4) for Oracle Management Service

oracle.wls.jrf.tenancy.common.sharedlib/          Core                N/A                 32253037            WLS PATCH SET UPDATE 12.2.1.4.201209
12.2.1.4.0

oracle.jrf.adfrt/12.2.1.4.0                       Core                N/A                 32458315            ADF BUNDLE PATCH 12.2.1.4.210203

oracle.com.fasterxml.jackson.module.jack          Core                N/A                 32253037            WLS PATCH SET UPDATE 12.2.1.4.201209
son.module.jsonschema/2.9.9.0.0

oracle.jrf.toplink/12.2.1.4.0                     Core                N/A                 32412974            One-off

oracle.wls.jrf.tenancy.ee.only.sharedlib          Core                N/A                 32253037            WLS PATCH SET UPDATE 12.2.1.4.201209
/12.2.1.4.0

oracle.webcenter.wccore/12.2.1.4.0                Core                N/A                 31818221            One-off

oracle.log4j.log4j/2.11.1.0.0                     Core                N/A                 32253037            WLS PATCH SET UPDATE 12.2.1.4.201209

oracle.xdk.jrf.xmlparserv2/12.2.1.4.0             Core                N/A                 26626168            One-off

oracle.sysman.cfw.oms.plugin/13.5.1.0.0           Plugin              33715883            33567476            Oracle Enterprise Manager for Cloud Framework 13c Release 5 Plug-in Update 4 (13.5.1.4) for Oracle Management Service

oracle.fmwconfig.common.wls.shared.inter          Core                N/A                 32253037            WLS PATCH SET UPDATE 12.2.1.4.201209
nal/12.2.1.4.0

oracle.com.fasterxml.jackson.module.jack          Core                N/A                 32253037            WLS PATCH SET UPDATE 12.2.1.4.201209
son.module.jaxb.annotations/2.9.9.0.0

oracle.com.fasterxml.jackson.core.jackso          Core                N/A                 32253037            WLS PATCH SET UPDATE 12.2.1.4.201209
n.core/2.9.9.0.0

oracle.opss.wls/12.2.1.4.0                        Core                N/A                 31708760            One-off

oracle.org.bouncycastle.bcprov.jdk15on/1          Core                N/A                 32253037            WLS PATCH SET UPDATE 12.2.1.4.201209
.60.0.0.0

oracle.wls.core.app.server/12.2.1.4.0             Core                N/A                 32253037            WLS PATCH SET UPDATE 12.2.1.4.201209

oracle.wls.security.core.sharedlib/12.2.          Core                N/A                 32253037            WLS PATCH SET UPDATE 12.2.1.4.201209
1.4.0

oracle.wls.shared.with.cam/12.2.1.4.0             Core                N/A                 32253037            WLS PATCH SET UPDATE 12.2.1.4.201209

oracle.org.bouncycastle.bcprov.ext.jdk15          Core                N/A                 32253037            WLS PATCH SET UPDATE 12.2.1.4.201209
on/1.60.0.0.0

oracle.coherence/12.2.1.4.0                       Core                N/A                 122146              Bundle patch for Oracle Coherence Version 12.2.1.4.6

oracle.xdk.jrf.jaxp/12.2.1.4.0                    Core                N/A                 26626168            One-off

oracle.wls.libraries/12.2.1.4.0                   Core                N/A                 32253037            WLS PATCH SET UPDATE 12.2.1.4.201209

oracle.sysman.xa.oms.plugin/13.5.1.0.0            Plugin              33715883            33567450            Oracle Enterprise Manager for Exadata 13c Release 5 Plug-in Update 4 (13.5.1.4) for Oracle Management Service

oracle.com.fasterxml.jackson.dataformat.          Core                N/A                 32253037            WLS PATCH SET UPDATE 12.2.1.4.201209
jackson.dataformat.xml/2.9.9.0.0

oracle.opss.core/12.2.1.4.0                       Core                N/A                 31666198            OPSS Bundle Patch 12.2.1.4.200724
                                                                      N/A                 31708760            One-off

oracle.webservices.wls/12.2.1.4.0                 Core                N/A                 32253037            WLS PATCH SET UPDATE 12.2.1.4.201209

oracle.wls.security.core/12.2.1.4.0               Core                N/A                 32253037            WLS PATCH SET UPDATE 12.2.1.4.201209

oracle.sysman.top.oms/13.5.0.0.0                  Core                33715883            33567409            Oracle Enterprise Manager 13c Release 5 Platform Update 4 (13.5.0.4) for Oracle Management Service

oracle.sysman.rcu/12.2.1.4.0                      Core                N/A                 30152128            One-off

oracle.org.bouncycastle.bcpkix.jdk15on/1          Core                N/A                 32253037            WLS PATCH SET UPDATE 12.2.1.4.201209
.60.0.0.0

oracle.webservices.base/12.2.1.4.0                Core                N/A                 32253037            WLS PATCH SET UPDATE 12.2.1.4.201209

oracle.sysman.si.oms.plugin/13.5.1.0.0            Plugin              33715883            33567462            Oracle Enterprise Manager for Systems Infrastructure 13c Release 5 Plug-in Update 4 (13.5.1.4) for Oracle Management Service

oracle.com.fasterxml.jackson.core.jackso          Core                N/A                 32253037            WLS PATCH SET UPDATE 12.2.1.4.201209
n.annotations/2.9.9.0.0

oracle.wls.evaluation.database/12.2.1.4.          Core                N/A                 32253037            WLS PATCH SET UPDATE 12.2.1.4.201209
0

oracle.wls.admin.console.en/12.2.1.4.0            Core                N/A                 32253037            WLS PATCH SET UPDATE 12.2.1.4.201209

oracle.sysman.emas.oms.plugin/13.5.1.0.0          Plugin              33715883            33567414            Oracle Enterprise Manager for Fusion Middleware 13c Release 5 Plug-in Update 4 (13.5.1.4) for Oracle Management Service


NOTE: N/A indicates that the subpatch mentioned in the Subpatches column was applied as a one-off patch and not as part of any system patch.

OMSPatcher has saved inventory details for the above component at below location.
"/u01/app/Middleware"

For more details on installed patch(es), Please do "/u01/app/Middleware/OPatch/opatch lsinventory -details"

OMSPatcher succeeded.

alert 화일에 해당 로그 주기적으로 발생..

ORA-12012: 작업 "SYS"."ORA$AT_SQ_SQL_SW_1003"의 자동 실행중 오류 발생
ORA-38153: 소프트웨어 에디션이 SQL 계획 관리와 호환되지 않습니다.
ORA-06512: "SYS.DBMS_SPM_INTERNAL",  6224행
ORA-06512: "SYS.DBMS_SPM",  2808행
ORA-06512:  34행

해결방법 : Standard edition 에서는 SQL PLAN managent 기능이 지원되지 않아 나는 메세지 이니 무시하거나

SQL Tuning Pack Autotask 기능을 disable 해준다.

BEGIN
  DBMS_AUTO_TASK_ADMIN.DISABLE (
    client_name => 'sql tuning advisor'
,   operation   => NULL
,   window_name => NULL
);
END;
/

모델별로 같은 듯 하면서 약간씩 다른 장비가 들어가 있다.

* X8M-2, X9M-2 
Cisco Nexus 9348GC-FXP
Cisco Nexus 9336C FX 

* X8-2
Cisco Nexus 9348GC-FXP
DataCenter Switch IB-36P

* X7-2
Cisco 93108-1G
DataCenter Switch IB-36P

* X6-2

Cisco Catalyst 4948E-F
DataCenter Switch IB-36P

* X5-2

Cisco Catalyst 4948E-F
DataCenter Switch IB-36P

* X4-2

Cisco Catalyst 4948E-F
DataCenter Switch IB-36P

* X3-2

Cisco Catalyst 4948E-F
DataCenter Switch IB-36P

* X2-2

Cisco Catalyst 4948
DataCenter Switch IB-36P

OECA (Oracle Exadata Configuration Assistant) 4.0.4 버전이 나왔다. 이미 2021.12월에..

내가 구성하고자 하는 Exadata 의 전원 필요용량 및 네트워크,구성용량 등을 쉽게 계산하고 예쁘게 볼수 있다. (X9M-2 지원)

다운로드는 여기서 하면 된다.

https://www.oracle.com/database/technologies/oeca-download.html 

다운로드가 안되시는 분들은..분할 압축해서 올린다.

EM 도 주기적으로 DB RU 처럼 Patch 가 나오는데 최근에 13.5.0.4 패치가 나왔다.

EM Product Manager 의 Blog 인데 

https://blogs.oracle.com/observability/post/oracle-enterprise-manager-13c-release-5-update-4-13504-is-now-available

아래와 같이 몇가지 기능이 업데이트 또는 추가되었다.

• Monitor a Database Using a Custom (Non-DBSNMP) User
• Create a Custom Dashboard
• New Compliance Rule Detail Tab
• Pluggable Database Update and Upgrade using Fleet Maintenance UI
• Cloud Pre-Migration Advisor Tool Available for Migration Workbench
• Monitor SI Server Target Using REST APIs
• Use Non-root User Credential for Monitoring SI Server and ZFS Target
• Support for ZDLRA Named Users
• New REST APIs for Onboarding Protected Databases with ZDLRA
• Chargeback for Oracle Cloud Infrastructure

근데 패치 download 하기 위한 설명은 My Oracle Support > Patches & Updates. 로 가서 받으라는 건데 너무 불친철 하다. ㅆㅂ

뭘 어디서 검색해서 받으라는 건지..내가 못찾는 건가..나는 만들어 놨으니 알아서 받으라는 듯하다.

킹 받아서 찾아보니 해당 링크의 문서내용를 참조해야 쉽게 찾아 들어갈수 있다.

13.5.0 Enterprise Manager Cloud Control Base Platform Monthly Release Update (RU) 4 (Doc ID 2847894.1)

해당 패치 # 는 Patch 33715883 이다.

Download 하기 위해서 고통받는 분 없기를..