搜索 <book_title>...

NetBackup IT Analytics 安装和升级指南 (Linux)

Last Published: 2024-09-18

Product(s): NetBackup IT Analytics (11.3)

验证数据库和 OJVM 修补程序

作为 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; 
Patch ID: 35648110 
Action : APPLY
Action Time :06-NOV-2023 19:04:55 
Description :OJVM RELEASE UPDATE: 19.21.0.0.231017 (35648110)
        
Logfile :/opt/aptare/cfgtoollogs/sqlpatch/35648110/25365038/
35648110_apply_SCDBCNTR_CDBROOT_2023Nov06_18_58_52.log

Status : SUCCESS 

Patch Id : 35643107
Action : APPLY

Action Time :06-NOV-2023 19:04:55
Description : Database Release Update : 19.21.0.0.231017 (35643107)
        
Logfile :/opt/aptare/cfgtoollogs/sqlpatch/35643107/25405995/
35643107_apply_SCDBCNTR_CDBROOT_2023Nov06_18_58_52.log

Status : SUCCESS
    

Patch Id : 35648110
Action : ROLLBACK
Action Time : 26-JAN-2024 17:39:58
Description : OJVM RELEASE UPDATE: 19.21.0.0.231017 (35648110)
Logfile :
/opt/aptare/cfgtoollogs/sqlpatch/35648110/25365038/
35648110_rollback_SCDBCNTR_CDBROOT_2024Jan26_17_38_48.log
Status : SUCCESS

Patch Id : 35926646
Action : APPLY
Action Time : 26-JAN-2024 17:39:59
Description : OJVM RELEASE UPDATE: 19.22.0.0.240116 (35926646)
Logfile :
/opt/aptare/cfgtoollogs/sqlpatch/35926646/25513953/
35926646_apply_SCDBCNTR_CDBROOT_2024Jan26_17_38_48.log
Status : SUCCESS

Patch Id : 35943157
Action : APPLY
Action Time : 26-JAN-2024 17:39:59
Description : Database Release Update : 19.22.0.0.240116 (35943157)
Logfile :
/opt/aptare/cfgtoollogs/sqlpatch/35943157/25527362/
35943157_apply_SCDBCNTR_CDBROOT_2024Jan26_17_38_48.log
Status : SUCCESS

Patch Id : 35926646
Action : ROLLBACK
Action Time : 11-MAY-2024 17:42:44
Description : OJVM RELEASE UPDATE: 19.22.0.0.240116 (35926646)
Logfile : 
/opt/aptare/cfgtoollogs/sqlpatch/35926646/25513953/
35926646_rollback_SCDBCNTR_CDBROOT_2024May11_17_42_44.log
Status : SUCCESS

Patch Id : 36199232
Action : APPLY
Action Time : 11-MAY-2024 17:42:44
Description : OJVM RELEASE UPDATE: 19.23.0.0.240416 (36199232)
Logfile : 
/opt/aptare/cfgtoollogs/sqlpatch/36199232/25601966/
36199232_apply_SCDBCNTR_CDBROOT_2024May11_17_42_44.log
Status : SUCCESS

Patch Id : 36233263
Action : APPLY
Action Time : 11-MAY-2024 17:43:05
Description : Database Release Update : 19.23.0.0.240416 (36233263)
Logfile : 
/opt/aptare/cfgtoollogs/sqlpatch/36233263/25638263/
36233263_apply_SCDBCNTR_CDBROOT_2024May11_17_42_44.log
Status : SUCCESS

Patch Id : 36199232
Action : ROLLBACK
Action Time : 17-JUL-2024 13:14:33
Description : OJVM RELEASE UPDATE: 19.23.0.0.240416 (36199232)
Logfile :
/opt/aptare/cfgtoollogs/sqlpatch/36199232/25601966/
36199232_rollback_SCDBCNTR_CDBROOT_2024Jul17_13_14_32.log
Status : SUCCESS

Patch Id : 36414915
Action : APPLY
Action Time : 17-JUL-2024 13:14:33
Description : OJVM RELEASE UPDATE: 19.24.0.0.240716 (36414915)
Logfile :
/opt/aptare/cfgtoollogs/sqlpatch/36414915/25700138/
36414915_apply_SCDBCNTR_CDBROOT_2024Jul17_13_14_33.log
Status : SUCCESS

Patch Id : 36582781
Action : APPLY
Action Time : 17-JUL-2024 13:15:15
Description : Database Release Update : 19.24.0.0.240716 (36582781)
Logfile :
/opt/aptare/cfgtoollogs/sqlpatch/36582781/25751445/
36582781_apply_SCDBCNTR_CDBROOT_2024Jul17_13_14_33.log
Status : SUCCESS
    
PL/SQL procedure successfully completed

注意:

如果已应用先前的修补程序，则此处将显示这些修补程序的 ID。

退出 SQL 提示符：
```
SQL>exit
```