My Oracle Support Banner

Row and Page Locking Experienced when ODI Repositories Are Installed on Sybase (Doc ID 424020.1)

Last updated on DECEMBER 12, 2023

Applies to:

Oracle Data Integrator - Version 3.2.03.01 and later
Information in this document applies to any platform.

Symptoms

Lockouts are often experienced when working in Oracle Data Integrator (ODI) Designer and Operator when the Repositories are installed on Sybase databases.

These problems are encountered by connected users who are unable to shutdown these GUI modules without killing ODI from the system task manager.

Other users attempting to log in, open up the login screen and after clicking on the OK button to bring up ODI Designer, the module is not launched as expected. If the connections which have set locks in the database are killed, ODI Designer is successfully launched.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.