IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
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_DATAAction: 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.
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.
