Oracle Internet Directory Integration with Microsoft Active Directory

May 30, 2009 at 9:39 am | In Advanced Implementation of EBS | 14 Comments
Tags: , , , , , , , ,

Dear Readers,
In this post I will explain how to Integrate Oracle Internet Directory with Microsoft Active Directory in Detail
Pre-requisites
1.Install Oracle Identity Management Suite 10.1.4.0.1-Choose Infrastructure and Metadata Repository option and choose components SSO,ODISRV,AND All the components except Certificate Authroity and HA).
2.Install Windows 2003 Server and Configure Microsoft Active Directory in that Server
3.Bring these Servers in the same network.

Step -I.
Login to the OID Server and invoke dipassistant(oracle directory integration and provisioning admin console) using the following options

$dipassistant -gui
login as dipadmin and password will be the same as of the orcladmin super user which you gave during the installation of OID.

In the dipadmin console from the left pane in System Objects choose Active Directory beneath the icon ConfigurationSet1 and In the right pane You will see the Express Configuration Wizard.

Enter the Active Directory Server information and in credentials enter the Superuser Account
as administrator@ and in the connector name give any reasonable name and
if you press then the Import and export profile prepends the connector name and then
Click the check box Configure Access Control Policies if you want to enforce ACL.and then press OK
to save this information which will start the actual integration.

1. Express Configuration Wizard in dipadmin

Configuring Active Directory in dipadmin console

Configuring Active Directory in dipadmin console

On Successfull Integration dipadmin displays a success message which is given as below

Success Screen OID to AD

Success Screen OID to AD

