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

netbanker發表於2009-01-06
AISQLError

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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章