- download patch
- unpack
- shutdown instance
- read README file
- change directory to unpacked archive
- opatch apply
- run Post Installation Instructions
check patches allready install:
opatch lsinventory
opatch lsinventory -detail
check patch:
opatch query -all /[path_to_patch_directory]
check opatch options
opatch -help [option]
logs:
[ORACLE_HOME]/cfgtoollogs/opatch
[ORACLE_HOME]/cfgtoollogs/opatch/opatch_history.txt
rollback:
opach rollback -id [nr_patcha]
check invalid objects:
SELECT object_name FROM dba_objects WHERE status = 'INVALID';
compile all invalid objects:
[ORACLE_HOME]/rdbms/admin/utlrp.sql
which launch script [ORACLE_HOME]/rdbms/admin/utlprp.sql z parametrem=0
– parametr=0 – run parallel with CPU_COUNT
– parametr=1 – run in one process
– parametr=N – number of parallel run