Oracle Solution for Error ora-12224

ORA-12224: TNS:no listener

What triggered the Error:

The connection request could not be completed because the listener is not running.

What should we do to fix it:

Ensure that the supplied destination address matches one of the addresses used by the listener - compare the TNSNAMES.ORA entry with the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to go by way of an Interchange). Start the listener on the remote machine.