Hendry's "Oracle and SQL Server DBA Stuff"

Oracle and SQL Server Database Solutions for DBA's please visit http://hendrydba.com for the latest posts. Thanks

ORA-12705: Cannot access NLS data files or invalid environment specified

Posted by Hendry chinnapparaj on January 7, 2011

PROBLEM

————–

The following error occurred when trying to connect to sql*plus to run a script.

ORA-12705: Cannot access NLS data files or invalid environment specified

SQL*Plus: Release 10.2.0.4.0 – Production on Fri Jan 7 10:09:37 2011

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

ERROR:
ORA-12705: Cannot access NLS data files or invalid environment specified

SP2-0751: Unable to connect to Oracle.  Exiting SQL*Plus

Solution

————

check the NLS_LANG unix env setting

export NLS_LANG=”AMERICAN_AMERICA.US7ASCII”

In the above case, the “A” was missing – no more errors after adding the”A” for the AMERICAN.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: