My Oracle Support Banner

The start up of CRSD fails with ORA-01017: invalid username/password; logon denied (Doc ID 2141978.1)

Last updated on DECEMBER 08, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

 

1. The crsd and evmd are in INTERMEDIATE/OFFLINE status $crsctl stat res -t -init

--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
      1        ONLINE  ONLINE       node2                Started             
ora.cluster_interconnect.haip
      1        ONLINE  ONLINE       node2
ora.crf
      1        ONLINE  OFFLINE      node2
ora.crsd
      1        ONLINE  INTERMEDIATE       node2
ora.cssd
      1        ONLINE  ONLINE       node2
ora.cssdmonitor
      1        ONLINE  ONLINE       node2
ora.ctssd
      1        ONLINE  ONLINE       node2               OBSERVER            
ora.diskmon
      1        ONLINE  ONLINE       node2

ora.evmd
      1        ONLINE  INTERMEDIATE       node2
ora.gipcd
      1        ONLINE  ONLINE       node2
ora.gpnpd
      1        ONLINE  ONLINE       node2
ora.mdnsd
      1        ONLINE  ONLINE       node2

-----------

 

2. All DISKGROUPs are in UNMOUNTED status.

 

3. <grid_home>/log/<node>/alert<node>.log :
------------

2016-05-11 04:52:02.896:
[cssd(39230)]CRS-1713:CSSD daemon is started in clustered mode
2016-05-11 04:52:23.746:
[cssd(39230)]CRS-1707:Lease acquisition for node node2 number 2 completed

.
2016-05-11 04:52:52.838:
[ohasd(38960)]CRS-2765:Resource 'ora.crsd' has failed on server 'node2'.
2016-05-11 04:52:56.125:
[crsd(40040)]CRS-1013:The OCR location in an ASM disk group is inaccessible. Details in <grid_home>/log/<node>/crsd/crsd.log.
2016-05-11 04:52:56.131:
[crsd(40040)]CRS-0804:Cluster Ready Service aborted due to Oracle Cluster Registry error [PROC-26: Error while accessing the physical storage
ORA-01017: invalid username/password; logon denied
]. Details at (:CRSD00111:) in <grid_home>/log/<node>/crsd/crsd.log.
-------------

4. <grid_home>/log/<node>/crsd.log of the problematic node :
-------------------------------------

2016-05-11 04:52:50.433: [ CRSMAIN][2876733168] Initializing OCR
[   CLWAL][2876733168]clsw_Initialize: OLR initlevel [70000]
2016-05-11 04:52:51.709: [  OCRASM][2876733168]proprasmo: Error in open/create file in dg [DBFS_DG]
[  OCRASM][2876733168]SLOS : SLOS: cat=7, opn=kgfoAl06, dep=1017, loc=kgfokge

2016-05-11 04:52:51.709: [  OCRASM][2876733168]ASM Error Stack : ORA-01017: invalid username/password; logon denied

2016-05-11 04:52:52.726: [  OCRASM][2876733168]proprasmo: kgfoCheckMount returned [7]
2016-05-11 04:52:52.726: [  OCRASM][2876733168]proprasmo: The ASM instance is down
2016-05-11 04:52:52.726: [  OCRRAW][2876733168]proprioo: Failed to open [+DBFS_DG]. Returned proprasmo() with [26]. Marking location as UNAVAILABLE.
-------------

 

5. Connecting to ASM instance of node2 using "sqlplus / as sysasm" as the grid owner also failed with 

"ORA-01017: invalid username/password; logon denied".

 

 

Changes

 The Grid has been upgraded from 11.2.0.3 to 11.2.0.4 recently.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.