Please enter search query.
Search <book_title>...
APTARE IT Analytics Installation and Upgrade Guide for Linux
Last Published:
2022-09-01
Product(s):
APTARE IT Analytics (10.6)
- Install the APTARE IT Analytics Portal on a Linux server
- Installer-based deployment
- Upgrade APTARE IT Analytics Portal on Linux
- Upgrade Oracle database application binaries to 19c (Linux)
- Upgrade APTARE 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 Patch
- 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;
- Exit SQL prompt.
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
Note:
If Previous patches are applied, then those patch id will be displayed here.