Situatie
There are a lot of situations when you need to know the Oracle Database Version and installed patches.
Solutie
There are 2 aspects when you verify the version and installed patches for an Oracle Database:
1. On Binary side (ORACLE_HOME):
-- For Unix/Linux Most common option: $ORACLE_HOME/OPatch/opatch lsinv For more details use "-details" option, like : $ORACLE_HOME/OPatch/opatch lsinv -details Very sort version could be $ORACLE_HOME/OPatch/opatch lspatches -- For Windows : Most common option: %ORACLE_HOME%\OPatch\opatch lsinv For more details use "-details" option, like : %ORACLE_HOME%\OPatch\opatch lsinv -details Very sort version could be %ORACLE_HOME%\OPatch\opatch lspatches
2. On Database Dictionary side:
sqlplus / as sysdba select * from dba_registry_history; select * from dba_registry_sqlpatch; set serverout on exec dbms_qopatch.get_sqlpatch_status;
Leave A Comment?