ogg破案之内存设置使replicat进程abended

新装好的Oracle 12.2数据库在启动replicat进程的时候abended。 ogg日志报错： /ERROR                           : [/opt/app/oracle/products/ogg/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]                           : [  : [/opt/app/oracle/products/ogts/oglicat(ggs::gglib::MultiThreiThre::MainThread::Run(int, char char ]                           : [/opt/app/oracle/products/ogg/replicat()]                           : [/opt/app/oracle/products/ogg/replicat()]                           : [/opt/app/oracle/products/ogg/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, c`^A]                           : [/opt/app/oracle/products/ogg/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, c`^A]                           : [/opt/app/oracle/products/ogg/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, c`^A]                           : [_ZN3ggs5gglib14MultiThreading6Thread9RunThreadEPNS2_10ThreadArgsE]                           : [/opt/app/oracle/products/ogg/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, c`^A]                           : [_ZN3ggs5gglib14MultiThreading6Thread9RunThreadEPNS2_10ThreadArgsE]                           : [/opt/app/oracle/products/ogg/replicat()]                           : [/opt/app/oracle/products/ogg/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, c`^A]                           : [/opt/app/oracle/products/ogg/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]                           : [/opt/app/oracle/products/ogg/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]                           : [/opt/app/oracle/products/ogg/replicat()]                           : [/opt/app/oracle/products/ogg/replicat()]                           : [/opt/app/oracle/products/ogg/replicat()] 2018-11-27 14:32:06  ERROR   OGG-00664  OCI Error Flushing database inbound server, 'OGG$MI_RE01' (status = 26815-ORA-26815: ^Z^Z^Z^Z^Z^Z^Z^Z "OGG$MI_RE01" ^Z^Z^Z^Z^Z^Z "replicat" ^Z^Z^Z^Z^Z^Z^Z^Z^Z^Z^Z^Z^Z^Z^Z^Z^Z^Z^Z^Z^Z^Z ORA-04031: ^Z^Z^Z^Z^Z^Z^Z^Z 120 ^Z^Z^Z^Z^Z^Z^Z^Z^Z^Z^Z^Z^Z^Z ("streams pool","unknown object",). 数据库alert日志报错 2018-11-27T14:32:14.275308+08:00 GoldenGate APPLY AP01 for OGG$MI_RE01 with pid=208, OS id=99648 stopped 2018-11-27T14:32:16.054518+08:00 Errors in file /opt/app/oracle/diag/rdbms/baseblog/BASEBLOG/trace/BASEBLOG_q002_99687.trc  (incident=11002): ORA-04031: unable to allocate 3280 bytes of shared memory ("streams pool","unknown object","streams pool","sob_kgqmrec") Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. trace文件 DDE: Problem Key 'ORA 4031' was flood controlled (0x2) (incident: 11002) ORA-04031: unable to allocate 3280 bytes of shared memory ("streams pool","unknown object","streams pool","sob_kgqmrec") KSV 4031 error in slave process *** 2018-11-27T14:32:16.073462+08:00 ORA-04031: unable to allocate 3280 bytes of shared memory ("streams pool","unknown object","streams pool","sob_kgqmrec") OPIRIP: Uncaught error 447. Error stack: ORA-00447: fatal error in background process ORA-04031: unable to allocate 3280 bytes of shared memory ("streams pool","unknown object","streams pool","sob_kgqmrec") 造成replicat进程abended的原因是无法分配流池内存。Oracle建议一根replicat进程要至少1.25G内存，ogg的内存是占用SGA的流池的，这里我是静默安装，内存参数还没有调整，sga内存太小，无法分配足够内存给流池，造成上述报错。 调整内存 vm.nr_hugepages=30721 sysctl -p alter system set sga_max_size=63G scope=spfile; alter system set sga_target=50G scope=spfile; alter system set pga_aggregate_target=15G scope=both; alter system set pga_aggregate_limit=30G scope=spfile; alter system set streams_pool_size=3G scope=spfile; SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup 注意： 12c中是用pga_aggregate_limit控制pga内存最大使用(hard limit)。 pga_aggregate_limit=max(2*pga_aggregate_target,3*PROCESSES) 启动复制进程 start mi_re01 启动后alert日志中： 2018-11-27T15:33:39.540140+08:00 APPLY OGG$MI_RE01: Source Database: NULL APPLY OGG$MI_RE01: Source Root Name: NULL APPLY OGG$MI_RE01: Applied Message Number: 180483887 APPLY OGG$MI_RE01: Message Create Time: 00:01, 2018/11/27 2018-11-27T15:33:40.368336+08:00 Propagation Receiver (CCA) for GoldenGate replicat and Apply OGG$MI_RE01 with pid=44, OS id=105183, objnum=0 , LCRID ver=2 started.