My Learning

      ADDM snapshot status(dba_advisor_tasks) shows FATAL Error and error_message is ORA-13707: Either the start snapshot     or the end snapshot     is incomplete or missing key statistics.       Recently control_management_pack_access parameter was changed to DIAGNOSTIC+TUNING that was the cause of the issue. Though this parameter is dynamic due to a BUG it needs a database restart .   Once database restarted snapshots were successful and ADDM was able to run succesfully.   Ref Note: 1999635.1    

     DB: 12.1.0.2 Two node RAC instance Password file is on ASM   Though password file exist and correct password is available sys is not able to log in remotely (ORA-01017: invalid username/password logon denied)   pwget   -- dbuniquename   acmd8   +DGDATA1/ACMD8/PASSWORD/pwdacm88.312.1082199199   Recreated the password file Still the same error   Deleted the password file with   pwdelete   and created password file locally on the machine, yet the issue remained the same      checking further revealed Show parameter   sec_case_sensitive_logon      is set to false   sec_case_sensitive_logon                boolean        FALSE   so recreated the password file with ignore option   orapwd   file='+DGDATA1' password='Capandsamll2021'   dbuniquename = ACMD8   ignorecase =y ...