关于crs无法启动的分析

   不久前安装了一套rac但在启动时报错，无法启动集群。
环境：
11.2.0.4.0 Production
Red Hat Enterprise Linux Server release 5.7 (Tikanga)

执行启动：
[root@dbrac1 bin]# ./crsctl start crs
CRS-4640: Oracle High Availability Services is already active
CRS-4000: Command Start failed, or completed with errors.

查看日志:/u01/app/11.2.0/grid/log/dbrac1

asm正常


那么现在的问题在哪呢？日志也就只有这两行报错

在网上搜索到这篇文章：
http://blog.itpub.net/28612416/viewspace-1820666/

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

SYMPTOMS

 

One of the node CRS was not coming up properly.

ASM did not come up automatically - it  failed to start  with "ORA-01017: invalid username/password; logon denied" error in the <grid home>/log/<host name>/agent/ohasd/oraagent_grid/oraagent_grid.log

alert<hostname>.log
~~~~~~~~~~~~~~~~~~~~
[client(3990)]CRS-10001:10-Jun-14 14:35 ACFS-9156: Detecting control device '/dev/ofsctl'.
[client(4002)]CRS-10001:10-Jun-14 14:35 ACFS-9322: completed
2014-06-10 14:36:18.128:
[ohasd(48895)]CRS-2807:Resource 'ora.asm' failed to start automatically.
2014-06-10 14:36:18.128:
[ohasd(48895)]CRS-2807:Resource 'ora.crsd' failed to start automatically.

 

oraagent_grid.log
~~~~~~~~~~~~~~~~~~
2014-06-10 14:35:15.585: [ora.asm][3219122496]{0:0:2} [start] makeConnectStr = (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/u01/app/11.2.0.4/grid/bin/oracle)(ARGV0=oracle+ASM1)(ENVS='ORACLE_HOME=/u01/app/11.2.0.4/grid,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=+ASM1)))
2014-06-10 14:35:15.587: [ora.asm][3219122496]{0:0:2} [start] Container:start oracle home /u01/app/11.2.0.4/grid
2014-06-10 14:35:15.587: [ora.asm][3219122496]{0:0:2} [start] InstConnection::connectInt: server not attached
2014-06-10 14:35:15.621: [ora.asm][3219122496]{0:0:2} [start] ORA-01017: invalid username/password; logon denied  <<<<<<<<<

2014-06-10 14:36:12.960: [ A**][2622531904]{0:0:2} A** Proxy Server sending the reply to PE for message:RESOURCE_CLEAN[ora.asm 1 1] ID 4100:456
2014-06-10 14:36:12.960: [ CRSPE][2543831360]{0:0:2} Received reply to action [Clean] message ID: 456
2014-06-10 14:36:12.960: [ CRSPE][2543831360]{0:0:2} Got agent-specific msg: ORA-01017: invalid username/password; logon denied

 

ASM instance can be started manually  using sqlplus "/as sysasm" but the CRSD fails to start with same error.

crsd.log
~~~~~~~~~
2014-06-05 11:05:28.617: [ CRSMAIN][4003182320] Initializing OCR
[ CLWAL][4003182320]clsw_Initialize: OLR initlevel [70000]
2014-06-05 11:05:29.938: [ OCRASM][4003182320]proprasmo: Error in open/create file in dg [DATA]
[ OCRASM][4003182320]SLOS : SLOS: cat=7, opn=kgfoAl06, dep=1017, loc=kgfokge

2014-06-05 11:05:29.938: [ OCRASM][4003182320]ASM Error Stack : ORA-01017: invalid username/password; logon denied <<<<<<<<

2014-06-05 11:05:30.985: [ OCRASM][4003182320]proprasmo: kgfoCheckMount returned [7]
2014-06-05 11:05:30.985: [ OCRASM][4003182320]proprasmo: The ASM instance is down
2014-06-05 11:05:30.985: [ OCRRAW][4003182320]proprioo: Failed to open [+DATA]. Returned proprasmo() with [26]. Marking location as UNAVAILABLE.
2014-06-05 11:05:30.985: [ OCRRAW][4003182320]proprioo: No OCR/OLR devices are usable

 

CAUSE

 SQLNET.ORA has below entry

 

# sqlnet.ora.Network Configuration File:
/u01/app/11.2.0.4/grid/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
SQLNET.AUTHENTICATION_SERVICES=none <<<<<<<<<<<<<<<<<<<<
ADR_BASE = /u01/app/grid

 

CRS uses OS authentication method to connect ASM instance.

If   SQLNET.AUTHENTICATION_SERVICES=none then a valid username and password is need to connect to ASM instance.

 

SOLUTION

 

1) Remove "SQLNET.AUTHENTICATION_SERVICES=none" from the Grid Home SQLNET.ORA file (location $ORACLE_HOME/network/admin)

2) Restart the CRS with force.

crsctl stop crs -f
crsctl start crs

分析原因后想起几天前局方要求添加白名单修改了sqlnet.ora中的一个参数
SQLNET.AUTHENTICATION_SERVICES=NTS
将这个参数删除掉后再重新启动crs问题解决了！
[grid@dbrac1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.BACKUPDG.dg
               ONLINE  ONLINE       dbrac1                                       
               ONLINE  ONLINE       dbrac2                                       
ora.DATA.dg
               ONLINE  ONLINE       dbrac1                                       
               ONLINE  ONLINE       dbrac2                                       
ora.LISTENER.lsnr
               ONLINE  ONLINE       dbrac1                                       
               ONLINE  ONLINE       dbrac2                                       
ora.SYSTEMDG.dg
               ONLINE  ONLINE       dbrac1                                       
               ONLINE  ONLINE       dbrac2                                       
ora.asm
               ONLINE  ONLINE       dbrac1                   Started             
               ONLINE  ONLINE       dbrac2                   Started             
ora.gsd
               OFFLINE OFFLINE      dbrac1                                       
               OFFLINE OFFLINE      dbrac2                                       
ora.net1.network
               ONLINE  ONLINE       dbrac1                                       
               ONLINE  ONLINE       dbrac2                                       
ora.ons
               ONLINE  ONLINE       dbrac1                                       
               ONLINE  ONLINE       dbrac2                                       
ora.registry.acfs
               ONLINE  ONLINE       dbrac1                                       
               ONLINE  ONLINE       dbrac2                                       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       dbrac1                                       
ora.cvu
      1        ONLINE  ONLINE       dbrac1                                       
ora.dbrac1.vip
      1        ONLINE  ONLINE       dbrac1                                       
ora.dbrac2.vip
      1        ONLINE  ONLINE       dbrac2                                       
ora.oc4j
      1        ONLINE  ONLINE       dbrac1                                       
ora.prod.db
      1        ONLINE  ONLINE       dbrac1                   Open                
      2        ONLINE  ONLINE       dbrac2                   Open                
ora.scan1.vip
      1        ONLINE  ONLINE       dbrac1                                       
[grid@dbrac1 ~]$

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29674916/viewspace-2132781/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29674916/viewspace-2132781/