Hello everybody,
May be is't new problem but I've tried all solutions proposed and no one have been the wright to resolve my problem.
I'm connecting from a client PC Windows 10 to a remote Windows 10 PC. In the client, I've installed Oracle 11 instant client et and I've configured it to connect to Oracle 11 Database on the remote PC. But, I've always ORA-25401 error : could not find TNS.
This my configurations :
Server configuration :
listner.ora :
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app1\Mouadh\product\11.2.0\dbhome_2)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app1\Mouadh\product\11.2.0\dbhome_2\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
)
)
sqlnet.ora :
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
Client configuration :
tnsnames.ora :
# tnsnames.ora Network Configuration File: C:\app\Administrateur\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
THERIA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.2.38)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = THERIAQUE)
)
)
HOME_PATH and TNS_NAMES where added to environement variables.
Can anyone tell me where I'm wrong ?