感谢:http://www.dbsupport.cn/thread-372-1-1.html
升级到11.1.0.7.12启动数据库报错:
OS版本:suse linux X86-64
DB版本:11.1.0.7.8 升级到11.1.0.7.12
Total System Global Area 1.2560E+10 bytes
Fixed Size 2171344 bytes
Variable Size 7918849584 bytes
Database Buffers 4630511616 bytes
Redo Buffers 8601600 bytes
ORA-03113: end-of-file on communication channel
Process ID: 13056
Session ID: 1105 Serial number: 3
alert日志如下:
oracle@PGM_DB1:/oracle/app/diag/rdbms/ora11g/ora11g/trace> tail -100 alert_ora11g.log |more
RECO started with pid=13, OS id=9038
Tue Dec 10 14:49:52 2013
MMON started with pid=14, OS id=9040
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Dec 10 14:49:52 2013
MMNL started with pid=15, OS id=9042
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /oracle/app
Tue Dec 10 14:49:52 2013
ALTER DATABASE MOUNT
Errors in file /oracle/app/diag/rdbms/ora11g/ora11g/trace/ora11g_mman_9025.trc:
ORA-27103: internal error
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: -1
Additional information: 1
MMAN (ospid: 9025): terminating the instance due to error 27103
Tue Dec 10 14:49:56 2013
ORA-1092 : opitsk aborting process
Tue Dec 10 14:49:56 2013
ORA-1092 : opitsk aborting process
Tue Dec 10 14:49:56 2013
ORA-1092 : opitsk aborting process
Instance terminated by MMAN, pid = 9025
Tue Dec 10 14:50:24 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENS