Oracle Internet Directory (OID) is LDAP\u00a0compliant directory server from Oracle. OID is part of Identity Management stack of Fusion Middleware (Infrastructure tier of Oracle Application Server)\u00a0<\/p>\n
Here is list of commonly asked questions\/scripts\u00a0for OID<\/p>\n
Q: How\u00a0to find orasso (Single Sign-On) schema password. $ORACLE_HOME\/bin\/ldapsearch -h $OIDHOST<\/strong> -p $OIDPORT<\/strong>-D “cn=orcladmin” -w “$OrcladminPASSWORD<\/strong>” -b “cn=IAS Infrastructure Databases,cn=IAS,cn=Products,cn=OracleContext” -s sub “orclResourceName=$DBUSERNAME<\/strong>” orclpasswordattribute $ORACLE_HOME\/bin\/ldapsearch -h\u00a0focusthread.com<\/strong> -p 389<\/strong>-D “cn=orcladmin” -w “welcome1<\/strong>” -b “cn=IAS Infrastructure Databases,cn=IAS,cn=Products,cn=OracleContext” -s sub “orclResourceName=orasso<\/strong>” orclpasswordattribute or<\/p>\n In file $ORACLE_HOME\/install\/portlist.ini look for line Q: To find password policy in OID like<\/p>\n $ORACLE_HOME\/bin\/ldapsearch -h\u00a0focusthread.com<\/strong>-p 389 -D cn=orcladmin -w welcome1 -b “cn=default,cn=pwdPolicies,cn=Common,cn=Products,cn=OracleContext,dc=com” Q: How to query what all E-Business Suite Instance are registered in OID ? <\/strong>(useful\u00a0for OID-Apps 11i\/R12 Integration)<\/p>\n $ORACLE_HOME\/bin\/ldapsearch -h $OIDHOST<\/strong> -p $OIDPORT<\/strong>-D “cn=orcladmin” -w “$OIDPW<\/strong>” -b “cn=EBusiness,cn=Products,cn=OracleContext,dc=default_realm<\/strong>” -s sub “objectclass=*”<\/p>\n like Q: Query for subscription list in OID ? <\/strong>(useful\u00a0for OID-Apps 11i\/R12 Integration) Q: How to find provisioning profiles<\/strong> (useful\u00a0for OID-Apps 11i\/R12 Integration) $ORACLE_HOME\/bin\/ldapsearch -h\u00a0focusthread.com -p 389 -D “cn=orcladmin” -w welcome1 -b “cn=common, cn=products, cn=oracleContext” -s base “objectclass=*” orcldefaultSubscriber<\/p>\n If you have any Query regarding OID , update it in comment section for answers<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":" Oracle Internet Directory (OID) is LDAP\u00a0compliant directory server from Oracle. OID is part of Identity Management stack of Fusion Middleware […]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[172],"tags":[194,193,474],"class_list":["post-344","post","type-post","status-publish","format-standard","hentry","category-scripts","tag-faq","tag-oid-queries","tag-scripts"],"yoast_head":"\n
\n<\/strong>A: orasso password is randomly generated and stored in OID. To\u00a0find password run below query<\/p>\n
\nlike<\/p>\n
\nQ: How to find port on which OID server is listening ?
\nA: <\/strong>on Infrastructure Tier $ORACLE_HOME\/ldap\/admin\/ldap.ora<\/strong>\u00a0 look for line
\nDIRECTORY_SERVERS= (focusthread.com:389:636)\u00a0\u00a0 –> This means OID is listening on port 389 NonSSL & 636 on SSL Port<\/p>\n
\nOracle Internet Directory port = 389
\nOracle Internet Directory (SSL) port = 636
\n<\/strong><\/p>\n
\nA: <\/strong>$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=*”<\/p>\n
-s base “objectclass=*” >> pwdPolicy.ldif
\nThis will create file pwdPolicy.ldif in currently directory listing password policies<\/p>\n
$ORACLE_HOME\/bin\/ldapsearch -h\u00a0focusthread<\/strong> -p 389<\/strong>-D “cn=orcladmin” -w “welcome1<\/strong>” -b “cn=EBusiness,cn=Products,cn=OracleContext,dc=co,dc=uk<\/strong>” -v -s sub “objectclass=*”
<\/p>\n
\nA. <\/strong>$ORACLE_HOME\/ldap\/odi\/bin\/provsubtool.orc operation=LIST \\
\u00a0\u00a0\u00a0\u00a0 ldap_host=host ldap_port=port \\
\u00a0\u00a0\u00a0\u00a0 app_dn=”ApplicationDN” realm_dn=”SubscriberDN” \\
\u00a0\u00a0\u00a0\u00a0 app_pwd=AppDN password<\/p>\n
\nA.<\/strong>ldapsearch -h host<\/strong> -p port<\/strong>-D cn=orcladmin -w password<\/strong> \\
-b “cn=Provisioning Profiles, cn=Changelog Subscriber, cn=Oracle Internet Directory” \\
-s sub “objectclass=*” “*”\u00a0
\u00a0
Q: How to\u00a0search for various user attributes ?<\/strong>
\nA.<\/strong>ldapsearch -v -h “${Host}” -p ${Port} -D “cn=orcladmin” -w “${OIDManagerPasswd}” -b “” -s sub “uid=${AppsUser}*”\u00a0 uid orclguid orclactivestartdate orclactiveenddate orclisenabled
\nQ: How to find default OID realm
\nA. <\/strong>$ORACLE_HOME\/bin\/ldapsearch -h $OIDHOST<\/strong> -p $OIDPORT<\/strong>-D “cn=orcladmin” -w $ORCLADMIN_password<\/strong>-b “cn=common, cn=products, cn=oracleContext” -s base “objectclass=*” orcldefaultSubscriber<\/p>\n