ASM Integrity check failed with PRCT-1225 and PRCT-1011 errors while creating database using DBCA on Exadata 3 node RAC

 

Error:

The error message PRCT-1225: failed to verify Oracle Automatic Storage Management (Oracle ASM) user credentials using the command 'asmcmd credverify' indicates that the asmcmd credverify command failed to verify the Oracle ASM user credentials. This can happen for a number of reasons, including:

• The user credentials are incorrect.
• The user credentials file is corrupted.
• The user does not have the necessary permissions to run the asmcmd credverify command.
• There is a problem with the Oracle ASM instance.

To troubleshoot this error, you can try the following:

1. Make sure that the user credentials are correct. You can do this by trying to log in to the Oracle ASM instance using the same credentials.
2. Check the user credentials file for errors. You can do this by using a text editor to open the file and inspect the contents.
3. Make sure that the user has the necessary permissions to run the asmcmd credverify command. You can do this by checking the user's permissions on the Oracle ASM instance and on the user credentials file.
4. If you are still having problems, try restarting the Oracle ASM instance.
5. If you are still having problems, contact your system administrator for help.

Here are some additional tips for troubleshooting this error:

• If you are using a password file to store the Oracle ASM user credentials, make sure that the file is in the correct format and that it is readable by the Oracle ASM instance.
• If you are using a single sign-on (SSO) solution to manage the Oracle ASM user credentials, make sure that the SSO solution is configured correctly.
• If you are using a cloud-based Oracle ASM instance, make sure that you have the correct permissions to access the instance.

Solution:

$ asmcmd credfix

credfix: Credentials for CRSUSER__ASM_002 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_001 created.

op=credimport wrap=/tmp/creds0.xml olr=true force=true

credfix: OLR for xxxxxx01 has been fixed if credentials were created incorrectly.

credfix: Starting SSH session on node xxxxxxx02.

credfix: OLR for xxxxxxx02 has been fixed if credentials were created incorrectly. Exiting SSH session.

credfix: Starting SSH session on node xxxxxx03.

credfix: OLR for xxxxxxx03 has been fixed if credentials were created incorrectly. Exiting SSH session.

op=delcrscreds crs_user=CRSUSER__ASM_002

credfix: Deleted CRSUSER__ASM_002 from OCR.

credverify: Credentials created correctly on xxxxxx01.

credverify: Starting SSH session on node xxxxxx02

credverify: Credentials created correctly on xxxxxx02. Exiting SSH session.

credverify: Starting SSH session on node xxxxxx03

credverify: Credentials created correctly on xxxxxx03. Exiting SSH session.

credfix: Credentials have been fixed if they were created incorrectly.