Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to solve the problem that ASM can not start after Oracle RAC 12.2 restart". The content of the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "how to solve the problem that ASM can not start after Oracle RAC 12.2 restart".

1. Customers have a set of 12.2 clusters to start. Asm cannot be started automatically. Check that asm is online in crsctl stat res-t.

It is not actually started. At this point, manual sqlplus starts asm, and the cluster starts up.

two。 View cluster logs

/ u1/app/grid/diag/crs/test-rac1/crs/trace/crsd_orarootagent_root.trc

The following information was not found by SYSTEM.credentials.domains.root.ASM.Self

2019-03-05 15 Error 12 querying length of attr ASM_DISCOVERY_ADDRESS 54.606: USRTHRD:3580360448: {0:5:3} 8154 Error 4 querying length of attr ASM_DISCOVERY_ADDRESS 2019-03-05 15 15 querying length of attr ASM_DISCOVERY_ADDRESS 12 querying length of attr ASM_DISCOVERY_ADDRESS 54.613: USRTHRD:3580360448: {0:5:3} 8154 Error 4 querying length of attr ASM_STATIC_DISCOVERY_ADDRESS 2019-03-05 15 Fringe 12 USRTHRD:3580360448: CLSCRED:3580360448: (: CLSCRED1079:) clsCredOcrKeyExists: Obj dom: SYSTEM.credentials.domains.root.ASM.Self.e4fb93042857cfbaff645d39cd3af92a.root not found

3. Solution: reset the password of the CRSUSER__ASM_001 user, refer to the documentation ID 2392762.1

Grid@test06:~ > crsctl get credmaint-path / ASM/Self/e4fb93042857cfbaff645d39cd3af92a-credtype userpass-id 0-attr passwd-localuuzd8rhu2UH0GugsoJaIk0qiqGpBhvi-- query CRSUSER__ASM_001 password for password file reconstruction (if not available, check it from ocrdump) ASMCMD > pwcopy + CRSDG/orapwASM / tmp/asm.pw-- backup password file ASMCMD > orapwusr-- modify CRSUSER__ASM_001-- modify password Enter password: uuzd8rhu2UH0GugsoJaIk0qiqGpBhvi

4. Restart crs after changing the password. If it cannot be solved, you need to restart the crs of all nodes.

Thank you for your reading, the above is the content of "how to solve the problem that ASM can not start after Oracle RAC 12.2 restart". After the study of this article, I believe you have a deeper understanding of how to solve the problem that ASM cannot be started after Oracle RAC 12.2 restart, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.