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>

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s