Oracle alert文件分析(六)
termination failed to kill one or more processes
Instance terminated by LMHB, pid = 6619738
2013-05-20 09:20:55.106000 +08:00
Adjusting the default value of parameter parallel_max_servers
from 3200 to 985 due to the value of parameter processes (1000)
Starting ORACLE instance (normal)
2013-05-20 09:20:57.134000 +08:00
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
2013-05-20 09:20:57.134000 +08:00
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
2013-05-20 09:20:58.602000 +08:00
Private Interface 'en5' configured from GPnP for use as a private interconnect.
[name='en5', type=1, ip=169.254.25.4, mac=e4-1f-13-4f-b8-da, net=169.254.0.0/16, mask=255.255.0.0, use=haip:cluster_interconnect/62]
Public Interface 'en4' configured from GPnP for use as a public interface.
[name='en4', type=1, ip=10.48.13.131, mac=e4-1f-13-4f-b8-d8, net=10.48.13.128/27, mask=255.255.255.224, use=public/1]
Picked latch-free SCN scheme 3
WARNING: db_recovery_file_dest is same as db_create_file_dest
Autotune of undo retention is turned on.
2013-05-20 09:20:59.769000 +08:00
LICENSE_MAX_USERS = 0
SYS auditing is disabled
2013-05-20 09:21:01.270000 +08:00
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options.
ORACLE_HOME = /u01/app/oracle/product/11.2
System name:AIX
Node name:htcmdb1
Release:1
Version:6
Machine:00F65CCD4C00
Using parameter settings in server-side pfile /u01/app/oracle/product/11.2/dbs/inittlodb1.ora
System parameters with non-default values:
processes = 1000
sessions = 1600
spfile = "+TLDATA/tlodb/spfiletlodb.ora"
memory_target = 18304M
control_files = "+TLDATA/tlodb/controlfile/current.256.798813565"
control_files = "+TLDATA/tlodb/controlfile/current.257.798813565"
db_block_size = 16384
compatible = "11.2.0.0.0"
Dumping diagnostic data in directory=[cdmp_20130520085448], requested by (instance=1, osid=6619738 (LMHB)), summary=[abnorma
Sweep [inc][80061]: completed
2013-05-20 07:55:47.600000 +08:00
DIA0 terminating blocker (ospid: 13435258 sid: 65 ser#: 277) of hang with ID = 88
requested by master DIA0 process on instance 1
Hang Resolution Reason: Although the number of affected sessions did not
justify automatic hang resolution initially, this previously ignored
hang was automatically resolved.
by terminating the process
DIA0 successfully terminated process ospid:13435258.
DIA0 successfully resolved a LOCAL, HIGH confidence hang with ID=88.
2013-05-20 07:56:02.672000 +08:00
DIA0 terminating blocker (ospid: 8323632 sid: 1441 ser#: 1) of hang with ID = 89
requested by master DIA0 process on instance 1
Hang Resolution Reason: Although hangs of this root type are typically
self-resolving, the previously ignored hang was automatically resolved.
by terminating the process
DIA0 successfully terminated process ospid:8323632.
DIA0 successfully resolved a LOCAL, HIGH confidence hang with ID=89.
2013-05-20 07:56:17.731000 +08:00
DIA0 terminating blocker (ospid: 14090364 sid: 703 ser#: 3) of hang with ID = 91