OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ORA-04030 (Oracle 11g)

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

ORA-04030 [message #595357]

Tue, 10 September 2013 10:25

oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI

Member

Hi all,
We faced ORA-04030 error.How to solve this.Is it Server's RAM related issue?

Report message to a moderator

Re: ORA-04030 [message #595358 is a reply to message #595357]

Tue, 10 September 2013 10:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

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

[oracle@localhost ~]$ oerr ora 4030
04030, 00000, "out of process memory when trying to allocate %s bytes (%s,%s)"
// *Cause:  Operating system process private memory was exhausted.
// *Action:

Report message to a moderator

Re: ORA-04030 [message #595359 is a reply to message #595358]

Tue, 10 September 2013 10:36

oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI

Member

Hi ,
Below i have attached error log for this error.

22:33:41,499 ・main] ERROR - com.util.DBUtil: Transaction Failed
22:33:41,499 [main] ERROR - com.main.MonthlyProdOrderAdapter:com.exception.FileDataException: com.exception.FileDataExce
ption: Common Database Insert Errorjava.sql.BatchUpdateException: ORA-02289: xxxxxxxxxx

22:35:49,638 ・main] ERROR - com.dao.MonthlyProdOrderDao: Common Database Insert Errorjava.sql.BatchUpdateException: ORA
-02289: xxxxxxxxxx

22:35:49,647 ・main] ERROR - com.util.DBUtil: Transaction Failed
22:35:49,647 [main] ERROR - com.main.MonthlyProdOrderAdapter:com.exception.FileDataException: com.exception.FileDataExce
ption: Common Database Insert Errorjava.sql.BatchUpdateException: ORA-02289: xxxxxxxxxx

Thanks & regards
Siraj.j

Report message to a moderator

Re: ORA-04030 [message #595361 is a reply to message #595359]

Tue, 10 September 2013 10:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

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

[oracle@localhost ~]$ oerr ora 2289
02289, 00000, "sequence does not exist"
// *Cause: The specified sequence does not exist, or the user does
//         not have the required privilege to perform this operation.
// *Action: Make sure the sequence name is correct, and that you have
//          the right to perform the desired operation on this sequence.

Report message to a moderator

Re: ORA-04030 [message #595363 is a reply to message #595359]

Tue, 10 September 2013 11:05

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

Senior Member
Account Moderator

And "xxxxxxxxxx" is important as we don't know by heart all error numbers, so let the message.

Regards
Michel

Report message to a moderator

Re: ORA-04030 [message #595364 is a reply to message #595361]

Tue, 10 September 2013 11:59

oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI

Member

Oh sorry Blackswan...

21:47:50,015 [main] ERROR - com.main.MonthlyProdOrderAdapter:com.exception.FileDataException:
java.sql.SQLException:
ORA-04030: out of process memory when trying to allocate 65040 bytes (kxs-heap-c,temporary memory)

Report message to a moderator

Re: ORA-04030 [message #595366 is a reply to message #595364]

Tue, 10 September 2013 12:09

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

Senior Member
Account Moderator

Oracle is the victim not the culprit.
Check "ulimit -a" and enlarge stack memory for oracle account.

Regards
Michel

Report message to a moderator

Re: ORA-04030 [message #595419 is a reply to message #595366]

Wed, 11 September 2013 02:56

oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI

Member

Hi cadot,

Below values set in our oracle server.

core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 62829
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 65536
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 16384
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited

Report message to a moderator

Re: ORA-04030 [message #595422 is a reply to message #595419]

Wed, 11 September 2013 03:26

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

Senior Member
Account Moderator

Increase this paet:
stack size (kbytes, -s) 10240

Regards
Michel

Report message to a moderator

Re: ORA-04030 [message #595453 is a reply to message #595422]

Wed, 11 September 2013 06:09

oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI

Member

Hi,
Shall i change this to 100MB?

Report message to a moderator

Re: ORA-04030 [message #595455 is a reply to message #595453]

Wed, 11 September 2013 06:12

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

Senior Member
Account Moderator

You have to change to the needed memory, I can't say what you need.
So try 100M and see.

Regards
Michel

Report message to a moderator

Re: ORA-04030 [message #595465 is a reply to message #595455]

Wed, 11 September 2013 06:22

oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI

Member

Ok..

Report message to a moderator

Re: ORA-04030 [message #595603 is a reply to message #595465]

Thu, 12 September 2013 07:09

oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI

Member

Hi cadot,
We have increased stack memory to 100MB.But still problem arises..Next what we have to do?

Report message to a moderator

Re: ORA-04030 [message #595615 is a reply to message #595603]

Thu, 12 September 2013 07:50

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

Senior Member
Account Moderator

Increase more or fix the application.
You have to FIRST know where (in the code) you get this error.

Regards
Michel

Report message to a moderator

Previous Topic:	Idle Instance issue
Next Topic:	TNS-01150: The address of the specified listener name is incorrect

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 14:37:46 CST 2024