Submit a ticketCall us

AnnouncementsChange Is Inevitable

Get valuable help when it comes to tracking and monitoring changes. SolarWinds® Server Configuration Monitor (SCM) is designed to help you: detect, track, and receive alerts when changes occur, correlate system performance against configuration changes, compare server and application configuration against custom baselines, and verify application and system changes.

Learn more.

Home > Success Center > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > 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_ret on Jun 29, 2016

Views: 5,145 Votes: 2 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

Tags

Classifications

Public