Oracle database as database system in 8.1


In the 8.0 product documentation I've read that in future versions of Identity Manager (such as 8.1) , Oracle as a database system for Identity Manager will no longer be supported.  Needless to say our current 7.x runs on Oracle and that announcement has triggered all the alarms here. So we're starting to make arrangements in our lab systems to make the migration to SqlServer, even in our current version.

Currently if I browse the forums I cannot find many cases regarding database architecture migration. Is there any documentation , procedures, guidelines to look at? Will version 8.1 provide tools to make this migration? And if so, could these be provided in advance to help us admins make the change?


  • As a bump , as well as an update.
    The upgrade from 7.0.3 to 8.0 , in systems with Oracle Database, is bugged and cannot be completed. There are missing procedures in the database (SR has been filed) and reported bugs.

    This, as a reminder of the urgence of a procedure to migrate to Sqlserver , as it seems that the Oracle product is gradually being deprecated.

    When we decided for Identity Manager we took into consideration the fact that it ran under Oracle and so we could take benefit of our huge database infrastructure and expertise. Aside from having to setup and support a different system now, theres the need to deal with investment in licenses and budget modifications.

    Any words from the product team?
  • Three SR cases already open, all three regarding Oracle issues. Older created on Jan 24th.
    None solved.
  • In reply to juancarlos:

    I'm very sorry to hear you ran into issues during your upgrade from version 7.0.3 to 8. Without knowing the actual SR numbers is difficult to comment on the status, however I would encourage to continue to work with our Support team as this is the best conduit to solve any of your outstanding issues. Now, on your original questions. We do have plans to release a Oracle to MS SQL migration tool to aid with the migration/transition from Oracle to MS SQL. Timelines for the migration tools are in the works, however it will be available ahead of One Identity Manager 8.1 General Availability (GA) date.

    Alex Binotto - Sr. Product Manager
  • In reply to Alex Binotto:


    Can you give us any idea when v8.1 is likely to be GA, and if v7.1.3 is going to have any further releases any time soon?
  • In reply to Alex Binotto:

    I started a SR on Feb 7th , issues updating 7.0.3 to 8.0 SR# 4203203
    The case still open and unsolved. Everytime this fails I need to go to our dba team , request a db restore and start over. Then post results to the SR , sit and wait around more than a week for an answer back.
    We cannot continue like this. No more.