Cannot find TNSNames.ora

egnew · Post by **egnew** » Sat 17 Mar 2007 01:48

I am evaluating OraDeveloper Studio 2.0.45. When I attempt to create a new connection I have problems. Two choices are available in Home:
"Default (Instant Client)" and "Instant Client". With "Default" selected I get the message "Can not find TNSNames.ora file." when I click on server. If I change to "Instant Client", I get the message "Object reference not set to an instance of an object.". If I check "Direct", I am able to successfully connect to the database however I am not able to do imports or exports which seem to require a "non-direct" connection. Direct Oracle Access connects to the databases through Instant Client fine. What is the problem?

Thanks.

Duke · Post by **Duke** » Mon 19 Mar 2007 07:31

We are investigating the problem right now.

Duke · Post by **Duke** » Mon 19 Mar 2007 13:47

1. "Can not find TNSNames.ora file."
Create system variable TNS_ADMIN containing path to tnsnames.ora file. Reboot your system and connect.
2. "Object reference not set to an instance of an object."
We have found the problem and we'll resolve it in the next build.
3. >exports which seem to require a "non-direct" connection
Export feature requires full Oracle client installation because it uses Exp and Imp utilities.