Установка OIM12c - ошибка "Views\Synonyms required for XA transaction support are missing" при запуске RCU

Short intro: here you can find a FAQ answer about common RCU issue when installing OIM12c...

Уже не помню, кто меня спрашивал (видимо, они уже решили этот вопрос без моей помощи), но вот и я наткнулся на эту ошибку. А именно, при установке OIM 12c (12.2.1.3.0) запуск утилиты RCU дает следующую ошибку:

ERROR - RCU-6083 Prerequisite check failed for selected component:
CAUSE - RCU-6083 Prerequisite check failed for selected component.
ACTION - RCU-6083 Refer to the RCU logs for additional details. Make sure that the prerequisite requirements are met.OIM
Refer to RCU log at C:\Users\Administrator\AppData\Local\Temp\RCU2017-11-24_05-44_1628611847\logs\rcu.log for details.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  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.
          For Database12c CDB config: execute xaview.sql from PDB SYS user
          For Database12c NON-CDB config: execute xaview.sql from CDB SYS user
  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ERROR - RCU-6092 Components are not selected properly.
CAUSE - RCU-6092 Component Selection validation failed. Refer to log at C:\Users\Administrator\AppData\Local\Temp\RCU2017-11-24_05-44_1628611847\logs\rcu.log for details.
ACTION - RCU-6092 Select one or more components to continue.

Решение - под катом.



Неверные параметры БД по умолчанию. Нашел решение на oradba.co.uk (http://www.oraworld.co.uk/oim-rcu-creation-xatrans-views-are-not-installed-on-this-database/), на всякий случай скопирую его здесь:

a) As the SYS user, enable the Oracle database for XA by performing the following steps:

sqlplus / as sysdba
@$ORACLE_HOME/javavm/install/initxa.sql
PL/SQL procedure successfully completed.

JVMRMACTION
--------------------------------
FULL_REMOVAL
PL/SQL procedure successfully completed.
Package created.
Package body created.
Synonym created.
Grant succeeded.

Execute $ORACLE_HOME/rdbms/admin/xaview.sql
SQL> @xaview.sql
DROP VIEW v$xatrans$
*
ERROR at line 1:
ORA-00942: table or view does not exist
DROP VIEW v$pending_xatrans$
*
ERROR at line 1:
ORA-00942: table or view does not exist
View created.
View created.
SQL>

b) Make sure the below paramters have corresponding values.

show parameters PROCESSES (should be more 300)
show parameters NLS_LENGTH_SEMANTICS  (should be BYTE)
show parameters SHARED_POOL_SIZE (should be more 147456KB)
show parameters SGA_MAX_SIZE (should be more 147456KB)
show parameters DB_BLOCK_SIZE (is greater than or equal to 8KB)
show parameters OPEN_CURSORS (should be more 800)