RAC增加ASM磁盘后某个实例无法启动
RAC增加ASM磁盘后某个实例无法启动
实例2启动到mount也不行
[oracle@rac1 ~]$ srvctl start instance -d lsxdb -i lsxdb2 -o mount
PRKP-1001 : Error starting instance lsxdb2 on node rac2
CRS-0215: Could not start resource 'ora.lsxdb.lsxdb2.inst'.
查看/oracle/product/database/log/rac2/racg/ora.lsxdb.lsxdb2.inst.log
2010-03-19 15:42:55.115: [ COMMCRS][53709728]clsc_send_msg: (0x81304c8) NS err (12571, 12560), transport (530, 111, 0)
2010-03-19 15:42:59.260: [ RACG][3086924544] [6031][3086924544][ora.lsxdb.lsxdb2.inst]: clsrcremaction: clsrcrpcreq message returned: 1 'SQL*Plus: Release 10.2.0.1.0 - Production on Fri Mar 19 15:42:56 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: Connected to an idle instance.
SQL> ORA-01078: failure in processing system parameters
ORA-01565: error in id'
2010-03-19 15:42:59.260: [ RACG][3086924544] [6031][3086924544][ora.lsxdb.lsxdb2.inst]: end for resource = ora.
lsxdb.lsxdb2.inst, action = start, status = 1, time = 2.690s
解决方案:
用root用户:
crsctl stop crs
rm -f /var/tmp/.oracle/*
crsctl start crs
等两三分钟,应该可以正常启动,如果过了很久,还没启动,用oracle执行命令
srvctl start instance -d lsxdb -i lsxdb2
李世侠,网名caibird2005 , initdba , 战神
MySQL DBA经验6年;
Oracle DBA经验10年;
精通MySQL HA架构,复制,备份,恢复,SQL优化;
熟悉SHELL编程、Python编程、SQL&PL/SQL编程;
MySQL OCP课程讲师;
ORACLE官方认证OCM证书;
BLOG: http://www.cnblogs.com/caibird2005
http://www.initdba.cn
Wechat: caibird2005
TEL :+86-186-5881-5300 +86-180-7290-8651