SAP Unable to obtain Oracle release after upgrade to 10.2.0.4

22 Views

Hello all,

We've just done an upgrade of Oracle from 9.2.0.4 to 10.2.0.4.

There were no indications of any problems but when I log onto SAP, I get a program dump.

I have tracked the problem down to be the fact that SAP is basically unable to retrieve the Oracle version. If I do a 'System -> Status', then the Oracle release is blank.

If I try to run, for eg, DB02 or ST04, then I get a DB_RELEASE_UNKNOWN error.

DB_GET_RELEASE is the function module being used, and this in turn calls 'DB_GET_REL' which is a system call. If I test DB_GET_RELEASE by itself, then it returns a blank string.

We have upgraded 2 other test systems which reside on the same server without experiencing this problem.

Does anyone have any idea what the problem may be? I suspect we may be missing a table or something that holds the Oracle release.

Does anyone know where SAP retrieves the Oracle release from?

TIA.

Regards....John