connecting to a remote oracle db by toad [message #67741] |
Tue, 15 February 2005 04:01 |
Azer
Messages: 1 Registered: February 2005
|
Junior Member |
|
|
hi,
for some days i am trying to connect a remote oracle db with toad. but i cannot connect to the db still. at first in toad's connection(toad 8 suite) window, there are two links which are SQLNET Editor and TNSNames Editor. and beside these links there are two red X sign. when i click to SQLNET Editor coming, then i close it. and when i click to TNSNames Editor link, a message box opens. its content is "tnsnames.ora does not exist for OraHome81". OraHome81 is a name of ORACLE_HOME which was given by Oracle perhaps. And it points to the ORACLE_HOME(d:OracleOra81) environment variable. and also i copied tnsnames.ora and sqlnet.ora to this path.
do you think that my problem is this? i mean is my problem about that toad cannot find tnsnames.ora. where must i put these files in Oracle folder for toad to find them?
i'll be glad if you can help me. i deal with these work for 2 or 3 day and i still solve.
thanks.
|
|
|
|