Critical Alert Raised in Grid Control With Error : Failed To Connect To Database Instance ORA-12519 (Doc ID 456700.1)

Last updated on MARCH 08, 2017

Applies to:

Enterprise Manager Base Platform - Version 10.2.0.1 to 11.1.0.1 [Release 10.2 to 11.1]
Information in this document applies to any platform.
Checked for relevance on 15-Feb-2013
Checked for relevance on 17-Jul-2014

Symptoms

In Grid Control navigate to:

TARGETS > DATABASES > [ Select Database Target ] > Related Links : Metric Collection Errors

The following metric error is reported:

Target Name=<DATABASE_NAME>
Target Type=Database Instance
Host=<HOSTNAME>
Metric=Status
Metric Value=0
Timestamp=4/07/2007 16:22:52 EST
Severity=Critical
Message=Failed to connect to database instance: ORA-12519: TNS:no appropriate service handler
found (DBD ERROR: OCIServerAttach).
Notification Rule Name=Database Availability and Critical States
Notification Rule Owner=SYSMAN

In the <AGENT_ORACLE_HOME>/sysman/emagent.trc file, the following error is logged:

2007-07-04 15:54:59 Thread-249521 ERROR fetchlets.oslinetok: Process stderr = em_error=Could not connect to dbsnmp/(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<HOSTNAME>)(Port=<LISTENER_PORT>))(CONNECT_DATA=(SID=<ORACLE_SID>)))
: ORA-12519: TNS:no appropriate service handler found (DBD ERROR: OCIServerAttach)

2007-07-04 15:54:59 Thread-249521 ERROR engine: [oracle_database,<ORACLE_SID>,archFull] : nmeegd_GetMetricData failed : em_error=Could not connect to dbsnmp/(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<HOSTNAME>)(Port=<LISTENER_PORT>))(CONNECT_DATA=(SID=<ORACLE_SID>)))
: ORA-12519: TNS:no appropriate service handler found (DBD ERROR: OCIServerAttach)

2007-07-04 15:54:59 Thread-249521 WARN collector: <nmecmc.c> Error exit. Error message: em_error=Could not connect to dbsnmp/(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<HOSTNAME>)(Port=<LISTENER_PORT>))(CONNECT_DATA=(SID=<ORACLE_SID>)))
: ORA-12519: TNS:no appropriate service handler found (DBD ERROR: OCIServerAttach) 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms