Re: ORA-04031 and EM Express 12c

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 13 May 2019 14:30:39 -0400

Alessandro, my search of the Oracle Support community reveals the following thread:

https://community.oracle.com/thread/2115503?tstart=135

It's about Oracle logical standby. Do you have something like this? Anyway, I would search MOS for the similar incidents and checked whether they apply to your situation.

Regards

On 5/13/19 10:33 AM, Alessandro Vercelli (Redacted sender alever22 for DMARC) wrote:

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: oracle@ora12db.network.local <mailto:oracle@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:(oracle@ora12db.network.local <mailto:oracle@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


--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217

Other related posts: