Install the CdrRuntime.jar File

On the Oracle LSH server, navigate to the $CDR_TOP/jar folder. It contains the CdrRuntime.zip file.

Copy the CdrRuntime.zip file to the Oracle Database server in any temporary location. Then enter this command to unzip the file and extract CdrRuntime.jar:

unzip CdrRuntime.zip

Run these commands to load the java files to the database. First this command:

dropjava -force -thin -user
                            apps/apps@"(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<DB
                            hostname>)(PORT=<DB port
                            number>))(CONNECT_DATA=(SERVICE_NAME=<DB service
                        name>)))" CdrRuntime.jar

Then this command:

loadjava -force -thin -user
                            apps/apps@"(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<DB host
                            name>)(PORT=<DB port
                            number>))(CONNECT_DATA=(SERVICE_NAME=<DB service
                        name>)))" CdrRuntime.jar

Run this query to return a set of alter java commands that should be run to compile invalid classes:

SELECT

'alter java class "'

|| object_name

|| '" compile;'

FROM

dba_objects

WHERE

object_type = 'JAVA CLASS'

and object_name LIKE '%cdr%'

AND status = 'INVALID';

Connect to the database as APPS and run the statements returned by the able query.

Rerun the query and confirm that it does not return any rows.

Note:

If the query returns rows, execute the statements returned again. Repeat this process until the SQL does not return any rows.