Home » RDBMS Server » Server Administration » How to set up Oracle XA?
How to set up Oracle XA? [message #217796] Mon, 05 February 2007 10:05
orausern
Messages: 826
Registered: December 2005
Senior Member
Hello,

I have installed oracle 9.2.0.7 database on windows. We want to have XA support and I have granted the select permission on dba_pending_transactions to all schemas...still we keep getting XA related errors...jvm is installed properly ..what could be the problem? how to go about enabling xa support in oracle? the error I get is:
Quote:

XAException occurred. Error code is: XAER_INVAL (-5). Exception is: <null>

[2/5/07 18:30:48:750 IST] 00000030 XATransaction E J2CA0027E: An exception occurred while invoking start on an XA Resource Adapter from dataSource jdbc/OracleDS, within transaction ID



With thanks,
Nirav
Previous Topic: enterprise manager console
Next Topic: Datafile Size
Goto Forum:
  


Current Time: Fri Sep 20 04:36:33 CDT 2024