Oracle: Check Patching backup files

 Hello

How to check the patching backup files

  1. Check what patches OPatch thinks are installed:
 
$ORACLE_HOME/OPatch/opatch lsinventory
$ORACLE_HOME/OPatch/opatch lsinventory -detail
 

Oracle documents lsinventory as the standard way to verify applied patches and Oracle home inventory state.

  1. Check whether rollback files exist under .patch_storage:
 
cd $ORACLE_HOME
ls -ld .patch_storage
find .patch_storage -maxdepth 2 -type d | sort
du -sh .patch_storage
 

If the patch was applied normally, you should see patch-related content there, because OPatch saves the replaced files in $ORACLE_HOME/.patch_storage during installation.

  1. Check OPatch logs and history:
 
ls -ltr $ORACLE_HOME/cfgtoollogs/opatch
tail -100 $ORACLE_HOME/cfgtoollogs/opatch/history.txt
 
Regards
Martin Gomez 

Comments

Post a Comment

Popular posts from this blog

Postgres: Clean up stopped replication slot

Image
  When a slot is inactive, that means that Murty and his team have stopped the replication on their side. The SQL below will identify inactive slots. We should schedule this script in a job , running every hour.    (1) SELECT  slot_name,  pg_size_pretty(pg_wal_lsn_diff(pg_current_wal_lsn(),restart_lsn)) AS size,  active,  slot_type  FROM pg_replication_slots;       (2) Once you identify the replication slot, the job should drop it with the following command:     SELECT pg_drop_replication_slot ('pg_replication_slot_name_from_above');         (3) Restart the database instance to clean up unwanted disk space.   Notes from Google:- Thank you for contacting Google Cloud Support. My name is Jagadeesh and I will be assisting you with this issue.   I understand that WAL logs are expanding to over 1.5TB and you want to know what is causing WAL logs to grow and you want to reduce it. Please confirm if ...
Read more

PeopleSoft: Clean Up PUM

  Manual Cleanup steps for WINDOWS Before carrying out the advanced steps in this section: Run the command:  psft-dpk-setup.bat --cleanup. If you deployed the environment using the use_alternate_puppet_install option, use this command:   psft-dpk-setup.bat --cleanup --use_alternate_puppet_install If the script displays a FAILED message, run it again. If it succeeds, check the BASE_DIR folders to be sure everything has been deleted. If the BASE_DIR folders are not clear, or if a subsequent deployment is not successful, carry out the steps below. For the  ADVANCED CLEAN UP PROCESS  on Microsoft Windows, please see the following steps. NOTE: These should be performed by someone familiar with modifying the Microsoft Windows registry. Depending upon where the cleanup process failed, some of the items mentioned in these steps may have already been removed. The user should remove whatever remains in this order: Start the Microsoft Windows Services utilit...
Read more