12c Listener Issue: DIA-48001: [dbgfcsGetRegisterDef:2], [33], [33] & TNS-12537: Connection Closed
(Doc ID 2351592.1)
Last updated on MARCH 31, 2022
Applies to:
Oracle Net Services - Version 12.2.0.1 and laterInformation in this document applies to any platform.
This document describes an issue where a 12c listener is used to service connections to a lower version database.
In this specific case, a 12.2 listener services connections to a 12.1 database.
The problem is yielding both core dumps and numerous incident traces to be written in the RDBMS or database home.
In this case, the entry for the 12.1 instance was statically defined in the listener.ora file and not registered dynamically.
This issue can arise with any mismatch in version between listener (newer) and database (older).
Symptoms
A 12.2 version of the database listener is configured to service connections to a lower version of the database (Example, 12.1)
The listener.ora file contains a static entry or a SID_DESC for the lesser version database.
When a connection is attempted via the listener, the following errors are reported in an incident trace:
Wed Jan 17 12:48:00 2018
Errors in file /oracle/DB1/trace/diag/rdbms/myhostnamehere/DB11/trace/DB11_ora_24214.trc (incident=8001):
DIA-48001: internal error code, arguments: [dbgfcsGetRegisterDef:2], [33], [33], [], [], [], [], []
Incident details in: /oracle/DB1/trace/diag/rdbms/myhostnamehere/DB11/incident/incdir_8001/PU11_ora_24214_i8001.trc
DIA-48001: internal error code, arguments: [dbgfcsGetRegisterDef:2], [33], [33], [], [], [], [], []
DIA-48001: internal error code, arguments: [dbgfcsGetRegisterDef:2], [33], [33], [], [], [], [], []
The client may also receive a TNS-12537: TNS: Connection closed
There is likely a core dump in the following directory where the lower version database is installed:
$RDBMS_HOME/rdbms/log
Obtain this document and obtain a stack of the core file:
<Note: 1812.1> TECH: Getting a Stack Trace from a CORE file on Unix
A pstack or stack trace of the core file resembles:
root@oracle.xxxaaaa # pstack oracle.xxxaaaa.63717.core
core 'oracle.xxxaaaa.63717.core' of 63717: oracleDB1 (LOCAL=NO)
00000001112bd5a4 dbgc_cra (ffffffff7d301450, ffffffff7d30aa50, bb81, 0, 0, 114595a38) + 4
00000001105e727c kgeasnmierr (ffffffff7d301450, ffffffff7d30aa50, 1044ab970, 2, 0, 21) + 7c
00000001112beb90 dbgfcsIlcsRegister (ffffffff7d300640, 420, 21, 1, 18, 1) + 270
fffffffcc7f6da28 ossfilcsRegister (ffffffff7d300640, 2840, fffffffcc80a9288, 2800, fffffffcc80a92d8, 2820) + 508
000000010c7af208 dbkc_init (10c7a3000, 103db7000, 103c00, 103db7, 10c875, 0) + 1a8
000000010485002c opimai_real (2, ffffffff7ffff558, 0, ffffffff7dc01310, 103ace000, 1) + 2ac
000000010b549f08 ssthrdmain (fffffffffffe53e8, 10484fd80, 114468000, 114468, 114400, ffffffff7ffff558) + 1c8
000000010484fd40 main (2, ffffffff7ffff668, 0, ffffffff7ffff568, ffffffff7ffff678, 2800) + 140
000000010484fbac _start (0, 0, 0, 0, 0, 0) + 12c
root@oracle.xxxaaaa # file oracle.xxxaaaa.63717.core
oracle.xxxaaaa.63717.core: ELF 64-bit MSB core file SPARCV9 Version 1, from 'oracle'
root@oracle.xxxaaaa # file /u01/app/oracle/product/12.1.0.2/dbhome_1/bin/oracle
/u01/app/oracle/product/12.1.0.2/dbhome_1/bin/oracle: ELF 64-bit MSB executable SPARCV9 Version 1, dynamically linked, not stripped
Changes
This is likely a new installation of the 12.2 where (at least) the listener version has changed.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |