ORACLE

When trying to send an e-mail with the UTL_MAIL package, the error “ORA-06502: PL / SQL: numeric or value error” is received when the smtp_out_server …

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 …

This article contains information about Oracle Database Authentication Methods such as External Authentication, Database Authentication, Operation System Authentication, Global Authentication. Oracle Database Authentication Methods EXTERNAL …

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 …

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 …

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 …

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 …

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 …

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

This article contains information about oracle numeric/math functions and their usage. Numeric/Math Functions Oracle has several functions for processing numerical data. ABS Function in Oracle …