Database Tables Used for JMS in OIM Schema (Doc ID 875579.1)

Last updated on JANUARY 31, 2022

Applies to:

Identity Manager
Information in this document applies to any platform. Oracle Containers for Java (OC4J)
WebSphere
WebLogic
JBoss

Purpose

This Note documents the different table names used for JMS in different versions of Oracle Identity Manager (OIM) and as it pertains to the different Application Servers OIM supports. These details are not included in the OIM Data Dictionary info in Tech <Note 377992.1> and are additional tables found in the OIM Schema.

Scope

Not all OIM installations would necessarily make use of a database store for JMS persistence. If your on an OC4J installation of OIM, then by default OC4J uses file based persistence. Following the steps listed in Tech <Note 554624.1> can, however, enable database persistence for your JMS Queues with OIM 9.1 in an OC4J environment. All other application servers by default do use database storage for JMS queues.

This is generally recommended for production installations by the way.