Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

If you want to learn What the Redo Log is, you should read the article named “Oracle Redo Log And Archive Log”. I will tell you finding and changing log …

What is the SYSAUX Tablespace and What is it used for? In Oracle databases, SYSAUX tablespace is an auxiliary storage space for SYSTEM tablespace. Most Oracle database components that are …

What is Redo Apply? Redo Apply performs the task of creating a block-by-block copy of the Primary database. The operations are as follows; The RFS process writes the Redo Data …

When runinstaller for Oracle 19c database installation is run in Linux environments, a blank screen appears due to problems with fonts. The same problem occurs when the Database Configuration Assistant …

This article provides information about how to install oracle database in docker and oracle usage in docker. For detailed information about Docker before installation, please refer to my article “What …

The principle of least privilege (POLP) is an important concept in computer security, is to restrict users’ privileges to the minimum level they need to do their jobs. According to …

I will explan Automatic GAP Resolution in Oracle Data Guard in this article. You may want to read below articles two understand Oracle Data Guard architecture. “Oracle Data Guard Architecture“, …

What is Oracle Cloud Free Tier? Oracle Cloud Free Tier  is a free service that allows you to use Oracle Autonomous Database and Oracle Cloud Infrastructure products for an unlimited …

I recommend reading article “Oracle Data Guard Architecture” to understand What is Data Guard before reading this article. Redo transport services are responsible for transporting redo data from the primary …

This error occurs due to problems during the upgrade process of databases from 11g to 12c. If the Upgrade is not completed and 11g continues to work , this error …