asrblogger While trying to start database While trying to start database You might be using Automatic Memory Management (AMM). AMM uses two initialization parameters: The shared memory file system should have enough space to accommodate the MEMORY_TARGET and MEMORY_MAX_TARGET values. To verify: In UNIX/Linux, you will have to set the shared memory file system accordingly. Verify: Set: Hope it helped … Read more
Database release 19.7, has finally attained certification for Oracle Linux 8. However, successful installation may necessitate some workarounds. Begin by installing the Oracle Validated rpm from the ol8_UEKR6 repository: Despite the upgrades and certifications, there are still a couple of hurdles to contend with. First, the installer will refuse to run because it doesn’t recognize … Read more
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
Meta-Data:The Meta-data is generally the first command of the search. As a best practice, we should include 4 fields always in the first line of the query. This is not mandatory but adding them is always better from Splunk search perspective. 1. INDEX: the repository of Splunk where your data resides. 2. HOST : this … Read more
Hash partitioning is a database partitioning technique used in Oracle databases to distribute data evenly across multiple partitions. This method is particularly useful for ensuring a balanced distribution of data and for improving query performance by minimizing data retrieval times. In contrast to Range or List Partitioning, where you specify the criteria that determine the … Read more