Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > Server & Application Monitor (SAM) > ORA-12514: TNS: listener does not currently know of service requested in connect descriptor

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

Created by Christine Magbuo, last modified by Rodim Suarez on Jun 29, 2016

Views: 184 Votes: 1 Revisions: 4

Updated

Overview

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

Environment

All SAM versions

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.

 

Last modified
18:13, 28 Jun 2016

Tags

Classifications

Public