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
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:
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
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
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
There is no excerpt because this is a protected post.
There is no excerpt because this is a protected post.
There is no excerpt because this is a protected post.
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 then I have been working as a Database Administrator. Regarding my work profile i am having a total of 4 years of IT experience ,Out of … 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