Oracle 11g Memory Max Target ORA-27103

By Minh • Sep 19th, 2009 • Category: Oracle

Here is how to increase the Oracle 11g memory target parameters to more than 3 GB on 64-bit Linux.

Ever Helpful: ORA-03113: end-of-file on communication channel:

When attempting to increase the memory_max_target and memory_target parameters to a value over 3 GB, an ORA-03113 is triggered.

SQL> startup
ORA-03113: end-of-file on communication channel
Process ID: ####
Session ID: 170 Serial number: 3

Check the Alert Log:

> vi $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/trace/alert_$ORACLE_SID.log
ALTER DATABASE MOUNT
Errors in file $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/trace/$ORACLE_SID_mman_####.trc:
ORA-27103: internal error
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: -1
Additional information: 1
MMAN (ospid: 8169): terminating the instance due to error 27103
Instance terminated by MMAN, pid = ####

Download and Install the Patch:

This is an error specific to Oracle 11g version 11.1.0.7.0 (the patched version) on 64-bit Linux. Log into Metalink, and then download and install patch number 7272646, ORA-27103 WHEN MEMORY_TARGET > 3G, with the file name p7272646_11107_Linux-x86-64.zip.

Minh is a technology junkie.
Email this author | All posts by Minh

2 Responses »

Carey Canes on May 15th, 2010 at 2:34 am:
Hey, nice post, really well written. You should write more about this.
Target supplies on February 5th, 2012 at 4:19 pm:
Magnificent goods from you, man. I have consider your stuff previous to and you’re simply extremely excellent. I actually like what you have received right here, certainly like what you are stating and the way in which in which you assert it. You make it enjoyable and you continue to care for to keep it wise. I cant wait to read far more from you. That is really a tremendous web site.

MinhTech.com