OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Ora-04030 (Oracle database 10gR2,Windows2003)

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

Ora-04030 [message #553868]

Wed, 09 May 2012 00:33

Sami_Younis
Messages: 49
Registered: February 2008
Location: Egypt

Member

We have 2 databases(primary and physical standby) configured to run in Dataguard(maximum performance mode),
the primary is encountering the error ora-04030 and other errors in alert.log file.
I have attached the alert.log file to have a full background on what's going on.

Note: I have increased SGA_TARGET from 900m to 1500m but the error still exist.and one more time i tried to increase sga_target to 2G but the database not opened after restart with shared memory reclaim error.

Thanks,
Sami

Attachment: alert_orion (2).log
(Size: 12.00KB, Downloaded 1795 times)

Report message to a moderator

Re: Ora-04030 [message #553872 is a reply to message #553868]

Wed, 09 May 2012 01:13

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

Senior Member
Account Moderator

ORA-04030: out of process memory when trying to allocate %s bytes (%s,%s)
 *Cause:  Operating system process private memory has been exhausted

No Oracle parameter is involved there, it is an OS error Oracle gets, it is the victim.
General answer: increase stack and memory limit at OS level for oracle account.
As you are on Windows, the only thing you can do, afaik, is to increase the RAM of your server.

Regards
Michel

Report message to a moderator

Re: Ora-04030 [message #553874 is a reply to message #553872]

Wed, 09 May 2012 01:21

Sami_Younis
Messages: 49
Registered: February 2008
Location: Egypt

Member

thank you so much Michel.
Database server RAM is 16 Giga,but I can't even increase SGA_MAX_SIZE to 2GB to increase SGA_TARGET.
So there is no point in inceasing physical RAM.
thanks again,
Sami.

Report message to a moderator

Re: Ora-04030 [message #553875 is a reply to message #553874]

Wed, 09 May 2012 01:24

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

Senior Member
Account Moderator

Quote:

but I can't even increase SGA_MAX_SIZE to 2GB to increase SGA_TARGET

As I said, this error is NOT related to any Oracle parameters.
ONLY to memory that OS can allocate to Oracle process.
Once again there is NOTHING you can do at Oracle side.

Regards
Michel

Report message to a moderator

Re: Ora-04030 [message #553878 is a reply to message #553875]

Wed, 09 May 2012 01:36

Sami_Younis
Messages: 49
Registered: February 2008
Location: Egypt

Member

Ok!
But, physical memory is 16 GB Oracle SGA is 1500 M.
you mean that 1500M are enough and the problem in the allocation of the 1500M?
Thanks,
Sami

Report message to a moderator

Re: Ora-04030 [message #553886 is a reply to message #553878]

Wed, 09 May 2012 01:52

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

Senior Member
Account Moderator

Once again SGA size is irrelevant.

Regards
Michel

Report message to a moderator

Re: Ora-04030 [message #553901 is a reply to message #553886]

Wed, 09 May 2012 03:07

cookiemonster
Messages: 13959
Registered: September 2008
Location: Rainy Manchester

Senior Member

If you have 16GB of ram and are hitting this error with an SGA of 1500M than that suggests something other than oracle is using up all the ram on the server.
You need to see what other programs are installed and what they are doing.

Report message to a moderator

Re: Ora-04030 [message #555037 is a reply to message #553901]

Mon, 21 May 2012 02:04

Sami_Younis
Messages: 49
Registered: February 2008
Location: Egypt

Member

The problem is OS related.
and it successfully solved when i migrated to 64bit OS
Thanks all

Report message to a moderator

Re: Ora-04030 [message #555049 is a reply to message #555037]

Mon, 21 May 2012 02:26

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

Senior Member
Account Moderator

Thanks for the feedback.
I hope next time you will trust us when we'll say it is not a problem at Oracle side.

Regards
Michel

Report message to a moderator

Re: Ora-04030 [message #555050 is a reply to message #555049]

Mon, 21 May 2012 02:31

Sami_Younis
Messages: 49
Registered: February 2008
Location: Egypt

Member

Okay, I will
But nobody recommend to migrate the platform or even talked about the OS as a prospective cause.
It is not Oracle related...ok So what?
Any way,Thanks for everyone replied me

Report message to a moderator

Re: Ora-04030 [message #555066 is a reply to message #555050]

Mon, 21 May 2012 03:31

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

Senior Member
Account Moderator

Quote:

But nobody recommend to migrate the platform or even talked about the OS as a prospective cause

Really?

My first answer:
Quote:

No Oracle parameter is involved there, it is an OS error Oracle gets, it is the victim.
General answer: increase stack and memory limit at OS level for oracle account.
As you are on Windows, the only thing you can do, afaik, is to increase the RAM of your server.

My second answer:
Quote:

As I said, this error is NOT related to any Oracle parameters.
ONLY to memory that OS can allocate to Oracle process.
Once again there is NOTHING you can do at Oracle side.

If we first say: change platform, did you hear us when you do NOT hear it is NOT related to Oracle and still asked for Oracle parameter values?

Regards
Michel

[Updated on: Mon, 21 May 2012 03:38]

Report message to a moderator

Re: Ora-04030 [message #555069 is a reply to message #555066]

Mon, 21 May 2012 03:35

Sami_Younis
Messages: 49
Registered: February 2008
Location: Egypt

Member

Any way,Thank you michel.

Report message to a moderator

Previous Topic:	Oracle RMAN backup
Next Topic:	Purpose of creating standby control file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 02:41:20 CST 2024