IBM Mainframe Forum

[raghav08]

Hello,

In our system an Oracale DB (UNIX) connected to Mainframe DB2 thru ODBC called Oracle Gateway. We can find the following In mainframe system log

USER=ORACLE1 CONNECTION-ID=DB2CALL CORRELATION-ID=ORPRDSGW
JOBNAME=ORPRDSGW ASID=0116 TCB=00898988.

Please let me know what's USER=ORACLE1 in the above statement.

ORACLE1 id is no where defined in Mainframe or Oracle DB, from where ORACLE1 coming in to picture.

Thanks.

[BillyBoyo]

Is there really no message number? Have you tried the Oracle Gateway documentation? Or the vendor? You mainframe security system must be aware of this, have you tried those in your support responsible for security?

[raghav08]

Hi,

DB2 DBA & RACF admin said that ORACLE1 id not defined in Mainframe, at the same time Oracle DBA said the same.

Mainframe is host for Oracle Gateway, the uid/password defined in Oracle DB to connect mainframe is not the id ORACLE1

This issue started when Oracle Gateway got upgrade to higher version in Mainframe.

[BillyBoyo]

So talk to the vendor's support. Or get any/all of the above to do it, as they are certainly interested in the answer and may be able to handle the more technical nature of what they are told than you can, as it is their job to do so.