XA error: XAER_PROTO : Routine was invoked in an inproper context Oracle 9.2

From: Shivaji Bhosle <yazarbaby_at_yahoo.com>
Date: 9 Feb 2003 09:10:34 -0800
Message-ID: <8a8edccc.0302090910.5c96f4f7@posting.google.com>

Hello all
Recently we upgraded out dvlp. environment to Oracle 9.2 Enterprise ed..
After the upgrade we started noticing this error message every once in a while.

XA error: XAER_PROTO : Routine was invoked in an inproper context start()

failed on resource 'XXXCP' null

The offending SQL stmt could be a SELECT or UPDATE. (have not tried DELETE yet.)

We are using WebLogic 6.1 SP4 , the driver name being used is

oracle.jdbc.xa.client.OracleXADataSource

If I execute the same request again a second later the operation works just fine. I have changed the startWeblogic.cmd to include C:\oracle\ora92\jdbc\lib\classes12.zip BEFORE other .zips and .jars . Besides that nothing of relevance has changed. The app. has been in production on 8.1.7 for a few months without any such XA errors. So I am pretty sure it was the 9i upgrade that caused the problem.

I looked up many newsgroups on bea and Oracle site but could not find an "Aha!"
message yet. Will be working with our dba re. initjvm.sql and utlrp.sql but I am not sure re-running these scripts will help.

A precise solution will be GREATLY appreciated but I will thank you for any pointers as well.

yazar Received on Sun Feb 09 2003 - 11:10:34 CST