[CAUAJM_E_112510] ORA-17056 Non-supported character set during AutoSys upgrade

Products

• Autosys Workload Automation

Issue/Introduction

The AutoSys installer (setup.sh) displays the following error:

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

This occurs even if the Oracle client is correctly installed and configured on the machine.

Environment

• AutoSys Workload Automation 24.1.01
• Oracle Database 19c
• Oracle Client 19c
• Database Character Set: CL8MSWIN1251

Cause

The AutoSys upgrade installer uses an embedded Java JDBC Thin driver to communicate with the database.
This driver does not include all character sets by default. When the database uses a character set such as CL8MSWIN1251,
the JDBC driver requires the orai18n.jar file to be present in the Java CLASSPATH to successfully negotiate the connection.

Resolution

To resolve this issue, manually include the orai18n.jar in the shell environment before launching the installer.

1. Locate the orai18n.jar file. It is typically found in the Oracle client lib directory: /opt/oracle/product/19c/client_1/lib/orai18n.jar

   Note: If the file is missing, contact your DBA to obtain the version matching your Oracle client.

2. In the same terminal session where the installer will be run, export the CLASSPATH variable:

⚠️ Review this command with your administrator before running it.

bash

 

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

3. Launch the AutoSys installer immediately from that same session:

bash

 

./setup.sh

Additional Information

For more information on configuring Oracle environments, see Contact Support.