service name creation error

[amudha]

dear friends,
i have installed oracle personal edition(server) in one machine. and i installed client in another machine. when i try to create a service name from my client machine to server machine i am getting this error.
ORA-12705: invalid or unknown NLS parameter value specified.

please do help me out.

[aarroyob]

Hi amudha,

The problem is the variable NLS_LANG on your cliente. Probably you have not defined this variable or if it is defined is not equal to the server's NLS_LANG variable.

Try this:

1. In the command line on your client put:
set NLS_LANG=equal server

2. Edit your regedit --> HKEY_LOCAL_MACHINE --> Software --Oracle --> Look for the variable NLS_LANG and modify it if exists or define it if not.

If you do the second option, you will not need to put everytime the variable at command line to start your database.

Hope this helps

Angel

[amudha]

thanks angel,
both in client as well as my server machine has got nls_lang="na". i tried both the ways but still i am getting the same error.
help me.
thanks,
ammu.

[xiaomao]

I suggest you search ora-12705 in metalink. There are lots of informations about this error.

[aarroyob]

Hi,

Try this:

Execute this sql:

select nls_languaje,nls_territory,nls_characterset
from v_$nls_parameters;

On your cliente at command line put:

For example in my case:

set NLS_LANG=SPANISH_SPAIN.WE8ISO8859P1

Hope that helps

Angel

[aarroyob]

Originally posted by amudha
thanks angel,
both in client as well as my server machine has got nls_lang="na". i tried both the ways but still i am getting the same error.
help me.
thanks,
ammu.

Look for the variable in HKEY_LOCAL_MACHINE --> Software --Oracle --> Home0 or something like that and do as I said you.
I think you were looking for directly in Oracle in the regedit. No?

Regards

Angel

[amudha]

thanks angel,
yes as u said i was trying regedit-HKEY_LOCAL_MACHINE --> Software --Oracle only but now i tryed HKEY_LOCAL_MACHINE --> Software --Oracle --> Home0
my nls_lang=AMERICAN_AMERICA.WE8ISO8859P1
I HAVE SET IT USING BOTH REGEDIT AS WELL AS AT COMMAND PROMPT.
then too i am getting the OLD same error

HELP ME,

[aarroyob]

Hi Amudha,

You didn't say which database version and client are you using. Try this:

For Oracle 7.3:

set ORA_NLS32 = $ORACLE_HOME/ocommon/nls/admin/data

For Oracle 8.0.5 and newer:

set ORA_NLS33 = $ORACLE_HOME/ocommon/nls/admin/data

Hope that helps

Angel