Oracle Internet Directory (OID) is LDAP compliant directory server from Oracle. OID is part of Identity Management stack of Fusion Middleware (Infrastructure tier of Oracle Application Server) 

Here is list of commonly asked questions/scripts for OID

Q: How to find orasso (Single Sign-On) schema password.
A: orasso password is randomly generated and stored in OID. To find password run below query

$ORACLE_HOME/bin/ldapsearch -h $OIDHOST -p $OIDPORT-D “cn=orcladmin” -w “$OrcladminPASSWORD” -b “cn=IAS Infrastructure Databases,cn=IAS,cn=Products,cn=OracleContext” -s sub “orclResourceName=$DBUSERNAME” orclpasswordattribute

like

$ORACLE_HOME/bin/ldapsearch -h focusthread.com -p 389-D “cn=orcladmin” -w “welcome1” -b “cn=IAS Infrastructure Databases,cn=IAS,cn=Products,cn=OracleContext” -s sub “orclResourceName=orasso” orclpasswordattribute

Q: How to find port on which OID server is listening ?
A:
on Infrastructure Tier $ORACLE_HOME/ldap/admin/ldap.ora  look for line
DIRECTORY_SERVERS= (focusthread.com:389:636)   –> This means OID is listening on port 389 NonSSL & 636 on SSL Port

or

In file $ORACLE_HOME/install/portlist.ini look for line
Oracle Internet Directory port = 389
Oracle Internet Directory (SSL) port = 636

Q: To find password policy in OID
A:
$ORACLE_HOME/bin/ldapsearch -h $OIDHOST -p $OIDPORT -D cn=orcladmin -w $ORCLADMIN_PASSWD -b “cn=default,cn=pwdPolicies,cn=Common,cn=Products,cn=OracleContext” -s base “objectclass=*”

like

$ORACLE_HOME/bin/ldapsearch -h focusthread.com-p 389 -D cn=orcladmin -w welcome1 -b “cn=default,cn=pwdPolicies,cn=Common,cn=Products,cn=OracleContext,dc=com”
-s base “objectclass=*” >> pwdPolicy.ldif

This will create file pwdPolicy.ldif in currently directory listing password policies

Q: How to query what all E-Business Suite Instance are registered in OID ? (useful for OID-Apps 11i/R12 Integration)

$ORACLE_HOME/bin/ldapsearch -h $OIDHOST -p $OIDPORT-D “cn=orcladmin” -w “$OIDPW” -b “cn=EBusiness,cn=Products,cn=OracleContext,dc=default_realm” -s sub “objectclass=*”

like
$ORACLE_HOME/bin/ldapsearch -h focusthread -p 389-D “cn=orcladmin” -w “welcome1” -b “cn=EBusiness,cn=Products,cn=OracleContext,dc=co,dc=uk” -v -s sub “objectclass=*”

Q: Query for subscription list in OID ? (useful for OID-Apps 11i/R12 Integration)
A. $ORACLE_HOME/ldap/odi/bin/provsubtool.orc operation=LIST \
     ldap_host=host ldap_port=port \
     app_dn=”ApplicationDN” realm_dn=”SubscriberDN” \
     app_pwd=AppDN password

Q: How to find provisioning profiles (useful for OID-Apps 11i/R12 Integration)
A.ldapsearch -h host -p port-D cn=orcladmin -w password \
-b “cn=Provisioning Profiles, cn=Changelog Subscriber, cn=Oracle Internet Directory” \
-s sub “objectclass=*” “*” 
 
Q: How to search for various user attributes ?
A.ldapsearch -v -h “${Host}” -p ${Port} -D “cn=orcladmin” -w “${OIDManagerPasswd}” -b “” -s sub “uid=${AppsUser}*”  uid orclguid orclactivestartdate orclactiveenddate orclisenabled

Q: How to find default OID realm
A.
$ORACLE_HOME/bin/ldapsearch -h $OIDHOST -p $OIDPORT-D “cn=orcladmin” -w $ORCLADMIN_password-b “cn=common, cn=products, cn=oracleContext” -s base “objectclass=*” orcldefaultSubscriber

$ORACLE_HOME/bin/ldapsearch -h focusthread.com -p 389 -D “cn=orcladmin” -w welcome1 -b “cn=common, cn=products, cn=oracleContext” -s base “objectclass=*” orcldefaultSubscriber

If you have any Query regarding OID , update it in comment section for answers

Related Posts for OID


  1. Oracle Internet Directory OID
  2. Oracle Internet Directory – Basics II
  3. OID to OID/Active Directory/iPlanet other LDAP Server Integration
  4. Multi Master OID Replication
  5. OID Architecture
  6. Oracle Internet Directory , OID Troubleshooting
  7. Server Chaining in OID
  8. OID Quesries/ Scripts FAQ
  9. OIDADMIN Client
  10. Oracle Identity Management (OID) 11g installation Issues on Linux
  11. OID 11g – Oracle Directory Services Manager (ODSM)
  12. DIP : Synchronization, Provisioing, Connectors, DSS in Oracle Directory Services (ODS) 11g
  13. OID Replication – Suppliers, Consumers, DRG, ASR/LDAP based replication
  14. ASR setup has failed – Error occurred while dropping database link : ORA-02084 : database name is missing a component while Configuring Multi Master OID replication using “remtool -asrsetup”
  15. OID 11g Down : Unable to Start OID 11g using OPMN (ODS schema locked ORA-28002)
  16. OID/Directory Services 11g – Schema, Object Class, Attributes
  17. OID 11g Distributed Install : DIP/ODSM (Java Component) & OID (LDAP/REPLD) on different machine
  18. OID Server Mode R, RW, RM: LDAP: error code 53 – Server currently in read only mode
  19. How to change OID 11g database schema (ODS) password
  20. How to add custom attribute, Object Classe in OID from command line or GUI
  21. Oracle Internet Directory (OID) and Real Application Cluster (RAC) database : Things you must know
  22. How to Update User Password in OID (single account or bulk) – command line or GUI
  23. Error starting OID 11g during configuration stage of OID installation on Windows Server “ProvisionException: Failed to start the component”
  24. How to delete Entries in OID 11g in Bulk – Delete Failed : Ldap Error Code 66 Not allowed on Non-Leaf
  25. How to find latest changelog number (or changes) in OID ?
  26. Context Initialization Error on running ldapsearch commands on OID Server
  27. How to find OID version and patches applied on OID Home ?
  28. How to change OID 11g LDAP/LDAPS listen port
  29. How to find/audit Failed Login Attempts in OID 11g
  30. Step by Step configuration of OID Multi Master Replication – LDAP based in OID 11g
  31. OID 11g LDAP based Multi Master replication : Configuration Entries you must know
  32. Configure SSL for Oracle Internet Directory (OID)
  33. How to backup Oracle Internet Directory (OID) 11g – Data : Full / Partial
  34. SSL / Wallets in OID/OHS : How to manage certificates in Wallet using command line ?? ORAPKI
  35. How to debug OID : LDAP Error code 50 – Insufficient Access Rights
  36. What Hashing Algorithm OID uses to store user Password : SSHA or MD5