EM 131c: Upgrade to Enterprise Manager 13.2 Cloud Control Results in Repository Database Alert Log TNS Errors: TNS-12564, Fatal NI connect error 12514, Fatal NI connect error 12505 (Doc ID 2247319.1)

Last updated on MARCH 25, 2017

Applies to:

Enterprise Manager Base Platform - Version 13.1.0.0.0 to 13.2.0.0.0 [Release 13.1 to 13.2]
Information in this document applies to any platform.

Symptoms

After  upgrade to Enterprise Manager (EM) 13c Cloud Control, many TNS errors are reported in one of the repository database nodes:

From the repository database alert_log file:

Fatal NI connect error 12514, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=<db name>)(CID=(PROGRAM=oracle)(HOST=<host2>)(USER=oracle))))

 VERSION INFORMATION:
       TNS for Linux: Version 12.1.0.2.0 - Production
       TCP/IP NT Protocol Adapter for Linux: Version 12.1.0.2.0 - Production
 Time: 15-FEB-2017 18:38:28
 Tracing not turned on.
 Tns error struct:
   ns main err code: 12564

TNS-12564: TNS:connection refused
   ns secondary err code: 0
   nt main err code: 0
   nt secondary err code: 0
   nt OS err code: 0
.
.
.
Fatal NI connect error 12505, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SID=<db name>)(CID=(PROGRAM=oracle)(HOST=host2)(USER=oracle))))

 VERSION INFORMATION:
       TNS for Linux: Version 12.1.0.2.0 - Production
       TCP/IP NT Protocol Adapter for Linux: Version 12.1.0.2.0 - Production
 Time: 15-FEB-2017 18:38:28
 Tracing not turned on.
 Tns error struct:
   ns main err code: 12564

TNS-12564: TNS:connection refused
   ns secondary err code: 0
   nt main err code: 0

nt secondary err code: 0
   nt OS err code: 0
.
.
.
SQL ordered by Parse Calls
Total Parse Calls: 1,053,499
Captured SQL account for 30.8% of Total
Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
300,603 300,596 28.53 16x4ffvmkhtbb DBMS_SCHEDULER begin :con := "EM_USER_MODEL"....



 

 

Changes

 

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