Friday, June 2, 2017

XATRANS views are not Installed. OIM RCU



  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.

Cd $ORACLE_HOME/javavm/install
Sqlplus ‘/as sysdba’

SQL> sta initxa.sql

PL/SQL procedure successfully completed.


JVMRMACTION
--------------------------------
FULL_REMOVAL


PL/SQL procedure successfully completed.


Package created.


Package body created.


Synonym created.


Grant succeeded.

SQL>exit
Cd $ORACLE_HOME/rdbms/admin/
Sqlplus ‘/as sysdba’

SQL> sta xaview.sql

SQL> sta 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>

No comments: