Oracle Client Connecting to Database without tnsnames.ora file
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 havent a tnsnames file in you current working dir have you?
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.