if I tnsping it :
ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified
On the other hand, I installed an 11g client on another folder and I copied both the tnsnames.ora and sqlnet.ora
C:\SPL\CCB210_BGAISDEV>tnsping PROD1 TNS Ping Utility for 32-bit Windows: Version 188.8.131.52.0 - Production on 21-NOV-2 012 18:18:55 Copyright (c) 1997, 2007, Oracle. All rights reserved. Used parameter files: C:\oracle\product\10.2.0.3\client_1\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = VM003.PH.COM)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = PROD1))) TNS-12557: TNS:protocol adapter not loadable
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\184.108.40.206\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.
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
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