Applications Systems

ORA-12514: TNS: listener does not currently know of service requested in connect descriptor

Oracle Database template is displaying error: ORA-12514. TNS listener does not currently know of service requested in connect descriptor. Receiving Oracle errors on components monitors.

First published date

10/11/2018 8:20 PM

Last published date

4/1/2020 4:03 PM

Overview

This article describes how to resolve the ORA-12514 error when using the Oracle Database template. 

Product section

Server Application Monitor

Cause

The error is encountered when polling a component. 

This is basically due to an incorrect 'Destination Point Name' field component monitor pointing to old or wrong service name.

Oracle database was moved to another cluster that is using a new 'Service Name'.

The 'Destination Point Name' field within the Oracle database template should reflect the new or current 'Service Name'.

Resolution

  1. Determine the name or SID of the database by referring to the tnsnames.ora Oracle configuration file. 

    Look for something like the following: 

    tnsnames.ora:
ORA11 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = sales.us.example.com)))

     

  2. The 'Destination Point Name' should reflect the current Service Name (ex. SERVICE_NAME = sales.us.example.com)

  3. Click Submit on the template and the error should no longer appear within the template.