这是alert_jwgl2.log的部分日志,帮忙看下,谢谢!
Wed Jan 14 13:34:14 2009
Thread 2 cannot allocate new log, sequence 45
Checkpoint not complete
Current log# 4 seq# 44 mem# 0: /data/jwgl/jwgl/redo04.log
Thread 2 advanced to log sequence 45
Current log# 3 seq# 45 mem# 0: /data/jwgl/jwgl/redo03.log
Wed Jan 14 13:38:56 2009
Memory Notification: Library Cache Object loaded into SGA
Heap size 2060K exceeds notification threshold (2048K)
KGL object name :select s.synonym_name object_name, o.object_type
from sys.all_synonyms s,
sys.all_objects o
where s.owner in ('PUBLIC', user)
and o.owner = s.table_owner
and o.object_name = s.table_name
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION'
, 'SEQUENCE')
Wed Jan 14 13:45:23 2009
Errors in file /ora/app/oracle/admin/jwgl/bdump/jwgl2_pmon_7650.trc:
ORA-00481: LMON process terminated with error
Wed Jan 14 13:45:23 2009
PMON: terminating instance due to error 481
Wed Jan 14 13:45:23 2009
System state dump is made for local instance
System State dumped to trace file /ora/app/oracle/admin/jwgl/bdump/jwgl2_diag_76
52.trc
Wed Jan 14 13:45:28 2009
Instance terminated by PMON, pid = 7650
Wed Jan 14 13:54:07 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Interface type 1 eth1 10.10.10.0 configured from OCR for use as a cluster interc
onnect
Interface type 1 eth2 192.168.0.0 configured from OCR for use as a cluster inter
connect
Interface type 1 eth0 10.1.2.0 configured from OCR for use as a public interfac
e
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /ora/app/oracle/product/10.2
.0/db_1/dbs/arch
Autotune of undo retention is turned on.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 800
sessions = 885
__shared_pool_size = 838860800
__large_pool_size = 16777216
__java_pool_size = 16777216
__streams_pool_size = 0
spfile = /data/jwgl/jwgl/spfilejwgl.ora
sga_target = 3707764736
control_files = /data/jwgl/jwgl/control01.ctl, /data/jwgl/jwgl/cont
rol02.ctl, /data/jwgl/jwgl/control03.ctl
db_block_size = 8192
__db_cache_size = 2818572288
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
cluster_database = TRUE
cluster_database_instances= 2
thread = 2
instance_number = 2
undo_management = AUTO
undo_tablespace = UNDOTBS2
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=jwglXDB)
remote_listener = LISTENERS_JWGL
job_queue_processes = 10
background_dump_dest = /ora/app/oracle/admin/jwgl/bdump
user_dump_dest = /ora/app/oracle/admin/jwgl/udump
core_dump_dest = /ora/app/oracle/admin/jwgl/cdump
audit_file_dest = /ora/app/oracle/admin/jwgl/adump
db_name = jwgl
open_cursors = 300
pga_aggregate_target = 1232076800
Cluster communication is configured to use the following interface(s) for this i
nstance
10.10.10.213
192.168.0.6
Wed Jan 14 13:54:09 2009
cluster interconnect IPC version:Oracle UDP/IP
IPC Vendor 1 proto 2
PMON started with pid=2, OS id=7169
DIAG started with pid=3, OS id=7171
PSP0 started with pid=4, OS id=7173
LMON started with pid=5, OS id=7175
LMD0 started with pid=6, OS id=7177
LMS0 started with pid=7, OS id=7179
LMS1 started with pid=8, OS id=7189
MMAN started with pid=9, OS id=7199
DBW0 started with pid=10, OS id=7201
LGWR started with pid=11, OS id=7203
CKPT started with pid=12, OS id=7205
SMON started with pid=13, OS id=7207
RECO started with pid=14, OS id=7209
CJQ0 started with pid=15, OS id=7211
MMON started with pid=16, OS id=7213
Wed Jan 14 13:54:10 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL
=TCP))'...
MMNL started with pid=17, OS id=7235
Wed Jan 14 13:54:10 2009
starting up 1 shared server(s) ...
Wed Jan 14 13:54:10 2009
lmon registered with NM - instance id 2 (internal mem no 1)
Wed Jan 14 13:57:05 2009
Error: KGXGN polling error (15)
Wed Jan 14 13:57:05 2009
Errors in file /ora/app/oracle/admin/jwgl/bdump/jwgl2_lmon_7175.trc:
ORA-29702: error occurred in Cluster Group Service operation
LMON: terminating instance due to error 29702
Wed Jan 14 13:57:08 2009
Shutting down instance (abort)
License high water mark = 0
Wed Jan 14 13:57:10 2009
Instance terminated by LMON, pid = 7175
Wed Jan 14 13:57:13 2009
Instance terminated by USER, pid = 11652