ORA-12504 TNS-12504 – TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

This error occurs when there was no default service configured for the listener and SERVICE_NAME was missing from the request received by the listener. When a user tries to connect to the listener, it may be servicing several different databases. If user specifies a service name in the connect request then the listener will connect…