客户这边有个10.2.0.4的库,单机升级RAC之后重启完系统后发现数据库实例无法自动启动。
正常执行cmruncl后就可以全部自动启动,现在
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....b1.inst application ONLINE OFFLINE
ora....b2.inst application ONLINE OFFLINE
ora.crmdb.db application ONLINE OFFLINE
ora....M1.lsnr application ONLINE ONLINE jlcrm1
ora.jlcrm1.gsd application ONLINE ONLINE jlcrm1
ora.jlcrm1.ons application ONLINE ONLINE jlcrm1
ora.jlcrm1.vip application ONLINE ONLINE jlcrm1
ora....M2.lsnr application ONLINE ONLINE jlcrm2
ora.jlcrm2.gsd application ONLINE ONLINE jlcrm2
ora.jlcrm2.ons application ONLINE ONLINE jlcrm2
ora.jlcrm2.vip application ONLINE ONLINE jlcrm2
$ crs_start -all
Attempting to start `ora.jlcrm1.vip` on member `jlcrm1`
Attempting to start `ora.crmdb.crmdb2.inst` on member `jlcrm2`
Attempting to start `ora.jlcrm2.vip` on member `jlcrm2`
Attempting to start `ora.crmdb.crmdb1.inst` on member `jlcrm1`
Start of `ora.jlcrm1.vip` on member `jlcrm1` succeeded.
Start of `ora.jlcrm2.vip` on member `jlcrm2` succeeded.
Attempting to start `ora.jlcrm1.LISTENER_JLCRM1.lsnr` on member `jlcrm1`
Attempting to start `ora.jlcrm2.LISTENER_JLCRM2.lsnr` on member `jlcrm2`
Start of `ora.jlcrm2.LISTENER_JLCRM2.lsnr` on member `jlcrm2` succeeded.
Start of `ora.jlcrm1.LISTENER_JLCRM1.lsnr` on member `jlcrm1` succeeded.
Start of `ora.crmdb.crmdb1.inst` on member `jlcrm1` failed.
jlcrm2 : CRS-1019: Resource ora.crmdb.crmdb1.inst (application) cannot run on jlcrm2
Start of `ora.crmdb.crmdb2.inst` on member `jlcrm2` failed.
jlcrm1 : CRS-1019: Resource ora.crmdb.crmdb2.inst (application) cannot run on jlcrm1
Attempting to start `ora.jlcrm2.ons` on member `jlcrm2`
Attempting to start `ora.jlcrm1.gsd` on member `jlcrm1`
Attempting to start `ora.jlcrm2.gsd` on member `jlcrm2`
Attempting to start `ora.jlcrm1.ons` on member `jlcrm1`
Attempting to start `ora.crmdb.db` on member `jlcrm1`
Start of `ora.jlcrm2.ons` on member `jlcrm2` succeeded.
Start of `ora.jlcrm1.ons` on member `jlcrm1` succeeded.
Start of `ora.jlcrm1.gsd` on member `jlcrm1` succeeded.
Start of `ora.jlcrm2.gsd` on member `jlcrm2` succeeded.
Start of `ora.crmdb.db` on member `jlcrm1` failed.
Attempting to start `ora.crmdb.db` on member `jlcrm2`
Start of `ora.crmdb.db` on member `jlcrm2` failed.
CRS-1006: No more members to consider
CRS-0215: Could not start resource 'ora.crmdb.crmdb1.inst'.
CRS-0215: Could not start resource 'ora.crmdb.crmdb2.inst'.
CRS-0215: Could not start resource 'ora.crmdb.db'.
但是在sqlplus中startup 就没有问题,打开 _USR_ORA_DEBUG=1后使用racgwrap也能顺利执行感觉十分奇怪。
打开$ORACLE_HOME/log/jlcrm1/racg/imoncrmdb.log
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Oct 27 22:20:29 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Enter user-name: Connected to an idle instance.
SQL> ORA-00119: invalid specification for system parameter REMOTE_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENERS_CRMDB'
ORA-01078: failure in processing system parameters
SQL> Disconnected
根据错误搜索metalink发现 ID 360575.1 情况基本一致,和文档不同的是这里没使用ASM,按照文档执行
srvctl setenv database -d crmdb -t TNS_ADMIN=/oracle/product/db10g/network/admin
后启动恢复正常,实际上环境变量中设置了TNS_ADMIN,为什么出现这种情况还不清楚。
CRS-0215: Srvctl Cant Start Instance But Sqlplus Can [ID 360575.1] | |||||
| |||||
修改时间 25-AUG-2011 类型 PROBLEM 状态 ARCHIVED |
In this Document
Symptoms
Cause
Solution
Scalability RAC Community
Applies to:
Oracle Server - Standard Edition - Version: 10.2.0.1 and later [Release: 10.2 and later ]Information in this document applies to any platform.
Symptoms
Start on instance using srvctl command fails. but start of instance at SQLPLUSworks .
PRKP-1001 : Error starting instance RCT01 on node ractest1
CRS-0215: Could not start resource 'ora.RCT0.RCT01.inst'.
Cause
From the ora.RTC0.RCT01.inst.log:2006-02-21 22:46:37.306: [ RACG][1] [23356][1][ora.RCT0.RCT01.inst]: clsrcremaction:
clsrcrpcreq message returned: 1 '
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 21 22:46:20 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: Connected to an idle instance.
SQL> ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-'
2006-02-21 22:46:37.307: [ RACG][1] [23356][1][ora.RCT0.RCT01.inst]: end for resource =
ora.RCT0.RCT01.inst, action = start, status = 1, time = 19.798s
Since the default location of the TNS files is not being used, so it couldn't find the listener.
Solution
To implement the solution, please execute the following steps:
1. If TNS/LSNR file is in
/oracle/product/10.2.0/asm/network/admin
then
srvctl setenv database -d RTC0 -t TNS_ADMIN=/oracle/product/10.2.0/asm/network/admin