Home » RDBMS Server » Backup & Recovery » ORA-04031: unable to allocate 27992 bytes of shared memory While Taking RMAN Backup. (Solaries5.10.(9.2.0.8.0).)
icon5.gif  ORA-04031: unable to allocate 27992 bytes of shared memory While Taking RMAN Backup. [message #395032] Tue, 31 March 2009 02:30 Go to next message
madhavamanohar
Messages: 58
Registered: February 2009
Member





released channel: dev_0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-12001: could not open channel dev_1
RMAN-10008: could not create channel context
RMAN-10003: unable to connect to target database using connect string "sys/hp4syspwd@EAITEST"
ORA-04031: unable to allocate 27992 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","session param val
ues")

Please FInd The shared pool memory here..

hi_shared_memory_address integer 0
max_shared_servers integer 20
shared_memory_address integer 0
shared_pool_reserved_size big integer 3355443
shared_pool_size big integer 67108864
shared_server_sessions integer 0
shared_servers integer 0


Can Any one help me..Thanks In advance..
Re: ORA-04031: unable to allocate 27992 bytes of shared memory While Taking RMAN Backup. [message #395034 is a reply to message #395032] Tue, 31 March 2009 02:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Configure a large pool (see LARGE_POOL_SIZE) you will then have (about) no more problem to allocate the channels.

Regards
Michel
Re: ORA-04031: unable to allocate 27992 bytes of shared memory While Taking RMAN Backup. [message #395044 is a reply to message #395034] Tue, 31 March 2009 03:01 Go to previous messageGo to next message
madhavamanohar
Messages: 58
Registered: February 2009
Member
Hi Michel


Large Pool already configured..

SQL> show parameter large

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
large_pool_size big integer 16777216


Re: ORA-04031: unable to allocate 27992 bytes of shared memory While Taking RMAN Backup. [message #395056 is a reply to message #395044] Tue, 31 March 2009 03:54 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Increase your shared_pool_size value

Babu
Re: ORA-04031: unable to allocate 27992 bytes of shared memory While Taking RMAN Backup. [message #395064 is a reply to message #395044] Tue, 31 March 2009 04:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is too small otherwise RMAN/Oracle would not try to allocate space in shared pool.
Remember that large pool is used by other components like parallel queries.

Regards
Michel
Re: ORA-04031: unable to allocate 27992 bytes of shared memory While Taking RMAN Backup. [message #395066 is a reply to message #395056] Tue, 31 March 2009 04:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is not the place for social discussion, PM him if you want to talk with him.

Regards
Michel
Re: ORA-04031: unable to allocate 27992 bytes of shared memory While Taking RMAN Backup. [message #395069 is a reply to message #395056] Tue, 31 March 2009 04:17 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


As per Mr Michel, Try to increase large pool size <= shared pool size.

RMAN-10003: unable to connect to target database using connect string "sys/hp4syspwd@EAITEST"
ORA-04031: unable to allocate 27992 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","session param val


Your checking shared pool and large pool size in "EAITEST" database??
Re: ORA-04031: unable to allocate 27992 bytes of shared memory While Taking RMAN Backup. [message #395073 is a reply to message #395069] Tue, 31 March 2009 04:26 Go to previous messageGo to next message
madhavamanohar
Messages: 58
Registered: February 2009
Member
Soory Michel ...and Babu I am new to this FAQ ..

So I am not aware of rules...

Yes Babu am checking in EAITEST DB..

Ok I ll increase the shared pool memory equal to large pool.
Re: ORA-04031: unable to allocate 27992 bytes of shared memory While Taking RMAN Backup. [message #395078 is a reply to message #395073] Tue, 31 March 2009 04:42 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


This is the link to learn OraFaq Rules...

http://www.orafaq.com/forum/t/88153/0/


>>I ll increase the shared pool memory equal to large pool.

Please increase your large pool size upto 20-40% of shared pool size. Not equal size.

Babu
Re: ORA-04031: unable to allocate 27992 bytes of shared memory While Taking RMAN Backup. [message #395104 is a reply to message #395078] Tue, 31 March 2009 05:40 Go to previous messageGo to next message
madhavamanohar
Messages: 58
Registered: February 2009
Member

SQL> show parameter shared

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
max_shared_servers integer 20
shared_memory_address integer 0
shared_pool_reserved_size big integer 3355443
shared_pool_size big integer 67108864
shared_server_sessions integer 0
shared_servers integer 0
SQL> show parameter large

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
large_pool_size big integer 16777216
SQL>

The Large pool memory is alredy..having 40% of Shared pool
memory..

How much can i increase ?

Whether Large pool r shared poool?

Current shrepool size=64mb
" Large pool size=16mb.

Help me.
Re: ORA-04031: unable to allocate 27992 bytes of shared memory While Taking RMAN Backup. [message #395108 is a reply to message #395104] Tue, 31 March 2009 05:47 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Ram Size please

Babu
Re: ORA-04031: unable to allocate 27992 bytes of shared memory While Taking RMAN Backup. [message #395109 is a reply to message #395108] Tue, 31 March 2009 05:49 Go to previous messageGo to next message
madhavamanohar
Messages: 58
Registered: February 2009
Member
eaitnacc:EAITEST:>top
last pid: 8046; load averages: 2.29, 2.20, 2.20 12:48:36
679 processes: 673 sleeping, 1 zombie, 3 stopped, 2 on cpu
CPU states: 87.0% idle, 1.4% user, 11.5% kernel, 0.0% iowait, 0.0% swap
Memory: 32G real, 17G free, 18G swap in use, 48G swap free

PID USERNAME LWP PRI NICE SIZE RES STATE TIME CPU COMMAND
21860 eaiuser1 18 60 0 82M 29M cpu/8 231.7H 4.00% stceway.exe
29259 eaiuser1 27 59 0 104M 54M sleep 71:02 2.88% stceway.exe
21797 root 1 1 19 12M 10M sleep 184:58 0.71% lsof
163 eaiuser1 52 59 0 15M 9464K sleep 666:10 0.17% stciqmgrd.exe
366 eaiuser1 15 1 0 95M 50M sleep 654:53 0.17% stcewjx.exe
8983 root 1 59 0 19M 6112K sleep 211:08 0.15% scopeux
14808 eaiuser1 2 1 0 1606M 48M sleep 23.9H 0.13% stccb.exe
5343 eaiuser1 17 58 0 82M 34M sleep 21.1H 0.12% stceway.exe
8010 oracle 1 59 0 4360K 2856K cpu/1 0:00 0.09% top
26507 eaiuser1 17 59 0 92M 47M sleep 410:07 0.09% stceway.exe
5342 eaiuser1 17 59 0 82M 34M sleep 21.1H 0.07% stceway.exe
162 eaiuser1 145 59 0 23M 13M sleep 198:07 0.06% stciqmgrd.exe
395 eaiuser1 30 59 0 72M 27M sleep 183:01 0.05% stceway.exe
4018 root 3 59 0 5192K 2424K sleep 21.8H 0.05% MultiNICBAgent
392 eaiuser1 26 59 0 71M 27M sleep 157:02 0.05% stceway.exe

Plese fid the TOP out put..
Re: ORA-04031: unable to allocate 27992 bytes of shared memory While Taking RMAN Backup. [message #395118 is a reply to message #395109] Tue, 31 March 2009 06:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have 32G RAM (17G free) and only use 60M for shared pool and 16M for large pool! You can easily use 300M and 100M then your instance will breathe.

Regards
Michel
Re: ORA-04031: unable to allocate 27992 bytes of shared memory While Taking RMAN Backup. [message #395128 is a reply to message #395118] Tue, 31 March 2009 07:20 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


1/ Are you sure; You have 32G Ram size??

2/ Post output the below command.

prtconf |grep Mem

3/ If yes; As per Mr Mic; Increase your shared pool size

Babu
Re: ORA-04031: unable to allocate 27992 bytes of shared memory While Taking RMAN Backup. [message #395305 is a reply to message #395128] Wed, 01 April 2009 02:05 Go to previous messageGo to next message
madhavamanohar
Messages: 58
Registered: February 2009
Member
Hi Babu and Michel.


I have increased the sharedpool size upto 100m and largepool size upto 35 gb.

Now the Backups are completed sucessfully.

Thanks For your Support.

Re: ORA-04031: unable to allocate 27992 bytes of shared memory While Taking RMAN Backup. [message #395308 is a reply to message #395128] Wed, 01 April 2009 02:15 Go to previous messageGo to next message
madhavamanohar
Messages: 58
Registered: February 2009
Member
HI Babu And Michel

I have increased the shared pool size up to 100m and Largepool size up to 40 m.

Now the backup's are running Fine.

Thanks For Your Support.

[Updated on: Wed, 01 April 2009 02:16]

Report message to a moderator

Re: ORA-04031: unable to allocate 27992 bytes of shared memory While Taking RMAN Backup. [message #395330 is a reply to message #395308] Wed, 01 April 2009 02:43 Go to previous message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.

Regards
Michel
Previous Topic: 9i DataGuard
Next Topic: RMAN incremental backup failed
Goto Forum:
  


Current Time: Sun Nov 03 06:56:55 CST 2024