We get the error 'Unable to establish the connection with the database. ORA-12541: TNS: No Listener.' This is common when attempting to run the URT from the Enforce server fails each time attempted.
Error: unable to establish db connection for user protect: ORA-12541: TNS:no listener
It could be possible that the Listener service is not running on the Oracle Server.
To resolve the issue, follow the steps below:
Check if the Listener service is running on the Oracle Server. If not, start the Listener service.
If the ORACLE_HOME path or the %ORACLE_HOME%\bin path do not exist on the system you may need to add them.
Add the ORACLE_HOME to the system environment variables on the Enforce server.
Add %ORACLE_HOME%\bin to the system PATH variable on the Enforce server.
If it was already running, then ensure that the supplied destination address matches one of the addresses used by the listener - compare the TNSNAMES.ORA (Enforce) entry with the appropriate LISTENER.ORA (Oracle) file.