Step II- Enable Bidirectional Synchronization in dipadmin for OID to AD
To achieve the bi-directional Synchronization — in dipadmin console choose the configured configset1 in the
left pane(system objects and in the right pane you will see the configured adImport and adExport(since i have given
the connector name as ad).choose those connector profile and edit and Enable those profiles for both export and Import.
If You enable both ,then synchronization of Users is bi-directional(both ways)(i.e from OID to AD and from AD to OID).
you can also note that bootstrap status(which has not started yet). I have given the screenshots below for editing
the connector profiles.

Enable AD Import connector Profile

Enable AD Import connector Profile

Enable AD Export connector Profile

Enable AD Export connector Profile

Step-III.
The initial migration of Users from Microsoft Active Directory to Oracle Internet Directory is called “bootstrap” process.
to do the bootstrap we need to execute the command as shown below..

Migrating initial Users from AD to OID

Migrating initial Users from AD to OID

Confirm the bootstrap is successfull by choosing the adImport profile (connector) in the configset1(in the right pane and doing an edit and check the status) which will show you that bootstrap is successfull which i have shown below.

Check the bootstrap(migration of users from AD to OID) is successfull

Check the bootstrap(migration of users from AD to OID) is successfull

Step IV:-
Now the initial Import of Users from AD to OID is complete.To start the synchronization of Users that are created both in AD and OID we need to start the odiserver(odisrv) with the configuration set 1(the one we have configured with dipadmin) we have use the following command

start the odisrv using configset1 to facilitate synchronization of Users bothways

start the odisrv using configset1 to facilitate synchronization of Users bothways

You can also verify that synchronization has started by editing the profiles and checking the status or by checking odisrvlogs in $ORACLE_HOME/ldap/logs ,you can also find the trc and aud files for these connectors in $ORACLE_HOME/ldap/odi/logs.

Step 5:-
The final step in the configuration process is to deploy the Active Directory External Authentication Plug-in,
which validates user-supplied passwords with AD during a user login sequence.
The following steps involve execution of a Unix shell script.
$ cd $ORACLE_HOME/ldap/admin
$ sh oidspadi.sh
A series of messages and prompts will be displayed as the script executes. Sample prompt responses:
Please enter Active Directory host name: ad.vectorconsulting.co.uk
Do you want to use SSL to connect to Active Directory? (y/n) n
Please enter Active Directory port number [389]: 389
Please enter DB connect string: iasdb
Please enter ODS password: oracleadmin1
Please enter confirmed ODS password: admin01
Please enter OID host name: sso.vectorconsulting.co.uk
Please enter OID port number [389]: 13061
Please enter orcladmin password: oracleadmin01
Please enter confirmed orcladmin password: oracleadmin01
Please enter the subscriber common user search base [orclcommonusersearchbase]: cn=Users,dc=vectorconsulting,dc=co,dc=uk
Please enter the Plug-in Request Group DN:
Please enter the exception entry property [(!(objectclass=orcladuser))]:
Do you want to setup the backup Active Directory for failover? (y/n) n

Return to the Oracle Directory Manager console upon successful completion
of the plug-in deployment process and navigate to the click the Plug-In Management fork.
Make sure that the Plug-in Enable property is set for both adwhencompare and adwhenbind.
Testing
At this point, OID has been populated with an initial set of users and groups via bootstrap migration from Active directory,
and the Oracle Directory Integration and Provisioning tool has been configured such that it will use the Active Directory
Connector to keep this information synchronized. The Oracle Directory Server has been directed to authenticate users
migrated from Active Directory using the Oracle-supplied Active Directory External Authentication
Plug-in. It should now be possible to log in to Oracle SSO or any integrated applications like E-Business Suite using
one of the migrated Active Directory users with its corresponding password.

Note: The username must be of the form name@

Step VI:- open the Oracle Directory Manager and verify that Users are Imported from Active Directory by navigating
to defaut domain and cn=Users and find the users of Active Directory which i have shown below.

Verify Active Directory Users are imported in OID

Verify Active Directory Users are imported in OID

Now go to the Windows Active Directory Server and verify that OID users are migrated there which i have shown below

Active Directory Manage Users Screen

Active Directory Manage Users Screen

Verifying that orcladmin user(or whatever users in OID is populated in AD)

orcladmin user populated in AD

orcladmin user populated in AD

Step VII. create New Users in AD and verify that user is synchronized with OID.

Here For example i have created a user “vivek rajendran” in Active Directory domain and verified its synchronizing in AD.

create a new user in active Directory

create a new user in active Directory

Verify the created User in AD is synchronized in OID

Verify the created User in AD is synchronized in OID

Step VIII.

Next Step is to create a test user in OID using oiddas self service webconsole .The screenshots are as follows.

creating a new user in oiddas self service webconsole in OID

creating a new user in oiddas self service webconsole in OID

Choosing group in oiddas while creating user

Choosing group in oiddas while creating user

created User successfully in oiddas web console

created User successfully in oiddas web console

Final Step :–

Verify that the user created in OID is reflected in AD

Verify that the user created in OID is reflected in AD

Trace and Audit Files for the connector(the screenshot is shown below):-

trace and auit files for the connector for OID to AD(Both ways).

trace and auit files for the connector for OID to AD(Both ways).

If you have any issues with the synchronization then you can view the aud,trc files above and also verify the log files for the odisrv as shown below(ORACLE_HOME/ldap/odi/log)

ODISRV logs

ODISRV logs

I hope You all have understood the Integration of OID with AD and if you have integrated other applications like oracle E-Business suite and if bi-directional provisioning is enabled there — then when you create any user in the E-Business Suite ,
they will be automatically enabled in Windows Active Directory and they will be able to log in as windows desktop Users.

Your Comments,Questions are Welcome.
–Vivek Rajendran

14 Comments »

RSS feed for comments on this post. TrackBack URI

  1. Hi,
    got INVALID_CREDENTIALS error in dipadmin console. Can ping AD server from OID server and vice-versa. Please, help.

  2. Hi,
    What is the oidspadi.sh windows equivalent script ?
    Thanks.

  3. Hi,
    I hope The domain in AD that you are trying to integrate in OID is not existing in OID. Login to OID Manager (front end) and if you expand the Entry Management you should find dc= the new domain entry.
    If its not there you will land up with this problem.You can add that new domain blank entry in OID using OID Manager.
    – Vivek

  4. I set up SSO and have it authenticated my credentials via AD instead of OID. Right now I have to enter my username on oracle portal in the form username@domain.

    I prefer to just enter in username and ignore the @domain part. Can I do that? If so, what components I need to configure?

    Thanks
    Andy

  5. Hi Vivek,

    We have configured Oracle E-Business 11i with Oracle SSO 10g. We are able to log onto the application using “Zero Sign-on”, that is using the Kerberos ticket through Internet Explorer. However we are getting an issue when trying to go through the Oracle Single Sign-On OracleAS 10g Login page or E-Business Suite 11i AppsLocalLogin page. We are getting error “Login failed. Please verify your login information or contact the system administrator”. This feature is works fine for about one hour after we restart the applications. After this period it does not work until we restart the server again.

    Grateful if you could provide some help,

    Kind regards,
    Selven

    • Hi Selven,
      Check out the metalink Note :-
      Troubleshooting SSO Windows Native Authentication (WNA)
      Doc ID: 283268.1
      Thanks
      – Vivek

  6. Hi

    can we intergrate oracle DB 10g R2 with Active directory ??
    DB is on linux and 2003 AD.

    if it is posible then … can you give me the process.

  7. Hi

    can we intergrate oracle DB 10g R2 with Active directory ??
    DB is on linux and 2003 AD.

    if it is posible then … can you give me the process.

    Thanks
    kosala

  8. Hi,
    I hope It should not be an issue, But check that all the required components are Installed(Oracle Identity Management components).
    – Vivek

  9. Hi,
    got following error (in french) at oidspadi last step (registering plug-ins):

    Registering Plug-ins …

    ajout de l’entrĂ©e cn=adwhencompare,cn=plugin,cn=subconfigsubentry
    ldap_add: Violation de classe d’objet
    ldap_add : info. supplémentaire : dn introuvable dans la liste des attributs obligatoires ou facultatifs.

    Means something like:

    add entry cn=adwhencompare,cn=plugin,cn=subconfigsubentry
    ldap_add: Object class violation
    ldap_add : info. suppl : dn not exists in mandatory/optional attributs list

    Please, help.

  10. Hi,
    It appears that the domain is existing in AD but not in OID. add a blank object entry in OID Manager(front end) for the new domain in OID(In Entry management dc=newdomain).then run the oidspadi.sh.
    –Vivek


Leave a comment

XHTML: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <pre> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Blog at WordPress.com. | Theme: Pool by Borja Fernandez.
Entries and comments feeds.