Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> out of process memory error when upgrading from oracle 9.2.0.8 to 11.2.0.2, out of process memory error
venkatesh03
post Apr 7 2012, 11:30 PM
Post #1


Advanced Member
***

Group: Members
Posts: 39
Joined: 17-July 10
Member No.: 43,498



Hi,
I got the following error when upgrading from Oracle 9.2.0.8 to Oracle 11.2.0.2 version using catupgrd.sql script.

=================================================================
CREATE OR REPLACE PACKAGE BODY kupm$mcp wrapped
*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
ERROR:
ORA-03114: not connected to ORACLE


SP2-1519: Unable to write to the error log table sys.registry$error
ORA-04030: out of process memory when trying to allocate 8392728 bytes (pga
heap,redo read buffer)
ORA-04030: out of process memory when trying to allocate 8392728 bytes (pga
heap,redo read buffer)
ORA-04030: out of process memory when trying to allocate 8168 bytes
(callheap,kcbtmal allocation)
Process ID: 81984
Session ID: 1 Serial number: 5

==========================================================

My machine environment is:
UNIX AIX 5.3 level 12
Oracle 11.2.0.2
RAM size 2GB
ulimit settings:
> ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 131072
stack(kbytes) 32768
memory(kbytes) unlimited
coredump(blocks) 2
nofiles(descriptors) unlimited

Currently i tried to increase SGA & PGA to possible extent, but still getting this error?
Is there any change required in ulimit, RAM etc?

Please help me how to resolve this error?

Kindly let me know if further information is required.

Thanks & Regards,
Venkatesh S
Go to the top of the page
 
+Quote Post
burleson
post Apr 8 2012, 09:43 AM
Post #2


Advanced Member
***

Group: Members
Posts: 11,634
Joined: 26-January 04
Member No.: 13



Hi Vencat,

>> SP2-1519

You are on Windows, that's your first problem . . . .


*******************************************

>> ORA-04030: out of process memory when trying to allocate 8392728 bytes (pga
heap,redo read buffer

Read solution here:

http://www.dba-oracle.com/t_ora_04030_out_process_memory.htm

You do not have enough RAM to support your SGA and PGA pool parameter sizes.

Read this carefully:

http://www.dba-oracle.com/t_sga_sizing.htm


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 30th October 2014 - 12:29 PM