IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
Hi,
Sometimes You can get “TNS-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA ” error.
Details of error are as follows.
TNS-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATAReload 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.
https://ittutorial.org/rman-backup-restore-and-recovery-tutorials-for-beginners-in-the-oracle-database/
