If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hybrid View

Oracle Client Connecting to Database without tnsnames.ora file

Hello

I ve installed oracle client in one of my desktop . i made entries in the tnsnames,.ora file for the connect string and the connection was thro and working perfectly. now i deleted the tnsnames.ora file from the machine and still iam able to connect to the database from the client machine with the same connect string but iam not able to connect using any othe connect string value.

how does a client connect to the server without referring to the tnsnames.ora file. is there any other file which it could refer to .pls clarify me on this.

you'll find that it'll use that before it goes to the 'correct' file in %ORACLE_HOME%/network/admin (windows....im not sure about unix) so even if you delete the original it use the local file just to screw with your head.