| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Procedural Gateway for APPC
Is there anyone with experience using Oracle Procedural Gateway for APPC. We
have been using vers. 4.0.1.1.0 to connect Oracle 8.0.5 (On Sun Solaris) to
our CICS system (VSAM database) for the past 8 months with no real problems.
We are now implementing Commit-Confirm, which is similar to two-phase commit, but uses synclevel 1 instead of 2. Since the only version of this gateway that supports two-phase commit is for RS6000, and our gateway runs on NT, we need to use Commit-Confirm.
So far, I can run my code to initiate the conversation, call the CICS transaction, and view the values returned from the CICS transaction in Oracle. When I get to a COMMIT or ROLLBACK, the RECO process in CICS (an Oracle supplied process that clears the Oracle Commit-Confirm Transaction Log in CICS) fails due to an authentication error (RC=6 in the gateway log). The same username and password that runs the other CICS transactions is used. However (here's the tricky part), the user for this RECO process is defined in the init.ora for the gateway rather than in the database link. Seems logical that something is wrong with the setting of the username and password in the init.ora. Here is where I sit... Confused and looking at logs. The password is always sent encrypted so I can't actually see what is passed. It seems that a different one is passed for the RECO process despite being set the same. Aaarrggghhh!
I haven't got much response from Oracle Support (it's with level 2 support now). I've the TAR opened for a week with no luck.
If anyone has any ideas, feel free to email or call me at the number below.
Thanks,
Paul
g GE Financial Assurance
 |
 |