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 »ORACLE
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 »How To Install Oracle RAC 11g
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 …
Read More »Oracle Date Functions
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 …
Read More »Oracle Numeric/Math Functions
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 …
Read More »What is Real Time Apply in Dataguard
What is real time apply in dataguard? If media recovery is started with the following command after installing Data Guard in versions prior to Oracle …
Read More »Oracle String Functions
This article contains information about oracle string functions such as length, substr, concat, trim in Oracle database management system. What is Oracle string function? Oracle …
Read More »ORA-48318: ADR Relation [HM_FINDING] of version=5 cannot be supported
In Oracle databases, when the downgrade operation or “migrate schema” operation is done through adrci, when using the adrci, ORA-48318 error is received when the …
Read More »How To Check Data Guard Status
We will check data guard status in SQL Plus in this article in many ways. Check 1: Check for LAG from V$DATAGUARD_STATS View. [crayon-6629807cb434b606909456/] [crayon-6629807cb4351054837416/] …
Read More »How To Find All Standby Databases for a Primary Database in Data Guard
You can find all standby databases for a primary database in data guard by using one of the queries below. [crayon-6629807cb4ad5569195032/] or [crayon-6629807cb4ada048815053/] Standby -> …
Read More »