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