This article contains information about dropping database in Oracle 19c and unistalling Oracle 19C binaries in Windows. STEP1 : Connect As SYSDBA [crayon-676d0025389ec169245027/] STEP 2: …
Read More »ORACLE
Oracle Snapshot Standby Database
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 …
Read More »Read Only Tables in Oracle
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 More »ORA-06502: PL/SQL: numeric or value error
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 …
Read More »Far Sync in Oracle 12c
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 …
Read More »Oracle Database Authentication Methods
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 …
Read More »Oracle STANDBY_MAX_DATA_DELAY 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 …
Read More »Oracle Active Data Guard
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 …
Read More »How To Configure Linux for Oracle Database(Redhat 5.9)
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 …
Read More »How To Install Oracle Grid Infrastructure 11g on Linux
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 …
Read More »