Monday, February 5, 2018

Windows Server 2008 R2 with AD sync to oid (LDAP) to EBS 12.2.7


Database Server
----------------------------------------
RDBMS : 12.1.0.2.0
Oracle Applications : 12.2.7

Install windows server 2008 , Active Directory and create  organization,users














Setup organization and employee for AD















Integration with AD to OID

oracle@suthakar$./ldapbind -p 389 -h 00.0.0.000 -D "Administrator@domain.name" -w "password"
bind successful

syncProfileBootstrap -host hostname -port 7005 -D weblogic -profile ADOID -lp 5
Picked up _JAVA_OPTIONS: -Xms512m -Xmx1024m
[Weblogic user password]
Connection parameters initialized.
Connecting at hostnmae, with userid "weblogic"..
Connected successfully.

The bootstrap operation completed, the operation results are:
entries read in bootstrap operation: 4
entries filtered in bootstrap operation: 0
entries ignored in bootstrap operation: 0
entries processed in bootstrap operation: 3
entries failed in bootstrap operation: 1























 
OID to EBS 12.2

$FND_TOP/bin/txkrun.pl \
-script=SetSSOReg \
-registeroid=yes \
-ldaphost=hostname \
-ldapport=ldapport\
-oidadminuser=cn=orcladmin \
-instpass=password \
-oidadminuserpass=password \
-appspass=apps \
-provisiontype=3 \
-instpass=password\
-appname=SID\
-svcname=SID

Beginning input parameter validation for OID registration.
Input parameters validation for OID registration completed.

BEGIN OID REGISTRATION:
Beginning to register Application and Service containers if necessary.
Application and Service containers were created successfully if necessary.
Beginning to register application in Oracle Internet Directory.
Registration of application in Oracle Internet Directory completed successfully.
[info] -> LOADING:  /apps2/oracle/product/fs1/EBSapps/appl/fnd/12.0.0/admin/template/AppsOIDRegistration.tmp
Feb 27, 2018 2:27:44 PM oracle.ldap.util.LDIFLoader loadOneLdifFile
INFO: -> LOADING:  /apps2/oracle/product/fs1/EBSapps/appl/fnd/12.0.0/admin/template/AppsOIDRegistration.tmp
Beginning to register provisioning profile in Oracle Internet Directory.
Registration of provisioning profile in Oracle Internet Directory completed successfully.
Application is now registered successfully with provisioning in Oracle Internet Directory.

End of /apps2/oracle/product/fs1/EBSapps/appl/fnd/12.0.0/patch/115/bin/txkSetSSOReg.pl : No Error



  1  select user_name,creation_date,user_guid,email_address from fnd_user where creation_date>
  2* (SYSDATE - 1)
SQL> /

USER_NAME
--------------------------------------------------------------------------------
CREATION_DATE      USER_GUID
------------------ --------------------------------
EMAIL_ADDRESS
--------------------------------------------------------------------------------
EBS122
27-FEB-18          66369A8AB638AA23E050000A8500658F
orcladmin


















 1* select user_name, USER_GUID from fnd_user where creation_date> (SYSDATE - 1)
SQL> /
EBS1
664870D26A3DB26AE050000A8500369C

EBSSAND
664870D26A3FB26AE050000A8500369C

EBS122@SUTHAKAR.PRINCE
664870D26A45B26AE050000A8500369C

EBS122
66369A8AB638AA23E050000A8500658F

EBSUSER@SUTHAKAR.PRINCE
664870D26A47B26AE050000A8500369C

EBSUSER2@SUTHAKAR.PRINCE
664870D26A48B26AE050000A8500369C

EBSUSER3@SUTHAKAR.PRINCE
664870D26A49B26AE050000A8500369C


No comments: