Introduction ORAchk (Oracle Autonomous Health Framework) is a utility provided by Oracle to perform proactive health checks and validation of Oracle databases, clusters, and Oracle hardware. It helps in identifying potential issues and recommends actions to improve performance, stability, and security. It’s a good idea to upload the AHF output as part of any support … Read more
What is Hidden Parameter in Oracle? Hidden parameters in Oracle Database, often referred to as “Underscore parameters,” are settings that do not appear in standard queries like SHOW PARAMETER or V$PARAMETER unless they have been explicitly set. These parameters usually begin with an underscore (“_”) and are also known as “Undocumented Parameters” because Oracle does … Read more
This article outlines the process of determining the size of a MySQL database and assessing the available free space within it. Determine the database size: Execute the following MySQL query to showcase the database name and its size in megabytes: Determine the amount of available space: Execute the subsequent query to observe the available free … Read more
Introduction: Archiving Oracle databases facilitates long-term data retention and storage. However, if space becomes insufficient, it raises concerns about the continuity of data archiving processes. When the archive destination reaches its capacity, your Oracle Database may encounter issues such as hanging or becoming unresponsive, accompanied by error messages like the following: ORA-00257: Archiver Error, connect … Read more
After successfully installing Grid Infrastructure with the “grid” user, I attempted to install Oracle Database 19c Release 3 using the “oracle” user. However, during the installation process, I encountered an issue where none of my ASM (Automatic Storage Management) disks were visible in the disk group selection menu. Log in as root user Login as … Read more
In Oracle Data Guard, changing the protection mode involves adjusting the configuration to one of the three protection modes: Maximum Protection, Maximum Availability, or Maximum Performance. The steps to change the protection mode are straightforward but need to be done carefully to avoid any potential issues with your Data Guard setup. Primary database: Verify the … Read more