Home » RDBMS Server » Server Administration » help:ORA-27102: out of memory (11.2.0.3)
help:ORA-27102: out of memory [message #658771] Mon, 26 December 2016 19:31 Go to next message
wanear
Messages: 8
Registered: December 2016
Junior Member
os:linux 5.8
oracle:11.2.0.3 rac
SQL> show parameter memory;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 50G
memory_target big integer 45G
shared_memory_address integer 0
SQL>
SQL>
SQL> show parameter sga;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 50G
sga_target big integer 33G
SQL> show parameter pga;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target big integer 11231M


SQL> !free -m
total used free shared buffers cached
Mem: 64411 60111 4299 0 275 46221
-/+ buffers/cache: 13615 50796
Swap: 10236 8339 1897





Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /u01/app/oracle/diag/rdbms/ncrac/ncrac11/trace/ncrac11_cjq0_6234.trc





Re: help:ORA-27102: out of memory [message #658772 is a reply to message #658771] Mon, 26 December 2016 19:38 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
when was last time it worked without error?
What changed since then?

What exactly was done that resulted in the error?

post content from file below

/u01/app/oracle/diag/rdbms/ncrac/ncrac11/trace/ncrac11_cjq0_6234.trc
Re: help:ORA-27102: out of memory [message #658781 is a reply to message #658771] Tue, 27 December 2016 01:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Align the columns in result.
Also always post your Oracle version, with 4 decimals, as solution depends on it.

Re: help:ORA-27102: out of memory [message #658972 is a reply to message #658781] Tue, 03 January 2017 02:33 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
Remember pga target is just that, a target. The database can and will ignore that. At least with manual management. I don't use auto management for anything important.

[Updated on: Tue, 03 January 2017 02:34]

Report message to a moderator

Re: help:ORA-27102: out of memory [message #659050 is a reply to message #658972] Thu, 05 January 2017 02:49 Go to previous message
wanear
Messages: 8
Registered: December 2016
Junior Member

finally,i reconfigure the pga and sga ,and disabled the AMM ,then,oracle goes well,thanks for all.
Previous Topic: help: i wanno get an oracle11g dsi
Next Topic: Idle instance
Goto Forum:
  


Current Time: Thu Mar 28 18:05:49 CDT 2024