While trying to relocate a database (11.1.0.7) to a new server today, it crashed on ‘open’:
ORA-03113: end-of-file on communication channel
Process ID: 29561
Session ID: 115 Serial number: 5
I looked the trace it provided:
ORA-27103: internal error
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: -1
Additional information: 1
MMAN (ospid: 3259): terminating the instance due to error 27103
Instance terminated by MMAN, pid = 3259
Though at first appearance, it looked (to me) like an NFS lock of sorts, it ends up that it is in fact caused an Oracle bug that occurs when memory_target > 3G.
The solution? As per the bug description (7272646.8), there is a patch for it (7272646). But my solution was just to return to pga_aggregate_target & sga_target.
Update:
it seems this bug can also cause the following error:
ORA-27103: internal error
Linux-x86_64 Error: 17: File exists
Additional information: -1
Additional information: 1
MMAN (ospid: 3775): terminating the instance due to error 27103
with the trace file showing:
error 27103 detected in background process
ORA-27103: internal error
Linux-x86_64 Error: 17: File exists
Additional information: -1
Additional information: 1
Leave a Reply