Part 2: ora.storage fails to start, ORA-01017
June 30, 2022 Leave a comment
Problem:
One of our customers changed ASM password file by mistake and regarding other actions, we are not sure. After node restart, they encountered ora.storage startup issue on the second node.
CRS-2672: Attempting to start 'ora.storage' on 'orcl02'
ORA-01017: invalid username/password; logon denied
CRS-5055: unable to connect to an ASM instance because no ASM instance is running in the cluster
CRS-2883: Resource 'ora.storage' failed during Clusterware stack start.
CRS-4406: Oracle High Availability Services synchronous start failed.
CRS-41053: checking Oracle Grid Infrastructure for file permission issues
CRS-4000: Command Start failed, or completed with errors.
I have followed my blog post to recover ASM passwordfile and add CRSUSER__ASM_001. The CRS started successfully on the first node but it still was not able to start on the second.
Reason:
When we checked password for CRSUSER__ASM_001 on both nodes, we got different results:
[grid@orcl01 ~]$ crsctl get credmaint -path ASM/Self/0b5330fe4bdf6f6ebffb09beab078d6e -credtype userpass -id 0 -attr passwd -local
zSZDts1PQx8v7gRrdmH1EjIpSBsAt
[grid@orcl02 ~]$ crsctl get credmaint -path ASM/Self/0b5330fe4bdf6f6ebffb09beab078d6e -credtype userpass -id 0 -attr passwd -local
rHgulYGfY17Uxbb9Tbd9VF3yr2Kvr
Which is not normal and they must be the same. This was the reason CRS was not able to start on the second node, because ASM passwordfile for CRSUSER__ASM_001 had value zSZDts1PQx8v7gRrdmH1EjIpSBsAt
Solution:
Verify and fix the credentials:
If you are not able to set up root ssh passwordless connectivity, you can run the following command as grid. Note in that case you will get “credfix: could not delete crs credentials for jxrucJl3”, this is because the command was not run as root and old credentials were not deleted. But new credentials are successfully created.
[grid@orcl01 ~]$ asmcmd --nocp credverify credverify: More than one credential in password file, please run 'credfix' to fix the credentials. [grid@orcl01 ~]$ asmcmd --nocp credfix credfix: Credentials for JXRUCJL3 not in password file, trying next credential. op=addcrscreds wrap=/tmp/creds0.xml credfix: Creating new credentials, no valid credentials in OCR. credfix: New user CRSUSER__ASM_004 created. op=credimport wrap=/tmp/creds0.xml olr=true force=true credfix: OLR for orcl01 has been fixed if credentials were created incorrectly. credfix: Starting SSH session on node orcl02. credfix: OLR for orcl02 has been fixed if credentials were created incorrectly. Exiting SSH session. op=delcrscreds crs_user=jxrucJl3 ASMCMD-8202: internal error: credfix: could not delete crs credentials for jxrucJl3
It is recommended to setup passwordless ssh connectivity for root user and then run credfix as root to have clean configuration without old entries:
[root@rac1 ~]# asmcmd --nocp credfix ..