Database character set

[Bohdan Zaiachkovskyi]

Hello,

Trying to upgrade Autosys 12.0.1 instance to 24.1.01. Installer shows an error:

[CAUAJM_E_112510] An error occurred while retrieving the instance name from
the "TST1UA77.WORLD" database.
java.sql.SQLException: ORA-17056: Non-supported character set (add
orai18n.jar in the classpath): CL8MSWIN1251

On DB I see:

NLS_NCHAR_CHARACTERSET
UTF8

NLS_CHARACTERSET
CL8MSWIN1251

Is there a workaround or I need to change DB character set to AL32UTF8?

[Gene Howard]

You should be able to just to update the local client with the jar file and run it again.
What is your back end Oracle type and version?
What is the oracle client type and version on the Autosys machine?
This might help provide more insight as to the issue.

If you are not sure where to get this file check with your DBA
file you should need orai18n.jar to match your client

------------------------------
Gene Howard
Principal Support Engineer
Broadcom
------------------------------

[Bohdan Zaiachkovskyi]

Oracle DB and client is 19.31

I downloaded orai18n.jar (ver 19.31) to /opt/oracle/product/19c/client_1/lib, granted ownership and permissions to it, but error is still the same.

[Gene Howard]

Please try the below option
If the below does not help you should open a support case to look into your environment.

The error java.sql.SQLException: ORA-17056 is a pure Java JDBC exception. This means the AutoSys upgrade installer is attempting to communicate with your database using an embedded Java JDBC Thin driver rather than your native Oracle OCI client.

Workarounds to Resolve the Error

Try these methods in order to get the installer to recognize the jar:

Method 1: Export the CLASSPATH in Your Active Shell (Easiest)

Before running the installer script, explicitly force the environment to include the jar in the global Java classpath. Run the following commands in the exact same terminal window where you launch the installer:

Bash
export CLASSPATH=/opt/oracle/product/19c/client_1/lib/orai18n.jar:$CLASSPATH

Once exported, kick off your AutoSys 24.1.01 installer (setup.sh or binary) immediately from that same session. Most Java installers wrapped via InstallAnywhere or Install4j will inherit the shell's active $CLASSPATH.

------------------------------
Gene Howard
Principal Support Engineer
Broadcom
------------------------------

[Bohdan Zaiachkovskyi]

Thank you, Gene, it works. Setting CLASSPATH solved the issue

[Chris Alley]

I think you sent this to me by mistake.

Get Outlook for iOS<https: aka.ms o0ukef>