Error: When connecting to rman, “PLS-00201: identifier ‘DBMS_BACKUP_RESTORE.SET_CHARSET’ must be declared” error and connection could not be established. Reason: Problematic DBMS_BACKUP_RESTORE package or invalid sys …

  Partition is the process of dividing tables and indexes into parts. For example, I have a table with a size of 1 TB. And …

  In this article I will explain some information about SQL Server System databases. System databases are created automatically when you install SQL Server. The …

Error : The DBSNMP user is locked after a certain period of time. Reason: An application (possibly an application in EM) is trying to login …

  With using triggers in PostgreSQL, you can trigger another event before an event occurs (BEFORE TRIGGER). Or you can trigger another event after it …

Error: During RMAN backup, you can see the following errors. ORA-00245: control file backup operation failed RMAN-08132: WARNING: can not update recovery area reclaimable file …

Error: When connecting to RMAN, it generates output when any command is given, but the command is not completed and is waiting. Reason: Disruption in …

  In some cases, there may not be enough space on the disks where the database files are located. For this reason, you may need …

Error: When we try to create a file in NFS mounted directory we get an error like this and we can not create the file …

General Concepts: First of all, the database has two files by default. These are data file with mdf extension (called Primary Data File) and transaction …