ORA-04031 and EM Express 12c
Date: Mon, 13 May 2019 16:33:45 +0200
Message-Id: <16ab19d1d77.11296acb77598.787413121531982893_at_zoho.com>
Hi All,
after a long time (about 10 years), I started again to study Oracle DBMS so I tried 12c on a small KVM/libvirtd RHEL 6.4 (about 8 Gb RAM)
The first problem I noticed after installation is a strange ORA-04031, I say "strange" because it pops up only when logged into EM Express webgui, here some details from alert and trace files:
- alert file -
Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_s001_7290.trc (incident=31740):
ORA-04031: unable to allocate 28049976 bytes of shared memory ("large pool","unknown object","kxttIICDT: 4","kxttAssignMemory: 10")
- trace file -
Trace file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_s001_7290.trc
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Build label: RDBMS_12.2.0.1.0_LINUX.X64_170125
ORACLE_HOME: /u01/app/oracle/product/12.2.0/dbhome_1
System name: Linux
Node name: ora12db.network.local
Release: 2.6.32-358.el6.x86_64
Version: #1 SMP Tue Jan 29 11:47:41 EST 2013
Machine: x86_64
Instance name: ORCL
Redo thread mounted by this instance: 1
Oracle process number: 63
Unix process pid: 7290, image: mailto:oracle_at_ora12db.network.local (S001)
- 2019-05-13T16:26:26.993767+02:00
- SESSION ID:(273.61285) 2019-05-13T16:26:26.993800+02:00
- CLIENT ID:() 2019-05-13T16:26:26.993808+02:00
- SERVICE NAME:(SYS$USERS) 2019-05-13T16:26:26.993817+02:00
- MODULE NAME:(mailto:oracle_at_ora12db.network.local (S001)) 2019-05-13T16:26:26.993825+02:00
- ACTION NAME:() 2019-05-13T16:26:26.993833+02:00
- CLIENT DRIVER:() 2019-05-13T16:26:26.993840+02:00
DDE: Problem Key 'ORA 4031' was flood controlled (0x2) (incident: 31740)
ORA-04031: unable to allocate 28049976 bytes of shared memory ("large pool","unknown object","kxttIICDT: 4","kxttAssignMemory: 10")
- 2019-05-13T16:27:29.543925+02:00
DDE: Problem Key 'ORA 4031' was flood controlled (0x2) (incident: 31741)
ORA-04031: unable to allocate 28049976 bytes of shared memory ("large pool","unknown object","kxttIICDT: 4","kxttAssignMemory: 10")
I tried to increase values for shared_pool_size/shared_pool_reserved_size, sga_target but no success
Thanks for your time and suggestions
Alessandro
-- http://www.freelists.org/webpage/oracle-lReceived on Mon May 13 2019 - 16:33:45 CEST