Operating System - HP-UX
1748000 Members
4835 Online
108757 Solutions
New Discussion юеВ

Re: 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 9
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.