From: XKEAAGIPVIEZ@spammotel.com   
      
   On Fri, 14 May 2004 10:53:25 -0700, in comp.databases.oracle, Ellen K.   
   <72322.enno.esspeeayem.1016@compuserve.com> scribbled:   
      
   >Thanks for all the info.    :)   
      
   No problem.  I know how frustrating it is to figure out why you're   
   getting a TNS error!  And me with several TNSNAMES files for several   
   processes running on several computers/servers...   
      
   >Somewhere I have a copy of the Oracle documentation on CD (left over   
   >from my previous job), but anyway the Oracle DBA promised me a new   
   >one...  Really this problem is his responsibility but I'm not one to   
   >let grass grow under my feet so I've been trying to find out whatever   
   >I can that might help.   He did make some modifications to the   
   >tnsnames file, which is how we got from the original error to this   
   >one.   
      
   I seriously recommend using SQL*Net to configure your TNSNAMES, or   
   whatever the name of your TNSNAMES configuring tool is (that's the   
   name of what I have).  Whenever I've gone in and tried to do anything   
   with TNSNAMES freehand I tend to get into more trouble, unless I'm   
   doing something innocuous (for me, anyway) like changing the IP   
   address of the connection.  I got into trouble once because I was   
   using computer names instead of IP addresses, and when we move to a   
   new location that was fine, but then the helpdesk people went around   
   changing everyone's machine names to reflect the location.  Boom.  No   
   connection to Oracle.  So, now it's all IP based, and I've had to yell   
   a few times in the past over someone somewhere changing IPs without   
   telling anyone, but that's "not done" anymore.  ;-)   
      
   --   
   Teresa Redmond   
   Programmer/Analyst III   
   Anteon Corporation   
   tredmond at anteon dot com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)