dba

ORA-12502 TNS-12502 TNS:LISTENER RECEIVED NO CONNECT_DATA FROM CLIENT TNS:listener received no CONNECT_DATA from client Cause:No CONNECT_DATA was passed to the listener. Action: Check that the service name resolved from TNSNAMES.ORA has the CONNECT_DATA component of the connect descriptor. Below is the sample entry of tnsnames.ora:- So for the service name please ensure you have the […]

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 […]

In this blog we will see you how to put database in archive log mode and no archive log mode. Oracle database have two kind of log mode Archive log mode No Archive log mode. Database can be put in archive log mode whenever we want to take hot backup. Roll forward is possible with […]