TOAD does not display the registry values such as NLS_LANG, TNS_ADMIN when using Instant Client to connect.
WORKAROUND:
For a peace of mind, tweak the instant client & registry structure to mimic the Oracle client's structure & registry structure correspondingly.
TOAD picks up the NLS_LANG value from the registry. However TOAD does not pick up the TNS_ADMIN value from the registry.
TNS_ADMIN value has to be set in the system environment variables.
Refer to the attachment for more details.
STATUS:
Waiting for fix in the future release of TOAD for Oracle.
1. Oracle's suggestion that the values such as NLS_LANG, TNS_ADMIN can be entered into windows registry 2. TOAD is not reporting the NLS_LANG value which it had picked up correctly. TOAD does not actually rely on that NLS_LANG value. Toad uses OCI to figure out what NLS_LANG to use based on environment variables and registry data.
Â
