Oracle alert文件分析
$ adrci
ADRCI: Release 11.2.0.3.0 - Production on Mon May 20 09:59:57 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/oracle"
adrci> show alert
Choose the alert log from the following homes to view:
1: diag/rdbms/cfsdb/cfsdb1
2: diag/rdbms/hetdb/hetdb1
3: diag/rdbms/mzldb/mzldb1
4: diag/rdbms/tlodb/tlodb1
5: diag/tnslsnr/htcmdb1/listener
Q: to quit
Please select option: 4
Output the results to file: /tmp/alert_9765742_1_tlodb1_1.ado
2012-11-08 12:39:04.072000 +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)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
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_interc
onnect/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]
Public Interface 'en4' configured from GPnP for use as a public interface.
[name='en4', type=1, ip=10.48.13.130, mac=e4-1f-13-4f-b8-d8, net=10.48.13.128/27, mask=255.255.255.224, use=public/1]
Public Interface 'en4' configured from GPnP for use as a public interface.
[name='en4', type=1, ip=10.48.13.136, mac=e4-1f-13-4f-b8-d8, net=10.48.13.128/27, mask=255.255.255.224, use=public/1]
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 3 -- http://www.freelists.org/post/oracle-l/latchfree-SCN-scheme-10103
-- Duplicate SCN Identified In Different REDO LOG Threads [ID 260304.1]
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
WARNING: db_recovery_file_dest is same as db_create_file_dest
Autotune of undo retention is turned on. -- http://www.stechno.net/sap-notes.html view=sapnote&id=1035137
IMODE=BR
ILAT =176
LICENSE_MAX_USERS = 0
SYS auditing is disabled
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 client-side pfile /u01/app/oracle/admin/tlodb/pfile/init.ora on machine htcmdb1
System parameters with non-default values:
processes = 1000
LMS 3: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Set master node info
Submitted all remote-enqueue requests
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Submitted all GCS remote-cache requests
Fix write in gcs resources
Reconfiguration complete
minact-scn: Master returning as live inst:2 has inc# mismatch instinc:0 cur:4 errcnt:0
2013-05-20 09:26:57.692000 +08:00
Starting background process SMCO
SMCO started with pid=41, OS id=2884590
2013-05-20 09:30:51.966000 +08:00
Time drift detected. Please check V