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



1 comment:

  1. Thanks for sharing such a practical and thorough guide—the insights highlighted here are spot on. Implementing the Oracle Financial Accounting Hub is a game-changer for enterprises managing diverse transactional feeder systems. Centralizing multi-source data and enforcing consistent accounting transformation rules dramatically accelerates period-end close while ensuring complete auditability and data integrity across the board.

    ReplyDelete