XA 8.0.5 hitting Oracle 7.3 database problem
Date: Wed, 29 Mar 2000 14:30:00 GMT
Message-ID: <8bt40m$tdi$1_at_nnrp1.deja.com>
I need to access an Oracle 7.3 database using the XA library of the Oracle 8.0.5 client. Oracle documentation explains how to configure the database to enable XA:
Make sure the DBA_PENDING_TRANSACTIONS view exists on the database.
For Oracle Server Release 7.3:
Make sure V$XATRANS$ exists.
This view should have been created during the XA library installation.
You can manually create the view if needed by running the SQL script
XAVIEW.SQL. This SQL script should be executed as the Oracle user SYS.
Grant the SELECT privilege to the V$XATRANS$ view for all Oracle Server
accounts which will be used by Oracle XA library applications.
See Also: Your Oracle operating system-specific documentation contains
the location of the XAVIEW.SQL script.
For Oracle Server Release 8.0:
Grant the select privilege to the DBA_PENDING_TRANSACTIONS view for all
Oracle Server user(s) specified in the xa_open string.
The problem is that the DBA_PENDING_TRANSACTIONS view does not exist on the 7.3 database and cannot be created using 8.0.5 script (gv$global_transaction table or view doesn't exist).
Obviously, this view is used by XA 8, since documentation says "make sure it exists and grant select on it to appropriate users". I don't know how to create that view on 7.3!
I experience this problem with Microsoft Transaction Server DTC that queries DBA_PENDING_TRANSACTIONS every minute after a transaction has failed and receives an error since DBA_PENDING_TRANSACTIONS does not exist.
Thank you in advance,
Pavel Raudin.
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Mar 29 2000 - 16:30:00 CEST