Sunday, September 9, 2012

How to find the OID version


TO  KNOW  THE OID VERSION 

To Know the OID version we can use any one of this methods

There are three steps we can conform the OID version .
1]ldapsearch
2]oidldapd
3By connection to the OID database and verify with the query


1] Ldapserch

Syntax :ldapserch -h <hostname> -p <portnumber> -D "cn=orcladmin" -w <password> -b " " -s base "objectclass=*" orcldirectoryversion

[oracle@fah admin]$ ldapsearch -h fahmid.oasiserp.com -p 389 -D "cn=orcladmin" -w <password>  -b "" -s base "objectclass=*" orcldirectoryversion

orcldirectoryversion=OID 11.1.1.5.0


2]oidldapd

Syntax: $ORACLE_HOME/bin/oidldapd -version

[oracle@fah admin]$ $ORACLE_HOME/bin/oidldapd -version

oidldapd: Release 11.1.1.6.0 - Production on mon sep 10 00:47:41 2012

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

3] Query the OID database

Connect as the ODS user and run the below query to find the installed version

SQL> connect ODS
Enter password:
Connected.
SQL> show user
USER is "ODS"
SQL> select attrval from ds_attrstore where entryid = 1 and attrname = 'orcldirectoryversion';

ATTRVAL
--------------------------------------------------------------------------------
OID 11.1.1.5.0



No comments:

Post a Comment