-
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.
help eachothers!!!
-
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
-
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.
help eachothers!!!
-
I suggest you search ora-12705 in metalink. There are lots of informations about this error.
-
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
-
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
-
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,
help eachothers!!!
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|