After upgrading a database from 11.2.0.4 to 12.1.0.2, the following errors are reported executing a datapump import process: Import: Release...
Year: 2023
RAID stands for Redundant Array of Inexpensive Disks which was later interpreted to Redundant Array of Independent Disks. This technology...
A checkpoint is an operation that Oracle performs to ensure data file consistency. When a checkpoint occurs, Oracle ensures all...
Oracle 19c Grid Infrastructure requires certain files and provides tools to access each Standalone Cluster . It should have a...
Sometimes you may need to kill the RMAN session which is hanging and does not respond. There are several ways...
ARCHIVELOG mode is a mode that you can put the database in for creating a backup of all transactions that...
Commands: In Splunk, to write a query we need to learn the various commands it offers. Each command comes with...
During the Creation of database via DBCA , SPFILE is created in the file location that we specify. This location...
Sometimes the DBA requires to create the read-only user for a particular schemas.While creating the user,one should always keep in...
Large objects (LOBs) LOBs can be a problem in data replication by virtue of their size and the ability to...
System Locks Oracle Database uses various types of system locks to protect internal database and memory structures. These mechanisms are...
Hey Folks, We have recently faced issue with huge lag due to bulk transaction(Insert Operation). To resolve the gap quickly,...