TimescaleDB, is a revolutionary open-source database engineered specifically for time-series data. Built on the robust foundation of PostgreSQL, TimescaleDB combines the reliability and versatility of traditional relational databases with the…
Read MoreIn the realm of data management and analysis, the spotlight often shines on a variety of databases designed to handle specific types of data and workloads. Among these, timeseries databases…
Read MorePlease use the below query. set lines 132 col waitevent head EVENT format a5 trunc col username format a10 col osuser format a10 trunc col p1 format 9999 col…
Read MorePlease follow the below steps to delete all the latest inactive patches using the following command. One inactive patch remains, to allow the current patch to be rolled back. cd $ORACLE_HOME/OPatch . /opatch util deleteinactivepatches…
Read MoreSteps to upgrade the latest OEM Agent Release update 1. Install the latest AgentPatcher Download the latest Agentpatcher from oracle support. cd <Patch location> cp p33355570_135000_Generic.zip /u01/app/oracle/product/agent13c/agent_13.5.0.0.0 cd /u01/app/oracle/product/agent13c/agent_13.5.0.0.0 unzip…
Read MoreStep:-1 Check invalid Invalid Component:- SQL> SELECT COMP_NAME FROM DBA_REGISTRY WHERE STATUS=’INVALID’; COMP_NAME ——————————————————————————– Oracle XML Database Step:-2 execute the below packages and triggers ALTER PACKAGE XDB.DBMS_CLOBUTIL COMPILE BODY ;…
Read MorePatch Information: – Patch 30087906 – Database Release Update Revision 19.3.2.0.191015 Step: -1 Environment Details export ORACLE_HOME=/u01/app/19c/grid export PATH=/u01/app/19c/grid/bin: $PATH [oracle@rac1 ~]$ srvctl config database -verbose oradb /u01/app/oracle/product/19c/dbhome_1 19.0.0.0.0…
Read MoreIntroduction: In this article, we are here to know different ways to generate the backup in the MySQL database server. It is essential to make regular backups of all data…
Read MoreINTRODUCTION: This doc will guide you through the process of performing a MySQL replication switchover, ensuring a smooth transition without any data loss. Let’s dive into the step-by-step instructions. Step…
Read More