asrblogger, Author at ASRblogger

Protected: Oracle Data Guard 19c – 100 Interview Questions!!

This content is password protected. To view it please go to the post page and enter the password.

asrblogger June 2, 2024

SPLUNK User Interface

Share/Print/Export Output:The output of the search query can be shared, print or exported in the form of a csv. Delete/Inspect Jobs:* Query ran can be inspected as to which step…

asrblogger May 26, 2024No Comments

Oracle

What are the roles and responsibilities as an Oracle Database Administrator in your current organization?

Good evening Sir/Madam, I am glad to be here for the interview. I am <Your_name>, an engineering graduate from <College Name> University. I graduated in the year 2020, and since…

asrblogger May 7, 2024No Comments

Linux

ORA-00845: MEMORY_TARGET not supported on this system

While trying to start database While trying to start database You might be using Automatic Memory Management (AMM). AMM uses two initialization parameters: MEMORY_TARGET MEMORY_MAX_TARGET The shared memory file system should…

asrblogger May 4, 2024No Comments

Oracle

Installing Oracle Database 19c on Oracle Linux 8!!

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: yum…

asrblogger May 4, 2024No Comments

Oracle

ORAchk (Oracle Autonomous Health Framework)

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…

asrblogger April 29, 2024No Comments

Oracle

Hidden or Underscore Parameter in Oracle 19c

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…

asrblogger April 26, 2024No Comments

MySQL

Get the database size in MySQL

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…

asrblogger April 24, 2024No Comments

Oracle

Secondary archive destinations in Oracle

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…

asrblogger April 13, 2024No Comments

ASM Oracle

INS-30502 No ASM Disk Group Found.

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…