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

Far SYNC is a feature introduced with 12c. It is the dummy instance that sends the Redos from the Primary Database to other Standby Databases in the Data Guard configuration. …

Oracle Authentication Methods EXTERNAL AUTHENTICATION In this mode of authentication, the user need not required to supply his password for the database login. By default the value for the parameter …

Reporting users who query the “Active Data Guard” may want that the data be synchronized with Production. Others may not care whether LAG has occurred for a few seconds. Minor …

The purpose of our article is to install Couchbase Cluster via CLI. We can also install the cluster over the UI, but we will perform these operations over the CLI …

What is Oracle Active Data Guard? Oracle Active Data Guard is a Physical Standby Option available with Enterprise Edition. Thanks to Active Data Guard, we do not leave Data Guard …

We will configure linux for oracle database in this article. We will edit the host file. We will do this in both nodes. (with root user) Configure /etc/hosts for Oracle …

We will install Oracle grid infrastructure 11g on linux in this article. We are starting the Grid Infrastructure installation. We do this only on one node. (with grid user) Step1:Before …

We will install Oracle RAC 11g in this article. First, We check cluster services before starting Oracle installation. We do this in both nodes. (with oracle user) [crayon-5f9a2966528db072805531/] Oracle RAC …

This article contains information about oracle date functions such as sysdate, last_day, add_months, extract. Date Functions in Oracle Oracle has several functions to operate on date and time data. ADD_MONTHS …

Today, I will introduce you a nice extension that we can use instead of VACUUM FULL in PostgreSQL. I recommend using it in your prod environments. VACUUM FULL command rewrites …