Oracle Archives - Page 5 of 30

Error: ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set (DataGuard Broker Configuration)

The ORA-16698 error in Oracle indicates that a Data Guard member has a LOG_ARCHIVE_DEST_n parameter with the SERVICE attribute set, which is causing a conflict or an incorrect configuration in…

asrblogger June 22, 2024No Comments

Cassandra Cloud Oracle

Deploy CNPG Postgres on Kubernetes Cluster !!

ConfigMaster Nodes: 1Worker Nodes: 3DB Cluster Nodes: 2Postgres Operator: CNPGCluster Mode: 1 primary 1 standby Cluster Details: HostnameIPNode NameRoleExternal Storagemaster.localdomain 192.168.115.190k3s-mastermasterNAworker1.localdomain 192.168.115.195k3s-worker1worker200GiBworker2.localdomain 192.168.115.196k3s-worker2worker200GiBworker3.localdomain 192.168.115.197k3s-worker3worker200GiB Entry in /etc/hosts: 192.168.115.190 master.localdomain 192.168.115.195 worker1.localdomain 192.168.115.196 worker2.localdomain 192.168.115.197…

asrblogger June 16, 2024No Comments

Oracle

Protected: Solutions of Oracle Database 19c – Practical & Assignment

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

asrblogger June 9, 2024

Interview Questions Oracle SQL

Protected: Structured Query Language [SQL] Interview Questions

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

asrblogger June 2, 2024

DataGuard Interview Questions Oracle

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

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

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

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…