<book_title> 검색…

Linux용 APTARE IT Analytics 설치 및 업그레이드 설명서

Last Published: 2022-09-02

Product(s): APTARE IT Analytics (10.6)

패치 유효성 검사

Aptare 사용자 자격으로 다음 명령을 사용하여 SQL Plus에 연결하십시오.
```
sqlplus / as sysdba
```
레지스트리에서 패치 기록을 확인하는 조회.
```
SQL> select * from sys.registry$history;
```
레지스트리에서 설치된 패치를 확인하는 조회.
```
SQL> select * from sys.registry$sqlpatch;
```

패치 상세 내역이 포함된 리포트 출력.

SQL> set serveroutput on
SQL> exec dbms_qopatch.get_sqlpatch_status;

SQL 프롬프트를 종료하십시오.

SQL> exit
Patch Id : 32545013
Action : APPLY
Action Time : 29-JUN-2021 14:55:04
Description : Database Release Update : 19.11.0.0.210420 (32545013)
Logfile :
/opt/aptare/cfgtoollogs/sqlpatch/32545013/24175065/
32545013_apply_SCDBCNTR_CDBROOT_2021Jun29_14_49_09.log
Status : SUCCESS

Patch Id : 32904851
Action : APPLY
Action Time : 13-OCT-2021 19:58:17
Description : Database Release Update : 19.12.0.0.210720 (32904851)
Logfile :
/opt/aptare/cfgtoollogs/sqlpatch/32904851/24343243/
32904851_apply_SCDBCNTR_CDBROOT_2021Oct13_19_56_19.log
Status : SUCCESS

Patch Id : 33192793
Action : APPLY
Action Time : 01-DEC-2021 18:02:31
Description : Database Release Update : 19.13.0.0.211019 (33192793)
Logfile :
/opt/aptare/cfgtoollogs/sqlpatch/33192793/24462514/
33192793_apply_SCDBCNTR_CDBROOT_2021Dec01_17_59_27.log
Status : SUCCESS

Patch Id : 33515361
Action : APPLY
Action Time : 21-JAN-2022 17:13:39
Description : Database Release Update : 19.14.0.0.220118 (33515361)
Logfile :
/opt/aptare/cfgtoollogs/sqlpatch/33515361/24589353/
33515361_apply_SCDBCNTR_CDBROOT_2022Jan21_17_12_30.log
Status : SUCCESS

Patch Id : 33806152
Action : APPLY
Action Time : 28-APR-2022 17:12:27
Description : Database Release Update : 19.15.0.0.220419 (33806152)
Logfile :
/opt/aptare/cfgtoollogs/sqlpatch/33806152/24713297/
33806152_apply_SCDBCNTR_CDBROOT_2022Apr28_17_10_48.log
Status : SUCCESS

Patch Id : 34133642
Action : APPLY
Action Time : 20-JUL-2022 21:00:06
Description : Database Release Update : 19.16.0.0.220719 (34133642)
Logfile : /opt/aptare/cfgtoollogs/sqlpatch/34133642/24865470/
34133642_apply_SCDBCNTR_CDBROOT_2022Jul20_20_58_00.log
Status : SUCCESS

참고:

이전 패치가 적용된 경우 해당 패치 ID가 여기에 표시됩니다.