When you login into Oracle Database and it throws following error message: ORA-01033: ORACLE initialization …
Fixed – ORA-01033: ORACLE initialization or shutdown in progress Read More »
When you login into Oracle Database and it throws an error message: Ora-12560: TNS: protocol …
When you start your database and it throws following error: ORA-01078: failure in processing system …
Fixed – ORA-00844: Parameter not taking MEMORY_TARGET into account Read More »
It’s a prime responsibility of Oracle DBA to keep database up 24×7 but there may …
How to Enable/Disable Archive Log Mode in Oracle 10g/11g Read More »
What is an Index? Index is created on existing tables to retrieve data more quickly. …
This article will provide you a summary of the NULL functions available for handling null …
NVL, DECODE, NVL2, COALESCE-NULL Functions in Oracle Read More »
This article gives you an overview of the RANK, DENSE_RANK, FIRST and LAST analytic functions. …
Difference in RANK, DENSE_RANK, FIRST and LAST Analytic Functions Read More »
LAG and LEAD functions can be used in Oracle PL/SQL and apply on Oracle 12c, …
As a DBA, it’s your responsibility to multiplex redo log files just like multiplexing control …