How to check Oracle Database Version and installed patches

Configurare noua (How To)

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;

Tip solutie

Permanent

Voteaza

(10 din 11 persoane apreciaza acest articol)

Despre Autor

Leave A Comment?