Document Type | Troubleshooting
Category | Monitoring/Inspection
Applicable Product Versions | 6FS06, 6FS07, 6FS07PS, 6FS06, 6FS07, 6FS07PS
Error Code | 12123
Document Number | TMOTS003
Issue
When the _INC_DSPC_CNT parameter is set, performing a system memory dump (alter system dump systemalloc;) results in the error 'TBR-12123: An attempt to begin sysdump has failed.'
SQL> select name, dflt_value, value from _vt_parameter where name='_INC_DSPC_CNT'; NAME DFLT_VALUE VALUE ------------- ---------- ----- _INC_DSPC_CNT 0 1 SQL> alter system dump systemalloc; TBR-12123: An attempt to begin sysdump has failed.
Cause
In the TAC environment, when the _INC_DSPC_CNT parameter is applied, there is no exception handling logic for memory dump of the Dispatcher thread responsible for message reception, causing the dump operation to fail.
Note_INC_DSPC_CNT: The number of threads responsible for message reception during TCP communication between DB nodes
-- sys.log
[02-10T14:32:39.643097] [DDL-194] [I] Executing DDL: alter system dump systemalloc
[02-10T14:32:50.057710] [FRM-10] [I] The following working thread failed to stop. tid: 132 serial no: 0, pid: 22348072, status: 3.
[02-10T14:32:50.057857] [FRM-10] [I] An attempt to stop 22348072 process for sysdump has failed. Resuming all threads back to normal.
[02-10T14:32:50.068475] [FRM-194] [I] THROW. ec=ERROR_SYSDUMP_FAILED(-12123) [ An attempt to begin sysdump has failed.] (csr_id:4294967295) [dump_thread.c:858:scs_dump_phm]
[02-10T14:32:50.076763] [DDL-194] [I] DDL execution failed (ec = -12123): alter system dump systemalloc
SQL> select * from v$process where tid=132;
PID| TID| SPID| NAME| ATCHWAIT
---------|----------|----------|------------|---------------
10| 132| 20644352| DSPC| 0x00Solutions
Enhance the exception handling logic for the Dispatcher thread so that the memory dump can be performed normally. (Applied Patch: 326504a)
CautionApply the patch through technical support provided by Tmax Tibero.
โป Workaround: Do not use the _INC_DSPC_CNT parameter
CautionWarning To perform an allocator dump of the process, all threads except the control thread must be temporarily stopped. If even one thread cannot be stopped, the dump operation will fail with the TBR-12123 error.SQL> alter system dump systemalloc; TBR-12123: An attempt to begin sysdump has failed.