Home » RDBMS Server » Server Administration » Ora-04030 (Oracle database 10gR2,Windows2003)
Ora-04030 [message #553868] Wed, 09 May 2012 00:33 Go to next message
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
Re: Ora-04030 [message #553872 is a reply to message #553868] Wed, 09 May 2012 01:13 Go to previous messageGo to next message
Michel Cadot
Messages: 67810
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Ora-04030 [message #553874 is a reply to message #553872] Wed, 09 May 2012 01:21 Go to previous messageGo to next message
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.
Re: Ora-04030 [message #553875 is a reply to message #553874] Wed, 09 May 2012 01:24 Go to previous messageGo to next message
Michel Cadot
Messages: 67810
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Ora-04030 [message #553878 is a reply to message #553875] Wed, 09 May 2012 01:36 Go to previous messageGo to next message
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


Re: Ora-04030 [message #553886 is a reply to message #553878] Wed, 09 May 2012 01:52 Go to previous messageGo to next message
Michel Cadot
Messages: 67810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Once again SGA size is irrelevant.

Regards
Michel
Re: Ora-04030 [message #553901 is a reply to message #553886] Wed, 09 May 2012 03:07 Go to previous messageGo to next message
cookiemonster
Messages: 13894
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.
Re: Ora-04030 [message #555037 is a reply to message #553901] Mon, 21 May 2012 02:04 Go to previous messageGo to next message
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
Re: Ora-04030 [message #555049 is a reply to message #555037] Mon, 21 May 2012 02:26 Go to previous messageGo to next message
Michel Cadot
Messages: 67810
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Ora-04030 [message #555050 is a reply to message #555049] Mon, 21 May 2012 02:31 Go to previous messageGo to next message
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
Re: Ora-04030 [message #555066 is a reply to message #555050] Mon, 21 May 2012 03:31 Go to previous messageGo to next message
Michel Cadot
Messages: 67810
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous message
Sami_Younis
Messages: 49
Registered: February 2008
Location: Egypt
Member

Any way,Thank you michel.
Previous Topic: Oracle RMAN backup
Next Topic: Purpose of creating standby control file
Goto Forum:
  


Current Time: Wed Apr 14 19:09:20 CDT 2021