oracle集群启动数据库,rac只能启动一个实例,怎么解决?

这是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

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值