Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

The start of crs version 19, ora.storage and ora.crsd offline. Suspect a bad ASM password. I start

user7586153Jun 20 2020 — edited Jun 22 2020

OS is RHEL 7 and Oracle version is 19.

Reviewing, ohasd_orarootagent_root.trc, it shows an ORA-01017 for ora.storage during crs start.

<TIMESTAMP>: USRTHRD:1006630656: [     INFO] {0:5:3} [ora.storage] ORA-01017: invalid username/password; logon denied

Attempted a fix as follows:

1.) Due to ora.crsd and ora.storage having OFFLINE status, Started up the secondary +ASM2 instance manually with a backup pfile from primary node using "sqlplus / as sysasm".  This successfully starts +ASM2.

2.) ASM2 starts up, cluster resources ora.crsd and ora.storage are now ONLINE ONLINE.

3.) Ran ocrdump, to find the credentials for SYSTEM.ASM.CREDENTIALS.USERS.CRSUSER__ASM_001

4.) Ran crsctl get credmaint -path /ASM/Self/xxxxxx -credtype userpass -id 0 -attr passwd -local, to obtain the password

5.) added user CRSUSER_ASM_001 to the ASM password file using: asmcmd orapwusr --add CRSUSER_ASM_001 & typed the password from credmaint one character at a time

6.) granted sysoper, sysdba, and sysadmin to CRSUSER_ASM_001 using: asmcmd orapwusr --grant sysdba CRSUSER__ASM_001

7.) Shutting down crs, and then starting crs presents the same error of of an ORA-01017 in the ohasd_orarootagent_root.trc for ora.storage.

8.) Recreation of ASM password file on secondary node is not successful, and I cannot stop / start crs without manual intervention on the Secondary node.  I need a permanent fix.  I would like to read MOS

note "How to recreate shared ASM password file in 12c GI cluster Document 1929673.1". but no doc opens in MOS.

I

Comments
Post Details
Added on Jun 20 2020
1 comment
2,883 views