Skip to main content

Search

Welcome to Tibero GTS!

Error Occurs During T-Up Migration: 'Unsupported Character Set KO16MSWIN949'

Document Type | Troubleshooting

Category | Migration

Applicable Product Versions | 6FS07, 7FS02

Document Number | TMITI010

 

Issue 

An issue occurred where only the PK (Primary Key) information is deleted when dropping a Table PK that is referenced by a Self FK (Foreign Key).
java.sql.SQLException: Unsupported character set (Add orai18n.jar to classpath): KO16MSWIN949

 

 

Cause

This error can occur when Oracle's character set is KO16MSWIN949.
This is because the Oracle JDBC driver does not support this character set by default, and to resolve this issue, the orai18n.jar file provided by Oracle is required.
 
 
 

Solutions

Copy the orai18n.jar file into the T-Up lib folder, then open the T-Up executable file with a text editor, modify the classpath as shown below, and restart to resolve the issue.
 
 

1. Change classpath

AS-IS

set jdbc_lib=.\lib\ifxjdbc.jar;.\lib\ifxjdbcx.jar;.\lib\jconn4.jar;.\lib\jconn3.jar;.\lib\ojdbc8.jar;.\lib\tibero6-jdbc.jar;.\lib\updb6-jdbc.jar;.\lib\inspur11-jdbc.jar;.\lib\sqljdbc4.jar;.\lib\sqljdbc.jar;.\lib\sqlite-jdbc-3.23.1.jar;.\lib\hl_agent.jar;.\lib\internal-jdbc-16.jar
 

TO-BE

set jdbc_lib=.\lib\ifxjdbc.jar;.\lib\ifxjdbcx.jar;.\lib\jconn4.jar;.\lib\jconn3.jar;.\lib\ojdbc8.jar;.\lib\tibero6-jdbc.jar;.\lib\updb6-jdbc.jar;.\lib\inspur11-jdbc.jar;.\lib\sqljdbc4.jar;.\lib\sqljdbc.jar;.\lib\sqlite-jdbc-3.23.1.jar;.\lib\hl_agent.jar;.\lib\internal-jdbc-16.jar;.\lib\orai18n.jar
 
 

2. Perform migration

AS-IS

SQL> SELECT * FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET';

PARAMETER       VALUE
------------------------------ --------------------
NLS_CHARACTERSET       KO16MSWIN949

 INFO[16:14:50,842][Thread-3]MigrationManager.migrateTable()(809) Querying source for table list
ERROR[16:14:51,605][Thread-3]MigrationManager.run()(347) java.sql.SQLException: Unsupported character set (Add orai18n.jar to classpath): KO16MSWIN949
        at oracle.sql.CharacterSetUnknown.failCharsetUnknown(CharacterSetFactoryThin.java:233)
        at oracle.sql.CharacterSetUnknown.convert(CharacterSetFactoryThin.java:194)
        at oracle.jdbc.driver.PhysicalConnection.throughDbCharset(PhysicalConnection.java:10365)
        at oracle.jdbc.driver.PhysicalConnection.enquoteIdentifier(PhysicalConnection.java:10442)
        at oracle.jdbc.driver.OracleStatement.enquoteIdentifier(OracleStatement.java:6452)
        at oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:3853)
        at oracle.jdbc.driver.InsensitiveScrollableResultSet.findColumn(InsensitiveScrollableResultSet.java:270)
        at oracle.jdbc.driver.GeneratedResultSet.getInt(GeneratedResultSet.java:556)
        at com.tmax.tibero.tup.migrator.dd.OracleDDExtractor.setTableColumn(OracleDDExtractor.java:1323)
        at com.tmax.tibero.tup.migrator.dd.OracleDDExtractor.getTableList(OracleDDExtractor.java:799)
        at com.tmax.tibero.tup.migrator.MigrationManager.migrateTable(MigrationManager.java:810)
        at com.tmax.tibero.tup.migrator.MigrationManager.migrateSchemaObject(MigrationManager.java:705)
        at com.tmax.tibero.tup.migrator.MigrationManager.run(MigrationManager.java:327)
        at java.lang.Thread.run(Thread.java:750)
 

TO-BE

SQL> SELECT * FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET';

PARAMETER       VALUE
------------------------------ --------------------
NLS_CHARACTERSET       KO16MSWIN949

 INFO[16:22:55,732][Thread-3]MigrationManager.alterCurrentSchema()(778) Alter schema to "sys"
 INFO[16:22:55,732][Thread-3]MigrationManager.createObjects()(1744) Objects to create:"sys"
 INFO[16:22:55,733][Thread-3]MigrationManager.printCompleteMsg()(1797) [(S) GENERATED] It took 1[ms] [Wed Jun 11 16:22:55 KST 2025]
 ...
 INFO[16:22:55,735][Thread-3]MigrationManager.printMigrateEnd()(545) Migration completed successfully: : Wed Jun 11 16:22:55 KST 2025
 
 
 
 
 
 

Related to