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

Mehmet Salih Deveci

4 years ago

Sometimes You can get ” ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA. ” error.

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

Details of error are as follows.

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

Cause: The listener was not configured with a default service and SERVICE_NAME was missing from the

CONNECT_DATA received by the listener.

Action: Possible solutions are:- Configure DEFAULT_SERVICE parameter in LISTENER.ORA with a valid service name.

Reload the listener parameter file using reload [<listener_name>]. This should be done by the LISTENER administrator.

– If using a service name, Check that the connect descriptor corresponding to the service name in

TNSNAMES.ORA has a SERVICE_NAME or SID component in the CONNECT_DATA.

If you got this error, check the entry for CONNECT_DATA was included in the same stanza as the ADDRESS_LIST, while it should be a separate stanza by itself.

Or Configure DEFAULT_SERVICE parameter in LISTENER.ORA with a valid service name.

Reload the listener parameter file using reload [<listener_name>]. This should be done by the LISTENER administrator.

– If using a service name, Check that the connect descriptor corresponding to the service name in

TNSNAMES.ORA has a SERVICE_NAME or SID component in the CONNECT_DATA.

Do you want to learn more details about RMAN, then read the following articles.

https://ittutorial.org/rman-backup-restore-and-recovery-tutorials-for-beginners-in-the-oracle-database/