aix for oracle 10g

《aix for oracle 10g》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、一、故障信息收集2011-12-1logThuDec106:30:002011Shuttingdowninstance:furtherlogonsdisabledThuDec106:30:012011StoppingbackgroundprocessCJQ0ThuDec106:30:012011StoppingbackgroundprocessQMNCThuDec106:30:022011ALTERSYSTEMSETservice_names=''SCOPE=MEMORYSID='fmisb1';ThuDec106:30:022011ALTERSYSTEMSE

2、Tservice_names='fmisb'SCOPE=MEMORYSID='fmisb1';ThuDec106:30:032011StoppingbackgroundprocessMMNLThuDec106:30:042011StoppingbackgroundprocessMMONThuDec106:30:052011Shuttingdowninstance(immediate)Licensehighwatermark=78ThuDec106:30:052011StoppingJobqueueslaveprocesses,flags=7ThuDec106:

3、30:052011ProcessOSid:381376aliveafterkillErrorsinfile/oracle/app/admin/fmisb/udump/fmisb1_ora_377144.trcThuDec106:30:052011JobqueueslaveprocessesstoppedAlldispatchersandsharedserversshutdownThuDec106:30:112011ALTERDATABASECLOSENORMAL2011-12-8logProcessq001died,seeitstracefileThuDec8

4、07:58:512011ksvcreate:Process(q001)creationfailedThuDec808:21:222011StartingORACLEinstance(normal)sskgpgetexecnamefailedtogetnameLICENSE_MAX_SESSION=0LICENSE_SESSIONS_WARNING=0Interfacetype1en2168.168.1.0configuredfromOCRforuseasaclusterinterconnectInterfacetype1en010.194.0.0configu

5、redfromOCRforuseasapublicinterfacePickedlatch-freeSCNscheme3Autotuneofundoretentionisturnedon.LICENSE_MAX_USERS=0SYSauditingisdisabledksdpec:calledforevent13740priortoeventgroupinitializationStartingupORACLERDBMSVersion:10.2.0.4.0.Systemparameterswithnon-defaultvalues:processes=1000

6、sessions=1105event=10298tracenamecontextforever,level32sga_max_size=16106127360__shared_pool_size=10368319488__large_pool_size=16777216__java_pool_size=16777216__streams_pool_size=0spfile=/dev/rfmis_spfilesga_target=16106127360control_files=/dev/rfmis_control1,/dev/rfmis_control2db_

7、block_size=8192__db_cache_size=5687476224compatible=10.2.0.3.0log_archive_dest_1=location=/archloglog_archive_dest_2=log_archive_format=%t_%s_%r.dbfdb_file_multiblock_read_count=16cluster_database=TRUEcluster_database_instances=2thread=1instance_number=1undo_management=AUTOundo_tabl

8、espace=UNDOTBS1recy