Database Blog

ODA (Oracle Database Appliance) Monitoring commands

Hardware monitoring commands: – Display information about the environment and hardware:- odaadmcli show env_hw Display information about the filesystem:- odaadmcli show fs Display information about the Memory:- odaadmcli show memory…

Read More

ORA-07445 – exception encountered: core dump

ORA-07445 – exception encountered: core dump Issue :- DB was down due to the ORA – 07445 error in the alert log Cause:- ORA-07445: exception encountered: core dump [kggchk()+52] [SIGSEGV]…

Read More

5 Exciting Features of Oracle Database 23c Simplified

Introduction:   Oracle Database 23c brings along a plethora of new and impressive features that have got database enthusiasts excited. In this blog, we will explore the top five features…

Read More

Managing Flash Recovery Area and Handling ORA-19815 Error in Oracle Database 12c

Introduction: Oracle Database 12c offers a robust mechanism for handling backup and recovery tasks through its Flash Recovery Area (FRA). However, users may encounter issues like the ORA-19815 error, which…

Read More

Web Application Firewall In Oracle Cloud Infrastructure

Web Application Firewall In Oracle Cloud Infrastructure Introduction In today’s digital universe, web applications are the backbone of numerous businesses and services. Securing this application from cyber threats and attacks…

Read More

Creating, Attaching & Resizing Block Volume in OCI

Creating, Attaching, and Resizing Block Volume in OCI Introduction In cloud computing environments, such as Oracle Cloud Infrastructure (OCI), block volumes play a pivotal role in providing scalable and persistent…

Read More

Secure PDBs using LOCKDOWN PROFILEs

Purpose: LOCKDOWN Profiles concept will be applicable for Oracle Multitenant databases. We can apply this LOCKDOWN Profiles concept to specific CDB, specific PDB or ALL PDBs. This Concept will help…

Read More

Adop hot patch failed with unexpected Error in EBS 12.2.8

Introduction: This blog is intended for DBA’s who may pass off with the below error message on applying a patch as hot patch in the instance. While applying adop hot…

Read More

Find unused or unnecessary Privileges of Oracle Database user

Purpose: Usually a  Privilege can be treated as unused privilege if this is not being used by user or pre-running programs at database level. During new application development phase or…

Read More

AWS – Creating a Web server with EC2 ( Virtual Server in Cloud)

Login to AWS Management Console Then Navigate to EC2 Click Launch Instance   Choose an AMI       Choose Instance Type   Configure Security Group Launch the instance Create…

Read More