How to fix the Oracle error ORA-12736: Instant Client Light: unsupported server national character set string?

In this post, you’ll learn more about the Oracle ErrorORA-12736: Instant Client Light: unsupported server national character set string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-12736: Instant Client Light: unsupported server national character set string

Reason for the Error ORA-12736: Instant Client Light: unsupported server national character set string

Only UTF8 and AL16UTF16 are allowed to be used as the national character set. Instant Client Light has only minimal character sets.

How to fix the Error ORA-12736: Instant Client Light: unsupported server national character set string ?

You can fix this error in Oracle by following the below steps

Do not use Instant Client Light for this character set