感谢：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
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.?
IMODE=BR
ILAT =121
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 11.1.0.7.0.
Using parameter settings in server-side pfile /oracle/app/product/11g/db/dbs/initora11g.ora
System parameters with non-default values:
? processes ? ? ? ? ? ? ? ?= 1000
? spfile ? ? ? ? ? ? ? ? ? = "/dev/vx/rdsk/vgora/lvspfile"
? memory_target ? ? ? ? ? ?= 12032M
? control_files ? ? ? ? ? ?= "/dev/vx/rdsk/vgora/lvctl1"
? control_files ? ? ? ? ? ?= "/dev/vx/rdsk/vgora/lvctl2"
? control_files ? ? ? ? ? ?= "/dev/vx/rdsk/vgora/lvctl3"
? db_block_size ? ? ? ? ? ?= 8192
? compatible ? ? ? ? ? ? ? = "11.1.0.0.0"
? log_archive_dest_1 ? ? ? = "location=/home/oracle/archive"
? db_recovery_file_dest ? ?= ""
? db_recovery_file_dest_size= 2G
? undo_tablespace ? ? ? ? ?= "UNDOTBS1"
? sec_case_sensitive_logon = FALSE
? remote_login_passwordfile= "EXCLUSIVE"
? db_domain ? ? ? ? ? ? ? ?= ""
? dispatchers ? ? ? ? ? ? ?= "(PROTOCOL=TCP) (SERVICE=ora11gXDB)"
? local_listener ? ? ? ? ? = ""
? remote_listener ? ? ? ? ?= ""
? audit_file_dest ? ? ? ? ?= "/oracle/app/admin/ora11g/adump"
? audit_trail ? ? ? ? ? ? ?= "NONE"
? db_name ? ? ? ? ? ? ? ? ?= "ora11g"
? open_cursors ? ? ? ? ? ? = 300
? diagnostic_dest ? ? ? ? ?= "/oracle/app"
Tue Dec 10 14:50:26 2013
PMON started with pid=2, OS id=13015?
Tue Dec 10 14:50:26 2013
VKTM started with pid=3, OS id=13017?
VKTM running at (100ms) precision?
Tue Dec 10 14:50:26 2013
DIAG started with pid=4, OS id=13024?
Tue Dec 10 14:50:26 2013
DBRM started with pid=5, OS id=13026?
Tue Dec 10 14:50:26 2013
PSP0 started with pid=6, OS id=13028
