中烟Oracle故障

从3月6日12:31开始有报错，主要报ORA-04031, ORA-00604

Sun Mar  6 12:31:30 2016
Errors in file /oracle/ECP/saptrace/background/ecp_smon_6190.trc:
ORA-04031: unable to allocate 4120 bytes of shared memory ("shared pool","update sys.col_usage$ set   ...","Typecheck","kgghteInit")
Sun Mar  6 12:31:31 2016
Errors in file /oracle/ECP/saptrace/background/ecp_smon_6190.trc:
ORA-04031: unable to allocate 4120 bytes of shared memory ("shared pool","update sys.col_usage$ set   ...","Typecheck","kgghteInit")
Sun Mar  6 12:31:32 2016
Errors in file /oracle/ECP/saptrace/background/ecp_smon_6190.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4120 bytes of shared memory ("shared pool","select f.file#, f.block#, f....","Typecheck","seg:kggfaAllocSeg

在3月7日08:00开始报相同的错误。

Beginning log switch checkpoint up to RBA [0x13c6b.2.10], SCN: 40201962836
Thread 1 advanced to log sequence 81003
  Current log# 6 seq# 81003 mem# 0: /oracle/ECP/origlogB/log_g16_m1.dbf
    Current log# 6 seq# 81003 mem# 1: /oracle/ECP/mirrlogB/log_g16_m2.dbf
    Mon Mar  7 07:53:18 2016
    Incremental checkpoint up to RBA [0x13c6a.145e1.0], current log tail at RBA [0x13c6b.24ff.0]
    Mon Mar  7 07:55:16 2016
    Completed checkpoint up to RBA [0x13c6b.2.10], SCN: 40201962836
    Mon Mar  7 08:00:49 2016
    Errors in file /oracle/ECP/saptrace/usertrace/ecp_ora_25515.trc:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-04031: unable to allocate 4120 bytes of shared memory ("shared pool","select name,online$,contents...","Typecheck","kgghteInit")
    ORA-00604: error occurred at recursive SQL level 1
    ORA-04031: unable to allocate 4120 bytes of shared memory ("shared pool","select name,online$,contents...","Typecheck","kgghteInit")
    ORA-00604: error occurred at recursive SQL level 2
    ORA-04031: unable to allocate 4120 bytes of shared memory ("shared pool","select name,password,datats#...","Typecheck","kgghteInit")
    Mon Mar  7 08:00:52 2016
    Errors in file /oracle/ECP/saptrace/background/ecp_cjq0_6194.trc:
    ORA-00604: error occurred at recursive SQL level 3
    ORA-04031: unable to allocate 4120 bytes of shared memory ("shared pool","select name,online$,contents...","Typecheck","kgghtInit")
    Mon Mar  7 08:23:24 2016
    Incremental checkpoint up to RBA [0x13c6b.dfd6.0], current log tail at RBA [0x13c6b.10a1b.0]
    Mon Mar  7 08:27:50 2016

在3月7日11:00至11:54分开始一直报ORA-04031和ORA-00604错误，

Mon Mar  7 11:54:18 2016
Errors in file /oracle/ECP/saptrace/background/ecp_cjq0_6194.trc:
ORA-00604: error occurred at recursive SQL level 3
ORA-04031: unable to allocate 4120 bytes of shared memory ("shared pool","select name,password,datats#...","Typecheck","kgghteInit")
Mon Mar  7 11:54:47 2016
Starting ORACLE instance (normal)
Mon Mar  7 11:54:47 2016
Specified value of sga_max_size is too small, bumping to 3539992576
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.

数据库配制（实际启动配制）

首頁/2016-03-07

中烟Oracle故障