Step by Step Oracle Database 23ai Installation on Oracle Linux 8.10 !!
Oracle Database 23ai is the next long-term support release of Oracle Database. It includes over…
Read moreOracle
Create Pluggable Database (PDB) Manually Using SQL Prompt Oracle 19c !!
Use the CREATE PLUGGABLE DATABASE statement to create a pluggable database (PDB). This statement enables…
Read moreHow to check FRA ( Fast Recovery area) Utilization in Oracle ?
Hey Folks , As a DBA, performing routine checks for fast recovery are (FRA) monitoring…
Read moreHow to check Tablespace Utilization in Oracle ?
Hey Folks, As a DBA, performing routine checks for tablespace monitoring is a fundamental task.…
Read moreHow to Rename ASM Diskgroup ??
Hey Folks, Today I faced an issue while configuring Oracle DR setup which was due…
Read moreHow to Create & Delete Symbolic Link (Symlink)?
A symlink is a symbolic Linux/ UNIX is a special kind of file that points…
Read moreSteps to Startup & Shutdown Oracle Data Guard !
To start a physical standby database, follow these steps using SQL*Plus with administrator privileges: Start…
Read moreHow to Check Sync between Primary & Standby DB ??
Primary Get standby redo log info: Monitor lag in standby including RAC Monitor recovery progress…
Read moreBetter error messages in Oracle 23ai !!
Hey Folks !! With the enhancement in Oracle 23ai features one of the beautiful thing…
Read moreEnhanced Querying: Eliminating the “FROM DUAL” Clause in Oracle Database 23ai !!
Hey Folks !! Oracle Database 23c, the latest long-term support release, brings over 300 new…
Read moreWhat is the difference between Prepatch and Postpatch in Oracle Patching !!
Hey Folks !! In Oracle patching, the terms prepatch and postpatch refer to specific sets…
Read moreHow to identify the top Wait Events within a Wait Class in Oracle ??
Each wait event in Oracle belongs to a specific class. Below is a breakdown of…
Read moreCalculate the necessary disk space for an Oracle EXPORT backup !!
Size of the Data: Determine the size of the database objects you intend to export.…
Read moreHow To export a table with specific columns in Oracle !!
Hey Folks !! Today I have received a client requirement regarding exporting few columns from…
Read moreCreate Service Request (SR) in My Oracle Support (MOS) !!
Hey Folks !! Today I will guide you towards the process of raising Oracle SR…
Read morePostgreSQL Interview Question !!
Hey Folks, The objective of this blog post is to guide you through out the…
Read moreORA-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…
Read moreCommand to Check Archivelog Size
Oracle databases maintain a detailed history of all changes made to the database through archived…
Read moreError: 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…
Read moreDeploy CNPG Postgres on Kubernetes Cluster !!
ConfigMaster Nodes: 1Worker Nodes: 3DB Cluster Nodes: 2Postgres Operator: CNPGCluster Mode: 1 primary 1 standby…
Read moreProtected: Solutions of Oracle Database 19c – Practical & Assignment
There is no excerpt because this is a protected post.
Read moreProtected: Structured Query Language [SQL] Interview Questions
There is no excerpt because this is a protected post.
Read moreProtected: Oracle Data Guard 19c – 100 Interview Questions!!
There is no excerpt because this is a protected post.
Read moreWhat 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>,…
Read moreInstalling Oracle Database 19c on Oracle Linux 8!!
Database release 19.7, has finally attained certification for Oracle Linux 8. However, successful installation may…
Read more