loadjava isn't in Oracle Instant Client 19c - what options do I have?

Question

We have a very old application with a complex installation process that relies on Oracle's loadjava client application. loadjava was included with Oracle's client up until 12c but now that we are upgrading to 19c I don't see it included in any of the Oracle clients here https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html

I am aware that it is still available on the server, but given the nature of our application that is of little use to me without significant pain.

Am I missing something? What are my options to get loadjava running from my Oracle client? I see there is a a DBMS_JAVA package available https://docs.oracle.com/en/database/oracle/oracle-database/21/jjdev/DBMS-JAVA-package.html - would that help?

Here is an example of how our application currently uses loadjava. This is called from an OS exec call from our application during installation. We use it just to load a handful of SQLj files.

loadjava -verbose -user USER/PASS@//localhost:1521/ORCLPDB1 /java/utils-oracle.sqlj

Answer 1

You can use:

• CREATE [AND COMPILE] JAVA SOURCE
  

  To compile the java directly from source code in SQL.
• The database package and procedure

  DBMS_JAVA.LOADJAVA
  

  To use loadjava from within the database.
• Transfer the Java classes and packages to the server and use the loadjava utility on the server.
• Download the full Oracle database client (as mentioned by kfinity)

Answer 2

As far as I know, the Oracle Java VM (Aurora - which includes the loadjava script and Java class) is not included in the Oracle Instant Client. You need the full Oracle Database Client, which you can download from the Oracle Software Delivery Cloud. It requires you to create an Oracle login if you don't already have one.

On the search page, select "Release" and then type "Oracle Database Client". It's a significantly larger download - the full client is 1.3 GB for Oracle Database 12.2, vs the instant client at 68 MB.