OraFAQ Forum: Server Administration » help:ORA-27102: out of memory

Home » RDBMS Server » Server Administration » help:ORA-27102: out of memory (11.2.0.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

help:ORA-27102: out of memory [message #658771]

Mon, 26 December 2016 19:31

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

Report message to a moderator

Re: help:ORA-27102: out of memory [message #658772 is a reply to message #658771]

Mon, 26 December 2016 19:38

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

Report message to a moderator

Re: help:ORA-27102: out of memory [message #658781 is a reply to message #658771]

Tue, 27 December 2016 01:13

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: help:ORA-27102: out of memory [message #658972 is a reply to message #658781]

Tue, 03 January 2017 02:33

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

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.

Report message to a moderator

Previous Topic:	help: i wanno get an oracle11g dsi
Next Topic:	Idle instance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 16:51:20 CST 2024