Re: ORA-04031 and EM Express 12c

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_at_ora12db.network.local
> <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:(oracle_at_ora12db.network.local
> <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
>
>

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


--
http://www.freelists.org/webpage/oracle-l