文档解释
ORA-12737: Instant Client Light: unsupported server character set string
Cause: The character set specified is not allowed for this operation or is invalid. Instant Client Light has only minimal character sets.
Action: Do not use Instant Client Light for this character set
ORA-12737错误是显示Oracle客户端软件——Instant Client Light不支持伺服器所设定的字符集。
此错误一般在当使用Instant Client Light访问Oracle数据库时无法连接到数据库时出现。
官方解释
ORA-12737: Instant Client Light: unsupported server character set string
Cause: The server character set string was not supported in the instant client light configuration.
Action: Verify that the NLS_LANG (or equivalent) parameter is set correctly in the environment.
常见案例
当用Instant Client Light连接Oracle数据库出现此错误时,首先查看Oracle环境变量NLS_LANG是否设置正确,如果没有设置正确,可以使用安装Instant Client Light时设置的字符集进行设置。
正常处理方法及步骤
1.检查Oracle环境变量NLS_LANG是否设置正确。
2.确保Instant Client Light安装时所设置的字符集正确。
3.根据Oracle官方文档里面对Instant Client Light支持的字符集进行配置,可以详见官方文档:https://docs.oracle.com/en/database/oracle/oracle-database/19/odlct/introduction-instant-client-light.html#ODLCT-GUID-4566CEEF-42A8-46C9-AFEA-89A2F1A51275
4.如果以上步骤均已经尝试,却仍然无法解决此问题,请及时联系Oracle技术支持人员,了解更多细节。