Invalid DBWS classes After Upgrading Database From 10g to 11gR2 (Doc ID 1497322.1)

Last updated on FEBRUARY 13, 2024

Applies to:

Goal

After upgrading a database instance from 10.2 to 11.2, several web services callout (UTL_DBWS) related java classes are now invalid.

The following INVALID objects were noticed in testing:

HTTPClient/OracleSSL*
HTTPClient/OracleSSL$1
HTTPClient/OracleSSL$2
HTTPClient/OracleSSL$3
HTTPClient/OracleSSL$4

but other classes beyond these could be shown as invalid depending on the database environment.

In the original 10.2 instance, the callout jars were installed in the SYS schema.

What steps are necessary to restore the web services callout functionality?

a) Is it possible to "fix" the migrated database without reloading the JVM, and if so how?
b) What is the recommended approach as far as upgrading the database goes with regards to the web services callout functionality?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.