Small fix for SQLcl Java problem with Oracle 12.1

Let’s say you want to quickly use some cool features of SQLcl inside the script running on the database server, but only Oracle below version 12.2 is available there (which is the first one being shipped with SQLcl). This means that you have to download it manually – not a big deal. Now, assume that you really need to connect AS SYSDBA without a password, so using OS authentication. Should not be a problem neither – you just set ORACLE_SID and ORACLE_HOME properly and you are good to go – unless you hit some Java errors…

Continue reading “Small fix for SQLcl Java problem with Oracle 12.1”

Design a site like this with WordPress.com
Get started