pat98's always & forever

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 하기 위해서 고통받는 분 없기를..

패치작업 19.14.0.0.220118 (GI PSU 33509923)

OCW Patch Set Update      : 19.14.0.0.220118 (33529556)
ACFS Patch Set Update     : 19.14.0.0.220118 (33534448)
Database Patch Set Update : 19.14.0.0.220118 (33515361)
DBWLM Release Update      : 19.0.0.0.0       (33575402)
Tomcat Release Update     : 19.0.0.0.0       (33239955)

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

- grid 유저
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/33509923/33515361
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/33509923/33529556
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/33509923/33534448
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/33509923/33575402
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/33509923/33239955

- oracle 유저
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/33509923/33515361
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/33509923/33529556

(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 -nonrolling

(grid 유저)
export GI_HOME=/u01/app/19.3.0.0/grid
cd /u01/install
$GI_HOME/OPatch/opatch apply -oh $GI_HOME -local ./33509923/33529556 -silent
$GI_HOME/OPatch/opatch apply -oh $GI_HOME -local ./33509923/33534448 -silent
$GI_HOME/OPatch/opatch apply -oh $GI_HOME -local ./33509923/33515361 -silent
$GI_HOME/OPatch/opatch apply -oh $GI_HOME -local ./33509923/33575402 -silent
$GI_HOME/OPatch/opatch apply -oh $GI_HOME -local ./33509923/33239955 -silent

(oracle 유저)
export ORACLE_HOME=/u01/app/oracle/product/19.3.0.0/dbhome_1
cd /u01/install
./33509923/33529556/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./33509923/33529556 -silent
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./33509923/33515361 -silent
./33509923/33529556/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 -nonrolling

(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 유저로)
$GI_HOME/OPatch/opatch nrollback -local -id 33529556,33534448,33515361,33575402,33239955 -oh $GI_HOME

(oracle 유저로)
cd <UNZIPPED_PATCH_LOCATION>
./33509923/33529556/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME (권한체크)
$ORACLE_HOME/OPatch/opatch nrollback -local -id  33529556,33515361 -oh /oracle/product/19.3.0.0
./33509923/33529556/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME (권한체크)

Run post script
(root로)
$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

19.13 환경하에서 테스트

- silent 생성시와 asmca 이용시 옵션없이 Default 로 생성하면 AU_SIZE 가 다름을 확인 할수 있다.

- silent에서는 아무 옵션을 주지 않고 생성시 AU_SIZE가 Default 로 1M 로 생성되므로 반드시 AU_SIZE를 지정한다.!!!
- asmca 로 생성할 경우 초기화면에 AU_SIZE를 지정할수 있지만 생성후 GUI에서 AU_SIZE 정보는 나오지 않는다. 

-> AU_SIZE는 최초 Diskgroup 생성시에만 지정가능하고 ALTER DISKGROUP 명령으로 변경이 불가하다.

SQL> CREATE DISKGROUP DATA NORMAL REDUNDANCY DISK '/dev/sdc1';

[+ASM1]oracle@19c-1:/home/oracle# asmcmd lsattr -G RECO -l
Name                     Value       
access_control.enabled   FALSE       
access_control.umask     066         
au_size                  1048576     <----- 1M로 생성됨
cell.smart_scan_capable  FALSE       
compatible.asm           11.2.0.2.0  
compatible.rdbms         10.1.0.0.0  
disk_repair_time         12.0h       
idp.boundary             auto        
idp.type                 dynamic     
sector_size              512 

- asmca 로 만든 경우
[+ASM1]oracle@19c-1:/home/oracle# asmcmd lsattr -G DATA -l
Name                        Value         
access_control.enabled      FALSE         
access_control.umask        066           
appliance._partnering_type  GENERIC       
ate_conversion_done         true          
au_size                     4194304       <----- 4M로 생성됨
cell.smart_scan_capable     FALSE         
cell.sparse_dg              allnonsparse  
compatible.asm              19.0.0.0.0    
compatible.rdbms            10.1.0.0.0    
content.check               FALSE         
content.type                data          
content_hardcheck.enabled   FALSE         
disk_repair_time            12.0h         
failgroup_repair_time       24.0h         
idp.boundary                auto          
idp.type                    dynamic       
logical_sector_size         512           
maxdump_content.check       64            
maxerr_content.check        1024          
phys_meta_replicated        true          
preferred_read.enabled      FALSE         
scrub_async_limit           1             
scrub_metadata.enabled      TRUE          
sector_size                 512           
thin_provisioned            FALSE         
vam_migration_done          false 

결론적으로 Diskgroup 생성시 아래와 같이 명시적으로 지정하여 사용할것 !!

SQL>CREATE DISKGROUP RECO EXTERNAL REDUNDANCY DISK '/dev/sdc1'
attribute 'au_size' = '4M', 'compatible.asm' = '19.0.0.0.0', 'compatible.rdbms' = '10.1.0.0.0';

AIX에서 DB Logon이 많을 경우, LogOut 시에 10초 이상 대기하는 문제 19c (ksipc_service_mask)

• 현상
- AIX 환경에서 DB Logon이 자주 발생하는 서비스에서 DB Connection의 LogOut 시 10여초 이상 대기하는 문제
- AP 서버 (AIX or Linux 등) 2대에서 각각 Java DB Connection 호출
- Java가 종료될 때 DB 서버 다른 창에서 DB Connection 시도 시 발생
- 19c RAC on AIX : DB connection, sqlplus id/pwd@TNS, BEQ (sqlplus id/pwd) 환경에서 발생
- Oracle JDK 또는 IBM JDK 사용하여 JDBC connection 시도 시에도 속도 저하 현상 발생

• 원인
- <Note:32550751.8> Bug:32550751 - MGA Related Operations on AIX Might Cause Performance Issues
- <Note:2771495.1> Database Hangs With 'failed To Aquire Latch' After Patching From 19.6 To 19.10

• 해결 방안
1. MGA contention이 많이 발생하는 경우 "_ksipc_service_mask" = 0 를 적용하여 MGA latch disable 가능
2. 그러나, “_ksipc_service_mask”=0 적용은 developer 단의 검증이 필요함. Refer to <Note:2771495.1>

- AIX 플랫폼에서 주로 발생하는 듯 한데.. MGA관련한 버그가 많기 때문에 RU버전별로 해당 이슈별 패치가 존재하고 증상도 다양하기 때문에 반드시 SR를 통해  확인 받고 Patch 적용이나 Workaround 작업하는 필요함

이에 외도 MGA 관련 Bug 아래와 같이 다양하게 존재함.

<Note:32550751.8> Bug:32550751 - MGA Related Operations on AIX Might Cause Performance Issues
<Note:2771495.1> Database Hangs With 'failed To Aquire Latch' After Patching From 19.6 To 19.10
Bug 33352794 - HIGH WAIT ON 'LATCH: MGA SHARED CONTEXT ROOT LATCH' AND 'LATCH: MGA SHARED CONTEXT LATCH
<Bug:30293345> - LATCH: MGA SHARED CONTEXT LATCH WAITS AFTER MIGRATION TO 18C

- PASSWORD_ROLLOVER_TIME

원래 21c에 있는 New Features 기능이나 RU 19.12를 적용하면 기존에 PROFILE 외에 PASSWORD_ROLLOVER_TIME이 추가되었다.
이 설정은 패스워드를 변경했을 때에 OLD 패스워드도 일정시간(일) 유효하게 하는 기능이다. 
이 기능을 사용하면 데이터베이스 사용자의 암호를 미리 변경할 수 있으므로 클라이언트에서 연결할 수 없는 시간을 없앨 수 있다.

-> 그간 사용중인 오라클 계정이 갑자기 locked 되는 장애 케이스를 보면 Application에서 password 를 hard coding 해서 쓰고 있었을 경우, Oracle 계정에서 신규 password 로 바꾸어도 AP에서 수정 반영하지 않으면 old password 로 계속 접속 시도하게 되어 순식간에 계정이 locked 되는 경우가 있었는데 이러한 장애를 방지할 수 있는 용도로 활용할 수 있을 듯 하다.

select * from dba_profiles order by 1;

PROFILE              RESOURCE_NAME                  RESOURCE LIMIT                COM INH IMP
-------------------- ------------------------------ -------- -------------------- --- --- ---
DEFAULT              PASSWORD_ROLLOVER_TIME         PASSWORD -1                   NO  NO  NO

LIMIT 값이 -1 이 나오는데 얼마를 의미하는지 이건 잘 모르겠다..메뉴얼에도 설명이 없는..

테스트)

1. PASSWORD_ROLLOVER_TIME 변경 (1일로 바꾸었다)
SQL> CREATE PROFILE PROFILE_TEST LIMIT PASSWORD_ROLLOVER_TIME 1;

-> LIMIT 를 1로 바꾸면 86400(초) 로 값이 설정된다.

2. 사용자를 만들고 프로필을 지정한다.

SQL> CREATE USER TEST IDENTIFIED test PROFILE PROFILE_TEST;
SQL> GRANT CREATE SESSION TO test;
SQL> CONNECT TEST/test

2. 사용자 암호를 변경한다.

SQL> ALTER USER TEST IDENTIFIED BY test2;
SQL> CONNECT TEST/test   <------ 이전 암호로 접속됨
SQL> DISCONNECT

SQL> CONNECT TEST/test2  <------ 신규 암호로 접속됨

테스트후 다시 원래 대로 -1 의 기본값으로 돌리고 싶다면..
SQL> alter profile default limit PASSWORD_ROLLOVER_TIME 0;