This content has been marked as final. Show 21 replies
Thanks....but I am confused...
The link recommnened to remove the other OracleHome in the registry but....
I have two apps , one that needs 11g client and the other needs 10g client. Why can not I have both?
I tried also to set the system variable PATH to lead the Oracle10g home bin, but when I issue at command prompt set PATH ...I can see that the leading home is still 11g it seems my envi system set variable did not take
C:\Documents and Settings\ccbalon>set PATH
les\RSA SecurID Token Common;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\
I have two apps , one that needs 11g client and the other needs 10g client. Why can not I have both?You can keep both installations and also PATH can have both homes path included but when you want to use 10g home, make sure in the PATH value "C:\oracle\product\10.2.0.3\client_1\bin" comes first.
Path=C:\oracle\product\11.1.0\db_1\bin; C:\oracle\product\11.1.0\client_1\bin; C:\oracle\product\188.8.131.52\client_1\bin; C:\oracle\product\10.2.0.3\client_1\bin;It seems you have 11.1.0, 11.2.0 & 10.2.0.3 versions installed.
Yes I have lots of OracleHome :)
But I was able to set the %PATH to lead the 10g home/bin. And I can now tns ping and connect successfully to the database at command line.
But I can still see error when I ran the apps which is:
Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1What file in oracle network (tnsnames, sqlnet) controls this nls lang?
ORA-12705: Cannot access NLS data files or invalid environment specified
Edited by: KinsaKaUy? on 21-Nov-2012 03:27
ORA-12705: Cannot access NLS data files or invalid environment specifiedis this solution not working with you
Try to add following lines to %SQL_DEV_HOME%\sqldeveloper\bin\sqldeveloper.conf AddVMOption -Duser.language=en AddVMOption -Duser.country=US
this decision works Re: SqlDeveloper ORA-12705
Im confused huhuuh :(
I checked my officemate's setup which is working and the her path is still on 11g. She did not set it to leading 10g home. maybe this has the right nls lang settings. and the 10g home is just set on the start.bat of the apps.
So among the many OracleHomes I have , which one has the needed NLS_LANG settings? or the correct one? I forgot the original path.
Edited by: KinsaKaUy? on 21-Nov-2012 03:59