How to find OID version and patches applied on OID Home ?

Oracle Internet Directory (OID) consists of Repository (LDAP objects stored in Oracle Database under schema ODS) and OID Software (created during OID installation). This post covers steps to find OID version and patches applied to OID ORACLE_HOME .

For steps on how to find version of WebLogic click here , E-Business Suite version click here , and for WebGate version click here

OID version from LDAP Entry ?

$ORACLE_HOME/bin/ldapsearch -h <oid_host> -p <oid_port> -D cn=orcladmin -q -s base -b “” objectclass=* orcldirectoryversion orclcompatibleversion

You should see output like

orcldirectoryversion=OID 11.1.1.5.0

where 11.1.1.5.0 represents OID version 11.1.1.5

Note: For OID 11.1.1.6 or higher version user value for attribute orclcompatibleversion as OID version.

OID version from OID Executable

$ORACLE_HOME/bin/oidldapd -version

You should see output like
oidldapd: Release 11.1.1.5.0 – Production on thu mar 22 14:34:05 2012

Copyright (c) 1982, 2011 Oracle.  All rights reserved.

OID version from database

Connect as user ODS and run query
SQL> select attrval from ds_attrstore where entryid = 1 and attrname = ‘orcldirectoryversion’;

How to find patches installed in OID Oracle Home
$ORACLE_HOME/OPatch/opatch lsinventory

where ORACLE_HOME is directory in which OID software is installed

output like below represents that OID software is 11.1.1.5.0 with 13 patches

_________

Installed Top-level Products (2):

Oracle Identity Management 11g                                       11.1.1.2.0
Oracle Identity Management 11g Patchset                              11.1.1.5.0
There are 2 products installed in this Oracle Home.

Interim patches (13) : ******
__________

Share This Post with Your Friends over Social Media!

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

4 comments
Sourabh Gupta says September 29, 2012

Hi Atul,

When I am running the commands, output is different.

ldapsearch -h lcosoim2.cos.agilent.com -p 6060 -D “cn=orcladmin” -w ***** -b “” -s base “objectclass=*” orcldirectoryversion orclcompatibleversion

orcldirectoryversion=OID 11.1.1.2.0
ssomgr@lcosoim2:/home/ssomgr> $ORACLE_HOME/bin/oidldapd -version

oidldapd: Release 11.1.1.3.0 – Production on sat sep 29 15:42:43 2012

Copyright (c) 1982, 2010 Oracle. All rights reserved.

ssomgr@lcosoim2:/home/ssomgr>

Reply
Atul Kumar says September 29, 2012

Sourabh,
There could be some cases where schema version is same or lower version. In your case it looks like with OID 11.1.1.3 version there was no change in schama (and hence you see 11.1.1.2 in schema)

Are you hitting any issue starting OID because of this version mismatch ?

Did you upgrade OID recently ?

Reply
Sourabh Gupta says September 29, 2012

Hi Atul,

its test instance , I checked with the Production everything seems to be same.

We are not facing any issue.

With ldapsearch its giving the schema version where as with ORACLE_HOME/bin/oidldapd -version , its giving the OID executable version.

Regards
Sourabh Gupta

Reply
UTPAL says March 25, 2016

OID version from database is incorrect, You have to use the below
SELECT VERSION FROM SCHEMA_VERSION_REGISTRY where OWNER=’ODS’;

Reply
Add Your Reply