Skip to Main Content
Forums

Security Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Facing Error:Views\Synonyms required for XA transaction support are missing in this Database 12c.

AkashGuptaDec 21 2017 — edited Dec 21 2017

Hi Team,

We are facing Error: "Views\Synonyms required for XA transaction support are missing in this Database 12c" while installing RCU. We are using Oracle Database 12c, RCU version is 11.1.1.9.0.

Below is the error we are getting below 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.

Please let us know if anyone has already faced this error earlier.

Any help on this will be highly appreciable.

Thanks

Aksah

Comments

Srinath Menon-Oracle 
Refer Oracle Database Administrator's Guide to install XA transaction recovery views\synonyms
  using the script xaview.sql. Contact your DBA.

You will need to navigate to the following location and run the xaview.sql script :

With version 12, you will need to enable XA transactions via the xaview.sql script (in the PDB container if using a PDB database)

cd $ORACLE_HOME/javavm/install

sqlplus sys/password@SID as sysdba @initxa.sql    (if this exists in your version of the DB)

cd $ORACLE_HOME/rdbms/admin

sqlplus sys/password@SID as sysdba @xaview.sql

Note that the SID above is for the container, if your DB uses that.
1 person found this helpful
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 18 2018
Added on Dec 21 2017
#identity-management, #identity-manager
1 comment
709 views