Wednesday, February 3, 2016

Error: XATRANS Views are not installed on this Database

Running RCU 11.1.2.2 for installing OIM schemas in an Oracle database fails with:

Error:
RCU-6092:Component Selection validation failed. Please refer to log at /apps/demo/binaries/tmp/rcu.1921916505.tmp/rcu.log for details. 
RCU-6083:Failed - Check prerequisites requirement for selected component:OIM 
Please refer to RCU log at /apps/demo/binaries/tmp/rcu.1921916505.tmp/rcu.log for details.
Error:  XATRANS Views are not installed on this Database. This is required by the OIM Schema Action: Install view XAVIEWS as SYS user on this Database.
Refer to the Oracle Database Release Documentation for installation details.  

Starting 11gR2, Oracle Identity manager, XATRANS and XAVIEWS are required in the database. 

Fix:
As sys user, run the following two files to install the required views:

sqlplus / as sysdba @$ORACLE_HOME/javavm/install/initxa.sql

SQL*Plus: Release 11.2.0.4.0 Production on Wed Feb 3 11:11:31 2016
Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

PL/SQL procedure successfully completed.

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

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


sqlplus / as sysdba @$ORACLE_HOME/rdbms/admin/xaview.sql

SQL*Plus: Release 11.2.0.4.0 Production on Wed Feb 3 11:11:51 2016
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

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> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options






No comments:

Post a Comment