ITPub博客

首页 > 数据库 > 数据库开发技术 > tnsping: NL-00605: national language initialization failed sqlplus Error 5

tnsping: NL-00605: national language initialization failed sqlplus Error 5

原创 数据库开发技术 作者:netbanker 时间:2009-01-06 07:15:11 0 删除 编辑

wbiadm@wbidevrk1p:[/home/wbiadm]# tnsping
NL-00605: national language initialization failed
NL-00605: national language initialization failed

wbiadm@wbidevrk1p:[/home/wbiadm]# tnsping
NL-00605: national language initialization failed
NL-00605: national language initialization failed

wbiadm@wbidevrk1p:[/home/wbiadm]# sqlplus
Error 5 initializing SQL*Plus
NLS initialization error

[@more@]

nutshell for 2hrs searching the relative information, making a lot of change on binary, env, etc.

Finally got the root cause from manual ( RTFM *_& )

Lightweight Instant Client

SQL*Plus Instant Client using the lightweight OCI package displays error messages in English only and supports only specific character sets. It is significantly smaller than SQL*Plus Instant Client using the Basic OCI package.

Valid values for NLS_LANG parameters with the lightweight Instant Client are:

  • language must always be American.

  • territory can be any valid territory supported by the Oracle Database.

  • charset is one of the following character sets:

    • US7ASCII

    • WE8DEC

    • UTF8

    • AL16UTF16

    • AL32UTF8

For example:

NLS_LANG=AMERICAN_AMERICA.UTF8

See the Oracle Database Globalization Support Guide, and NLS_LANG Environment Variable for more information about NLS settings.

Lightweight SQL*Plus Instant Client Error with Unsupported Character Set

Attempting to start SQL*Plus Instant Client with an unsupported character set will fail with the following error:

Error 5 initializing SQL*Plus
NLS initialization error

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/67/viewspace-1015732/,如需转载,请注明出处,否则将追究法律责任。

下一篇: On Dynamic Sampling
请登录后发表评论 登录
全部评论

注册时间:2008-06-12

  • 博文量
    20
  • 访问量
    90554