ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Cause:
During remote connection of service from source database to destination , there was tns error which really annoy. This error mainly trigger due to either wrong tns entry or no entry at all in tnsnames.ora.
[oracle@orcl19x admin]$ rman target test/password@exdbx1
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Feb 14 23:05:05 2021
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Solution:
Check the tnsnamea.ora tns entry file and add the connection details string .Check for small spaces or indentation of the braces which also cause silly errors which lead us to frustation
[oracle@orcl19x admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /apps01/base/product/11.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL11X =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = orcl11x)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl11x)
)
)
exdbx1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = exdbadm01)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = exdbx)
)
)
After the tns entry addition , connection was successful!
[oracle@orcl19x admin]$ rman target test/password@exdbx1
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Feb 14 23:10:37 2021
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: EXDBX (DBID=572524948)
RMAN>