ERROR OGG-02077 Extract encountered a read error in the asynchronous reader thread and is abending: Error code 4031, error message: ORA-04031: unable to allocate bytes of shared memory ("","","","").
查看oracle alert日志
Errors in file /opt/app/oracle/diag/rdbms/bdfn/BDFN/trace/BDFN_ms01_4186.trc:
ORA-04031: unable to allocate 536 bytes of shared memory ("streams pool","unknown object","Logminer LCR c","krvxbmtx")
LOGMINER: session#=1 (OGG$CAP_KFK_E001), builder MS01 pid=58 OS id=4186 sid=705 stopped
Errors in file /opt/app/oracle/diag/rdbms/bdfn/BDFN/trace/BDFN_ms03_4194.trc:
ORA-04031: unable to allocate 664 bytes of shared memory ("streams pool","unknown object","Logminer LCR c","krvuinl")
Errors in file /opt/app/oracle/diag/rdbms/bdfn/BDFN/trace/BDFN_ms02_4190.trc:
这里注意ogg从oracle抽取的数据都会进入内存streams pool,然而此时BDFN的oracle数据库是默认streams pool 256M(Streams Pool --- 10g 以后才有,和expdp原理一样)
原因分析
BDFN的oracle数据库上面的ogg的replica进程和dg的mining数据库进程,撑满了streams pool内存,导致内存不够ogg出现无法抓数据,然后进程没有报错的“假活”状态,关闭重启就会报streams pool相关联的shared memory不能分配问题。
深度追究
这里数据库设置了大页管理,这个设置是不允许动态管理sga
SQL> show parameter memory