MGW_AGENT: mgw extproc connections fail with ORA-12537 and TNS-12518 reported in Listener log

(Doc ID 2362132.1)

Last updated on FEBRUARY 16, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2]
Oracle Net Services - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Running an Oracle Messaging Gateway Agent (mgw_agent) out of a 12.1.0.2 Database.
Using an Oracle Grid structure but single (standalone).
Upgrade was done for the GRID Home 12.1.0.2 to 12.2.0.1 but not the Database or Listener.


Tnsnames.ora file contains:

 

Changes

 This was triggered by the GRID being upgraded from 12.1.0.2 to 12.2.0.1 but not the Database Home.

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