ORACLE

You can find the below informations about Snapshot Standby Database in this article. What is Oracle Snapshot Standby Database? Convert Physical Standby to Snapshot Standby Convert Physical Standby to Snapshot …

What is Read Only Tables in Oracle? It is possible to use read only tables in Oracle databases starting from 11.1. You can not update read only tables. A table …

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 start parameter is not set …

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 …

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-5f99026d7cc6a373975956/] Oracle RAC …