Дек 102015
 

Настраивая недавно в рамках тестирования standby столкнулся с тем, что при попытке включить Active Data Guard/Real-Time Apply (т. е. в открытом экземпляре) экземпляр падал со следующей ошибкой:

Tue Dec 08 14:01:37 2015
Errors in file /u01/app/oracle/diag/rdbms/orcl02/orcl/trace/orcl_dbrm_18573.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01489: result of string concatenation is too long
DBRM (ospid: 18573): terminating the instance due to error 604
Tue Dec 08 14:01:38 2015
System state dump requested by (instance=1, osid=18573 (DBRM)), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/orcl02/orcl/trace/orcl_diag_18571_20151208140138.trc
Dumping diagnostic data in directory=[cdmp_20151208140138], requested by (instance=1, osid=18573 (DBRM)), summary=[abnormal instance termination].
Instance terminated by DBRM, pid = 18573

Continue reading »