oracle rac mount,rac 一个节点不能mount;另一个节点正常

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Interface type 1 privatecard 192.168.0.0 configured from OCR for use as a cluster interconnect

Interface type 1 public 10.0.10.0 configured from OCR for use as  a public interface

Picked latch-free SCN scheme 2

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                = 150

__shared_pool_size       = 96468992

__large_pool_size        = 4194304

__java_pool_size         = 4194304

__streams_pool_size      = 0

spfile                   = +DATA/oracle/spfileoracle.ora

nls_language             = SIMPLIFIED CHINESE

nls_territory            = CHINA

sga_target               = 167772160

control_files            = +DATA/oracle/control01.ctl, +DATA/oracle/control02.ctl, +DATA/oracle/control03.ctl

db_block_size            = 8192

__db_cache_size          = 58720256

compatible               = 10.2.0.1.0

log_archive_dest_1       = LOCATION=+DATA/oracle/

log_archive_format       = ARC%S_%R.%T

db_file_multiblock_read_count= 16

cluster_database         = TRUE

cluster_database_instances= 2

db_recovery_file_dest    = +DATA

db_recovery_file_dest_size= 2147483648

thread                   = 1

instance_number          = 1

undo_management          = AUTO

undo_tablespace          = UNDOTBS1

remote_login_passwordfile= EXCLUSIVE

db_domain                =

dispatchers              = (PROTOCOL=TCP) (SERVICE=oracleXDB)

remote_listener          = LISTENERS_ORACLE

job_queue_processes      = 10

audit_file_dest          = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORACLE\ADUMP

background_dump_dest     = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORACLE\BDUMP

user_dump_dest           = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORACLE\UDUMP

core_dump_dest           = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORACLE\CDUMP

db_name                  = oracle

open_cursors             = 300

pga_aggregate_target     = 16777216

Cluster communication is configured to use the following interface(s) for this instance

192.168.0.10

Tue Jan 13 13:43:36 2009

cluster interconnect IPC version:Oracle 9i Winsock2 TCP/IP IPC

IPC Vendor 0 proto 0

Version 0.0

PMON started with pid=2, OS id=1316

DIAG started with pid=3, OS id=1692

PSP0 started with pid=4, OS id=2828

LMON started with pid=5, OS id=2076

LMS0 started with pid=7, OS id=3924

MMAN started with pid=8, OS id=2096

DBW0 started with pid=9, OS id=3868

LGWR started with pid=10, OS id=2856

CKPT started with pid=11, OS id=4012

SMON started with pid=12, OS id=2152

RECO started with pid=13, OS id=2368

CJQ0 started with pid=14, OS id=2088

MMON started with pid=15, OS id=2020

MMNL started with pid=16, OS id=2972

Tue Jan 13 13:43:37 2009

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

starting up 1 shared server(s) ...

Tue Jan 13 13:43:37 2009

lmon registered with NM - instance id 1 (internal mem no 0)

LMD0 started with pid=6, OS id=3592

Tue Jan 13 13:43:38 2009

Reconfiguration started (old inc 0, new inc 32)

List of nodes:

0 1

Global Resource Directory frozen

* allocate domain 0, invalid = TRUE

Communication channels reestablished

* domain 0 valid according to instance 1

* domain 0 valid = 1 according to instance 1

Tue Jan 13 13:43:40 2009

Master broadcasted resource hash value bitmaps

Non-local Process blocks cleaned out

Tue Jan 13 13:43:40 2009

LMS 0: 0 GCS shadows cancelled, 0 closed

Set master node info

Submitted all remote-enqueue requests

Dwn-cvts replayed, VALBLKs dubious

All grantable enqueues granted

Tue Jan 13 13:43:40 2009

LMS 0: 0 GCS shadows traversed, 0 replayed

Tue Jan 13 13:43:40 2009

Submitted all GCS remote-cache requests

Post SMON to start 1st pass IR

Fix write in gcs resources

Reconfiguration complete

LCK0 started with pid=19, OS id=2912

Tue Jan 13 13:43:59 2009

alter database mount

Tue Jan 13 13:43:59 2009

Starting background process ASMB

ASMB started with pid=24, OS id=2756

Starting background process RBAL

RBAL started with pid=25, OS id=1332

Tue Jan 13 13:44:05 2009

SUCCESS: diskgroup DATA was mounted

SUCCESS: diskgroup DATA was dismounted

Tue Jan 13 13:44:05 2009

ORA-203 signalled during: alter database mount...

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值