5.6 Install the CdrRuntime.jar File

Install CdrRuntime.jar as described in the following steps:

1. On the Oracle LSH server, navigate to the $CDR_TOP/jar folder. It contains the CdrRuntime.zip file.
2. 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
3. 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
4. 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';
5. Connect to the database as APPS and run the statements returned by the able query.
6. 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.