Quote:
Originally Posted by julietmachiwa
I have an existing database 8i . I just installed Developer 2000 for Windows NT
I am failing to connect to the database.
How should I configure it?
I tried using SQL Net Easy Configuration and Also changed tnsnames.ora
but I am getting error "invalid or unknown NLS parameter value specified" when connecting to SQL PLUS 3.3 or Forms
Please help
It's likely a missing NLS-LANG setting in your Windows PC client registry. The NLS_LANG variable is in the Home0 directory in the Windows registry is not the only NLS_LANG, and you need to locate the Oracle directory in the registry and find NLS_LANG. This variable may be set to "NA", and a change to AMERICAN_AMERICA.WE8ISO8859P15 may fix your connectivity issue.
Cause: There are two possible causes: Either an attempt was made to issue an ALTER SESSION statement with an invalid NLS parameter or value; or the NLS_LANG environment variable contains an invalid language, territory, or character set.
Action: Check the syntax of the ALTER SESSION statement and the NLS parameter, correct the syntax and retry the statement, or specify correct values in the NLS_LANG environment variable.
Follow the below steps:
1. Go to regedit
2. Go to path /HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME0
3. Change the variable NLS_LANG as mentioned above (either to NA or AMERICAN_AMERICA.WE8ISO8859P15)
This should help!!
