Create Service Request (SR) in My Oracle Support (MOS) !!

Hey Folks !! Today I will guide you towards the process of raising Oracle SR via metalink website or also known as My Oracle Support. There are several reasons why we may need to connect with Oracle Support: Typically, Oracle DBAs are tasked with raising a Technical Service Request (SR), whether it’s for an ongoing … Read more

PostgreSQL Interview Question !!

Hey Folks, The objective of this blog post is to guide you through out the questionnaire that is being asked now a day from interviewer regrading Postgres Database. Below are some list of Interview questions: Installation: Types of Installations: What are the different methods for installing PostgreSQL?Pre-Requisites: What are the pre-requisites for installing PostgreSQL?Pre-Requisite Verification: … Read more

ORA-1654: unable to extend index in tablespace

From Alert logs ORA-1654: unable to extend index SCHEMA.IN021S1 by 128 in tablespace TBS_012024-03-23T16:26:11.156475+05:30ORA-1654: unable to extend index SCHEMA.IN021S1 by 128 in tablespace TBS_012024-03-23T16:26:19.194628+05:30 2. Check the datafiles size and path present in respective tablespace: 4. Give a Log Switch and monitor the Alert Log:

Command to Check Archivelog Size

Oracle databases maintain a detailed history of all changes made to the database through archived redo logs, commonly known as archivelogs. These archivelogs are crucial for data recovery and are often managed by database administrators. Monitoring the size of archivelogs is essential to ensure optimal database performance and sufficient storage capacity. Here are some ways … Read more

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 your Data Guard setup. Solution : Steps to Resolve ORA-16698 1. Check Current LOG_ARCHIVE_DEST_n Parameters2. Modify the Incorrect Parameter3. Validate the Data Guard Configuration4. Check … Read more

Deploy CNPG Postgres on Kubernetes Cluster !!

ConfigMaster Nodes: 1Worker Nodes: 3DB Cluster Nodes: 2Postgres Operator: CNPGCluster Mode: 1 primary 1 standby Cluster Details: Hostname IP Node Name Role External Storage master.localdomain  192.168.115.190 k3s-master master NA worker1.localdomain  192.168.115.195 k3s-worker1 worker 200GiB worker2.localdomain   192.168.115.196 k3s-worker2 worker 200GiB worker3.localdomain   192.168.115.197 k3s-worker3 worker 200GiB Entry in /etc/hosts: Create VG from external disks in 3 worker … Read more

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 is taking more time to execute.* You can also delete past query in order to free your allotted space and enhance performance. Search modes:There are … Read more