ORA-04031: unable to allocate 27992 bytes of shared memory ("shared pool",
M.M.RJun 5 2009 — edited Jun 6 2009Hi Experts,
I am trying to do the archivelog backup but getting..sharedpool releam error...!
I have flushed the Shared pool 2 to 3 times..Again i tried to backup..But getting the Same Error.
Please help me i cant shutdown and increase the Shared_Pool size now..It's a Critical Production Database.
SQL> show parameter shared_pool_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
shared_pool_size big integer 117440512
3:35:01 PM: Preethpal Singh: channel dev_1: Data Protector A.05.50/PHSS_35224/PHSS_35225/DPSOL_00241
released channel: dev_0
released channel: dev_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-12001: could not open channel dev_2
RMAN-10008: could not create channel context
RMAN-10003: unable to connect to target database using connect string "/"
ORA-04031: unable to allocate 27992 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","session param values")
Thanks In Advance.
Manohar.
Edited by: M.M.Reddy on Jun 5, 2009 3:09 AM
Edited by: M.M.Reddy on Jun 5, 2009 3:10 AM