Month: June 2019

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 get due to syntax error in listner.ora file. listener.ora file is case sensitive. small changes to files lead to an big problem. We …

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

Enable HTTPS for your WordPress website with SG Optimizer plugin | Siteground Plugin

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 website with SG Optimizer plugin. SG optimizer plugin comes with siteground hosting. SG Optimizer having significant benefit to increase the performance of website. …

Enable HTTPS for your WordPress website with SG Optimizer plugin | Siteground Plugin 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 for datafile 1 Follow the below steps to solve this error message. Shutdown the database. RMAN> shutdown immediate;database closeddatabase dismountedOracle instance shut down …

ORA-19573: cannot obtain exclusive enqueue for datafile 1 RM 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 job and have lot responsibility as its directly affecting to production environment.In this blog we will see the future responsibilities of oracle dba …

Oracle dba jobs will die in future due to autonomous database ? 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 . listener.ora is the database server level file and tnsnames.ora is the client side file. oracle listener service should be up and running to …

listener.ora and tnsnames.ora location in oracle 12c database 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 should know the difference between delete and truncate in oracle database. let’s see the difference between delete and truncate statement in oracle database. …

Difference between delete and truncate in oracle database ?- SQL Interview question 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 :- In this type of logging whatever oracle writes in a redo log file related to transactions in database, saved to another location after …

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

How to Set ORACLE_HOME & ORACLE_SID on Windows Server

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 define the path of Oracle Home (server) Directory. How to set ORACLE_HOME in Environment variable To set the ORACLE_HOME environment variable go to …

How to Set ORACLE_HOME & ORACLE_SID on Windows Server Read More »

How to check oracle database status – Interview question

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 might be down Check the instance status SQL>select instance_name, status from v$instance; Check whether the database can be read or write SQL>select name, …

How to check oracle database status – Interview question Read More »