My Learning

Go to existing oracle home (A new oracle home can be created with latest RU patch applied so that gold image has latest RU) ./runInstaller -createGoldImage -destinationLocation /home/oracle This will start wizard and complete the image creation automatically. Wizard  will show the status This will create image in a zipped format in the /home/oracle directory ex:     /home/oracle/19_hm_2/db_home_2021-09-14_11-42-14AM.zip extract the newly created image.zip file in the target location to create a new oracle home cd /home/oracle mkdir 19_hm_2 cd 19_hm_2 unzip  /home/oracle/19_hm_2/db_home_2021-09-14_11-42-14AM.zip pwd /home/oracle/19_hm_2 then run the runInstaller from the newly extracted home (target home) ./runInstaller -silent -debug -force oracle.install.option=INSTALL_DB_SWONLY UNIX_GROUP_NAME=dba ORACLE_HOME=/home/oracle/19_hm_2 ORACLE_BASE=/u01/app/oracle oracle.install.db.InstallEdition=EE oracle.install.db.DBA_GROUP=dba oracle.install.db.OPER_GROUP=dba oracle.install.db.OSBACKUPD

      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   Now sys is able to connect remotely without issues