Site icon IT Tutorial

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

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/

 

Exit mobile version