TNSNAMES / SQLNET General Question
ChaosADApr 4 2012 — edited Apr 5 2012Using 11.2.03 Oracle on 64bit Linux
Due to some problems I've been trying to troubleshoot, I've been trying to dive into the uses of TNSNAMES and SQLNET.
Are they required on the DB server itself for a general install? All my connections use the EZ Connection string style, so I thought TNSNAMES would not be needed. Though after removing it, I had to restart the DB and it would give LOCAL_LISTENER errors until I set TNSNAMES back again. Is there way to avoid using the TNSNAMES completely on the server?
I've tried looking around for information on if it is even needed on a server and if so the specifics of why. I usually stuff reguarding Oracle 8 and 9 and the few things I find using 11 are very very basic and don't really explain the why. They just throw a basic example and say replace this data.
Sorry if it seems pretty basic, I just keep trying to wrap my head around the basics of it. I want to simplify my configs and files and if it isn't needed I would like to know why and remove / edit it down.