ORACLE PATCH

download opatch

1. download patch
2. unpack
3. shutdown instance
4. read README file
5. change directory to unpacked archive
6. opatch apply
7. 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