Please enter search query.
Search <book_title>...
NetBackup IT Analytics Installation and Upgrade Guide for Linux
Last Published:
2025-02-03
Product(s):
NetBackup IT Analytics (11.4)
- Installation overview
- Install NetBackup IT Analytics on a Linux server
- Step-4: Install Oracle database application binaries (Linux)
- Verify the current license configuration
- Next steps
- Upgrade NetBackup IT Analytics Portal on Linux
- Upgrade NetBackup IT Analytics Portal
- Data Collector upgrades
- Upgrade and Migrate to a new server
- Upgrade and migrate to a new server
- Upgrade and migrate to a new server
- Appendix A. X Virtual Frame Buffer
- Appendix B. Oracle patches for the database server
Validate the database and OJVM patches
- As Aptare user connect to SQL Plus using following command:
sqlplus / as sysdba
- Query to check registry for patch history.
SQL> select * from sys.registry$history;
- Query to check registry for installed patch.
SQL> select * from sys.registry$sqlpatch;
- Report output with patch details.
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 Patch Id : 36414915 Action : ROLLBACK Action Time : 26-OCT-2024 01:56:18 Description : OJVM RELEASE UPDATE: 19.24.0.0.240716 (36414915) Logfile : /opt/aptare/cfgtoollogs/sqlpatch/36414915/25700138/ 36414915_rollback_SCDBCNTR_CDBROOT_2024Oct26_01_56_18.log Status : SUCCESS Patch Id : 36878697 Action : APPLY Action Time : 26-OCT-2024 01:56:18 Description : OJVM RELEASE UPDATE: 19.25.0.0.241015 (36878697) Logfile : /opt/aptare/cfgtoollogs/sqlpatch/36878697/25797620/ 36878697_apply_SCDBCNTR_CDBROOT_2024Oct26_01_56_18.log Status : SUCCESS Patch Id : 36912597 Action : APPLY Action Time : 26-OCT-2024 01:56:38 Description : Database Release Update : 19.25.0.0.241015 (36912597) Logfile : /opt/aptare/cfgtoollogs/sqlpatch/36912597/25871884 /36912597_apply_SCDBCNTR_CDBROOT_2024Oct26_01_56_18.log Status : SUCCESS PL/SQL procedure successfully completed
Note:
If previous patches are applied then those patch id will be displayed here.
- Exit from SQL prompt:
SQL>exit