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

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/67/viewspace-1015732/