Home » RDBMS Server » Server Administration » ORA-04030 (Oracle 11g)
ORA-04030 [message #595357] Tue, 10 September 2013 10:25 Go to next message
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?
Re: ORA-04030 [message #595358 is a reply to message #595357] Tue, 10 September 2013 10:29 Go to previous messageGo to next message
BlackSwan
Messages: 22792
Registered: January 2009
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: 


Re: ORA-04030 [message #595359 is a reply to message #595358] Tue, 10 September 2013 10:36 Go to previous messageGo to next message
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
Re: ORA-04030 [message #595361 is a reply to message #595359] Tue, 10 September 2013 10:39 Go to previous messageGo to next message
BlackSwan
Messages: 22792
Registered: January 2009
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.
Re: ORA-04030 [message #595363 is a reply to message #595359] Tue, 10 September 2013 11:05 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And "xxxxxxxxxx" is important as we don't know by heart all error numbers, so let the message.

Regards
Michel
Re: ORA-04030 [message #595364 is a reply to message #595361] Tue, 10 September 2013 11:59 Go to previous messageGo to next message
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)
Re: ORA-04030 [message #595366 is a reply to message #595364] Tue, 10 September 2013 12:09 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle is the victim not the culprit.
Check "ulimit -a" and enlarge stack memory for oracle account.

Regards
Michel
Re: ORA-04030 [message #595419 is a reply to message #595366] Wed, 11 September 2013 02:56 Go to previous messageGo to next message
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
Re: ORA-04030 [message #595422 is a reply to message #595419] Wed, 11 September 2013 03:26 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Increase this paet:
stack size (kbytes, -s) 10240

Regards
Michel
Re: ORA-04030 [message #595453 is a reply to message #595422] Wed, 11 September 2013 06:09 Go to previous messageGo to next message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
Hi,
Shall i change this to 100MB?
Re: ORA-04030 [message #595455 is a reply to message #595453] Wed, 11 September 2013 06:12 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: ORA-04030 [message #595465 is a reply to message #595455] Wed, 11 September 2013 06:22 Go to previous messageGo to next message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
Ok..
Re: ORA-04030 [message #595603 is a reply to message #595465] Thu, 12 September 2013 07:09 Go to previous messageGo to next message
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?
Re: ORA-04030 [message #595615 is a reply to message #595603] Thu, 12 September 2013 07:50 Go to previous message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Idle Instance issue
Next Topic: TNS-01150: The address of the specified listener name is incorrect
Goto Forum:
  


Current Time: Sun Sep 21 03:26:50 CDT 2014

Total time taken to generate the page: 0.08456 seconds