OBIEE 11g/12c: Retrieve Patch List for OBIEE Using the OPatch

To get the list of patches applied in an OBIEE environment, the opatch lsinventory command can be used.

OBIEE 11g:

Depending on the Oracle Home you want to check, set ORACLE_HOME either to Oracle_BI1 or oracle_common.

Windows:
set ORACLE_HOME=C:\mwhome\Oracle_BI1
set JAVA_HOME=%ORACLE_HOME%
set PATH=%ORACLE_HOME%\OPatch;%JAVA_HOME\bin%;%ORACLE_HOME%\bin;%PATH%

opatch lsinventory | findstr “applied”

Unix:
export ORACLE_HOME=/mwhome/Oracle_BI1
export JAVA_HOME=/mwhome/Oracle_BI1/jdk
export PATH=/mwhome/Oracle_BI1/bin:$/mwhome/Oracle_BI1/jdk/bin:/mwhome/Oracle_BI1/OPatch:$PATH

Navigate to <mwhome>/Oracle_BI1/Opatch

./opatch lsinventory | grep -i ‘applied’

./opatch lspatches

OBIEE 12c:

Windows:
set ORACLE_HOME=C:\mwhome\Oracle_Home

opatch lsinventory -jre %ORACLE_HOME%\oracle_common\jdk\jre | findstr “applied”

Unix:
export ORACLE_HOME=/mwhome/Oracle_BI1

Navigate to <mwhome>/Oracle_BI1/Opatch

./opatch lsinventory -jre $ORACLE_HOME/oracle_common/jdk/jre | grep -i ‘applied’ 

./opatch lsinventory | grep -i ‘applied’

./opatch lspatches