Oracle 19C Installation on Windows 10

In this blog post we will discuss about the oracle 19c installation on windows server. Here is the latest version of oracle 19c installation steps on the top of windows operating system.... Read more »
Oracle database 12c installation

Oracle Database 12c Installation On Oracle Linux 5 (OEL5)

In this blog, We will discuss about the installation of oracle database 12c release 1 on the top of oracle linux 5.6. Download the Oracle Linux 5.6 Oracle linux can be download... Read more »
Yum Local Repository for oracle database package installation on OEL and Redhat linux server

Yum Local Repository for oracle database package installation on OEL and Redhat linux server

Hello Everyone!! In this blog , we will see about the configuration of yum local repository for oracle linux and redhat linux server. We can use this yum repository for the oracle... Read more »

ORA-16047: DGID mismatch between destination setting and target database

In our previous blog ,We have seen how to resolve the dataguard ORA- error related to ORA-19573: cannot obtain exclusive enqueue for datafile 1 RM. In this blog, I will explain you... Read more »

TNS-01150: The address of the specified listener name is incorrect

Below error occur while checking the status of listener or starting the listener services. TNS-01150: The address of the specified listener name is incorrectNL-00303: syntax error in NV string Above error can... Read more »

ORA-19573: cannot obtain exclusive enqueue for datafile 1 RM

Received below error while doing the dataguard restoration on standby database. RMAN-03002: failure of restore command at 06/30/2019 13:23:19 ORA-19870: error while restoring backup piece /data/rman/CDB/CDB1_D_20190607_0au 3g8ip_s10_p1 ORA-19573: cannot obtain exclusive enqueue... Read more »

Oracle dba jobs will die in future due to autonomous database ?

Many dba’s have the question related to oracle dba career and opportunity of oracle dba in future and worried about whether oracle dba jobs will die in future. oracle dba is serious... Read more »
listener.ora and tnsnames.ora location in oracle 12c database

listener.ora and tnsnames.ora location in oracle 12c database

In our previous blog We have seen about the error message related to the address of tnsnames.ora file. In this blog we will see the location of listener.ora and tnsnames.ora file .... Read more »

Difference between delete and truncate in oracle database ?- SQL Interview question

In my previous blog , I have written about the future of oracle dbs jobs. If you are going for sql or oracle interview then most of the interviewer expect that you... Read more »

How to put database in Archive/No-Archive log mode?- Oracle Interview question

In this blog I will show you the importance of archive and no-archive log mode. Mode of Logging There are two types of logging modes in Oracle database :- 1. ARCHIVELOG :-... Read more »