Please enter search query.
Search <book_title>...
NetBackup IT Analytics Installation and Upgrade Guide for Linux
Last Published:
2023-08-01
Product(s):
NetBackup IT Analytics (11.1)
- Install the NetBackup IT Analytics Portal on a Linux server
- Installer-based deployment
- Upgrade NetBackup IT Analytics Portal on Linux
- Upgrade NetBackup IT Analytics Portal
- Data Collector upgrades
- Oracle patches for the database server
- 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
Validate the database and OJVM patch
- As a APTARE user, connect to SQL Plus using the following command.
sqlplus / as sysdba
- The following is the SQL query to verify the patch history.
SQL>select * from sys.registry$history;
- The following is the SQL query to verify the installed patch.
SQL>select * from sys.registry$sqlpatch ;
- The following is the SQL query for report out put with the patch details.
SQL> set serveroutput on SQL> exec dbms_qopatch.get_sqlpatch_status; Patch Id : 34411846 Action : APPLY Action Time : 03-NOV-2022 15:33:53 Description : OJVM RELEASE UPDATE: 19.17.0.0.221018 (34411846) Logfile : /opt/aptare/cfgtoollogs/sqlpatch/34411846 /24917919/34411846_apply_SCDBCNTR_CDBROOT_2022Nov03_15_28_39.log Status : SUCCESS Patch Id : 34419443 Action : APPLY Action Time : 03-NOV-2022 15:33:53 Description : Database Release Update : 19.17.0.0.221018 (34419443) Logfile : /opt/aptare/cfgtoollogs/sqlpatch/34419443 /24972075/34419443_apply_SCDBCNTR_CDBROOT_2022Nov03_15_28_39.log Status : SUCCESS Patch Id : 34411846 Action : ROLLBACK Action Time : 06-FEB-2023 15:59:28 Description : OJVM RELEASE UPDATE: 19.17.0.0.221018 (34411846) Logfile : /opt/aptare/cfgtoollogs/sqlpatch/34411846 /24917919/34411846_rollback_SCDBCNTR_CDBROOT_2023Feb06_15_58_27.log Status : SUCCESS Patch Id : 34786990 Action : APPLY Action Time : 06-FEB-2023 15:59:29 Description : OJVM RELEASE UPDATE: 19.18.0.0.230117 (34786990) Logfile : /opt/aptare/cfgtoollogs/sqlpatch/34786990 /25032666/34786990_apply_SCDBCNTR_CDBROOT_2023Feb06_15_58_27.log Status : SUCCESS Patch Id : 34765931 Action : APPLY Action Time : 06-FEB-2023 15:59:29 Description : DATABASE RELEASE UPDATE : 19.18.0.0.230117 (REL-JAN230131) (34765931) Logfile : /opt/aptare/cfgtoollogs/sqlpatch/34765931 /25098466/34765931_apply_SCDBCNTR_CDBROOT_2023Feb06_15_58_27.log Status : SUCCESS Patch Id : 34786990 Action : ROLLBACK Action Time : 28-APR-2023 16:24:11 Description : OJVM RELEASE UPDATE: 19.18.0.0.230117 (34786990) Logfile : /opt/aptare/cfgtoollogs/sqlpatch/34786990 /25032666/34786990_rollback_SCDBCNTR_CDBROOT_2023Apr28_16_22_45.log Status : SUCCESS Patch Id : 35050341 Action : APPLY Action Time : 28-APR-2023 16:24:12 Description : OJVM RELEASE UPDATE: 19.19.0.0.230418 (35050341) Logfile : /opt/aptare/cfgtoollogs/sqlpatch/35050341 /25148755/35050341_apply_SCDBCNTR_CDBROOT_2023Apr28_16_22_45.log Status : SUCCESS Patch Id : 35042068 Action : APPLY Action Time : 28-APR-2023 16:24:12 Description : Database Release Update : 19.19.0.0.230418 (35042068) Logfile : /opt/aptare/cfgtoollogs/sqlpatch/35042068 /25183678/35042068_apply_SCDBCNTR_CDBROOT_2023Apr28_16_22_45.log Status : SUCCESS
Note:
If previous patches are applied then those patch id will be displayed here.
- Exit from SQL prompt.
SQL>exit