Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-12705: invalid or unknown NLS parameter value specified

SOLVED
Go to solution
Victor Geere
Frequent Advisor

ORA-12705: invalid or unknown NLS parameter value specified

I get the error :

ORA-12705: invalid or unknown NLS parameter value specified

when I try to
"SQL>connect sys/passwd as sysdba"

The oracle .profile includes the following lines:
#-------------------------------------
NLS_LANG=AMERICAN-AMERICA.WE8ISO8859P1; export NLS_LANG
NLS_LANGUAGE=$NLS_LANG; export NLS_LANGUAGE
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS33
#-------------------------------------

Oracle 9i on HP-UX 11


What do I do here?
I thought that I was because I had thought.
9 REPLIES
T G Manikandan
Honored Contributor

Re: ORA-12705: invalid or unknown NLS parameter value specified

Leave your .profile settings
explicitly set your NLS_LANG value.

Else comment the all the NLS variables you have mentioned in your .profile file and then explicitly set only the NLS_LANG variable.
The problem may occur whent this variable is not set incorrectly.

Thanks
Victor Geere
Frequent Advisor

Re: ORA-12705: invalid or unknown NLS parameter value specified

...still same problem...
I thought that I was because I had thought.
T G Manikandan
Honored Contributor

Re: ORA-12705: invalid or unknown NLS parameter value specified

change your
NLS_LANG=AMERICAN-AMERICA.us7ascii
export NLS_LANG

Now?!

THanks
T G Manikandan
Honored Contributor

Re: ORA-12705: invalid or unknown NLS parameter value specified

change your
NLS_LANG=AMERICAN-AMERICA.us7ascii
export NLS_LANG


ALso do a echo $NLS_LANG to check it up
Now?!

THanks
Victor Geere
Frequent Advisor

Re: ORA-12705: invalid or unknown NLS parameter value specified

The echo $NLS_LANG returned

AMERICAN-AMERICA.us7ascii

after I set it.

I did notice that I made a spelling mistake 'AMERICAL' prior to the installation that I fixed after the installation.
echo confirmed this.

Would this have changed anything?

Also I cannot find PHCO_23092 superceded by PHCO_23963. Would that have had an effect?
I thought that I was because I had thought.
Volker Borowski
Honored Contributor
Solution

Re: ORA-12705: invalid or unknown NLS parameter value specified

Hi,
try
AMERICANAMERICA
not
AMERICANAMERICA

Hth
Volker
T G Manikandan
Honored Contributor

Re: ORA-12705: invalid or unknown NLS parameter value specified

The client communicates the information defined by NLS_LANG to the server when it connects to the database server.
It just sets the locale and territory settings.
The ora-12705 error it just duw to the wrong setting for this variable or a
mismatch of character-set.

Thanks
T G Manikandan
Honored Contributor

Re: ORA-12705: invalid or unknown NLS parameter value specified

He is right
IT is underscore and not hyphen

Victor Geere
Frequent Advisor

Re: ORA-12705: invalid or unknown NLS parameter value specified

Thanks Volker.
Problem solved, mission accomplished.
1000000000000000 points to you.

TG thanks for your helpfullness.
I thought that I was because I had thought.