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 »
In our previous blog , We have seen how to add youtube subscribe button to our blog. In this article we are going to see how to enable HTTPS for your WordPress... Read more »
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 »
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 »
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 »
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 »
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 »
We will be finding out the way to set oracle environment path for windows server. What is ORACLE_HOME used for? The ORACLE_HOME is an environment variable which is used to set and... Read more »
let us find out the database health status by using following sql command. Check whether the Oracle Process run or not#> ps -ef | grep pmon If no pmon detected, your database... Read more »
In this video you will understand the use of unix command for daily dba life. you will find this command useful while while working on dba environment. 1. To Cleanup trace files... Read more »