none
Oracle 11 G and FIM R2 SP1 RRS feed

  • Question

  • I have installed FIM R2 SP1. This is a new environment, not an upgrade.

    I have an Oracle Client 11.2 and 2 Databases one 10G and one 11G

    Everything works fine with the 10G MAs.

    11G, however, takes a very long time to just make a connection. about 2 hours to create the MA and the same time to run a Full Import (Simply starting to read the records)

    Table is only 25K records.

    When using SQLPLUS, everything works fine.

    Thanks,

    Nosh


    Nosh Mernacaj, Identity Management Specialist

    Monday, April 15, 2013 4:25 PM

Answers

  • Oracle made some “improvements” in 11 which is causing this issue in some environments. The SQL queries the Oracle driver sends to the database is ridiculously more complex in later releases. However, this is not consistent and does not happen with all databases. We have opened cases with Oracle on behalf of customers but when the customer hears from the driver team “we have no idea, we have to transfer you to the performance team” they lose interest. The simple workaround is to create a view and use it to connect to Oracle. The driver will revert back to the simple query and you get the same speed as earlier.

    • Marked as answer by Nosh Mernacaj Sunday, April 21, 2013 11:16 AM
    Saturday, April 20, 2013 4:33 PM

All replies

  • I believe this has something to do with your TNS Config, compare the one from 10G and  11G, and check if there is a difference.

    Regards Furqan Asghar

    Monday, April 15, 2013 5:53 PM
  • Thanks Furqan,

    The TNS settings are identical, except for the ports used.


    Nosh Mernacaj, Identity Management Specialist

    Monday, April 15, 2013 5:56 PM
  • Also try using the SID and ServiceName alternatively to check if that makes it better.

    I remember having this issue a couple of times, once it was the TNS Config and on the other as i was in a hurry to complete the project, ended up using SSIS to import data from Oracle to SQL and using an SQL MA instead.

    Lets hope someone here gives a solution to this, would be interesting.


    Regards Furqan Asghar


    Monday, April 15, 2013 6:00 PM
  • Thanks again,

    SID and serviceName are the same string


    Nosh Mernacaj, Identity Management Specialist

    Monday, April 15, 2013 6:05 PM
  • Just not to disappoint you but i found an unsolved old thread about this issue similar to yours

    http://social.technet.microsoft.com/Forums/en-US/ilm2/thread/8017a843-0ae0-40f6-8fbb-553d19e57274/

    Check it out


    Regards Furqan Asghar

    Monday, April 15, 2013 6:10 PM
  • Oracle made some “improvements” in 11 which is causing this issue in some environments. The SQL queries the Oracle driver sends to the database is ridiculously more complex in later releases. However, this is not consistent and does not happen with all databases. We have opened cases with Oracle on behalf of customers but when the customer hears from the driver team “we have no idea, we have to transfer you to the performance team” they lose interest. The simple workaround is to create a view and use it to connect to Oracle. The driver will revert back to the simple query and you get the same speed as earlier.

    • Marked as answer by Nosh Mernacaj Sunday, April 21, 2013 11:16 AM
    Saturday, April 20, 2013 4:33 PM
  • Many Thanks Andreas for taking the time to answer this questions.

    Are there any short-term or long-term works in progress (by MS, Oracle, or both) to offer a permanent solution?

    Thanks,

    Nosh


    Nosh Mernacaj, Identity Management Specialist

    Sunday, April 21, 2013 11:40 AM
  • There are no plans we have announced publically at this time.
    Sunday, April 21, 2013 9:55 PM
  • Thanks again Andres,
    Much appreciated!

    Nosh Mernacaj, Identity Management Specialist

    Monday, April 22, 2013 10:38 AM