Monday, December 19, 2016

oracle identity management rcu with oracle 12c database

Certification matrix for Oracle Identity Management 11G R2 states 12C Database is supported. Concretely the document states that "The Oracle databases listed are supported on all configurations (including RAC) and platforms that the database team supports" and Oracle 12.1.0.1+ is in the list.

I create a 12C Database Container Database and i also create a pluggable Dastabase to host my OIM schemas. I have download the RCU 11.1.1.9 which is the version supported for OIM 11G R2. But when i run it and try it for create the repositories it said that my Database is not supported.

After searching on the web i realized that i haven't read the release notes for OIM. https://docs.oracle.com/cd/E52734_01/core/IDMRN/intro.htm#IDMRN389

The release notes states that: "Oracle Database 12c (12.1.0.x) with PDB is not Supported in 11g Release 2 (11.1.2.3)"

There is also a second minor problem with 12C support. We need to run xaview.sql from ORACLE_HOME/rdbms/admin directory to create XAVIEW objects because as the release document states "For Oracle Database 10g and 11g databases, these objects are automatically created by RCU if they are not already in place. Oracle Database 12c databases have a new XAVIEW structure that requires the explicit creation of these objects."

If this script haven't run before the RCU, the RCU will stop with the following error:

Error: Views/Synonyms required for XA transaction support are missing in this Database 12c.
         These views/synonyms are required by the OIM Schema.
  Action: Refer Oracle Database Administrator's Guide to install XA transaction recovery views/synonyms
 using the script xaview.sql. Contact your DBA.

Running the script output:
SQL> @xaview.sql

DROP VIEW d$xatrans$

*

ERROR at line 1:

ORA-00942: table or view does not exist

DROP VIEW d$pending_xatrans$

*

ERROR at line 1:

ORA-00942: table or view does not exist

View created.

Synonym created.

View created.

Synonym created.

So after running the script the RCU generates the OIM schema successful.

As a conclusion the release notes for Oracle Products contains valuable information that some times documentation does not include and should not be ignored before installation.

No comments:

Post a Comment