Re: ORA-12224 TNS:no listener

On Fri, 14 May 2004 10:53:25 -0700, in comp.databases.oracle, Ellen K. <72322.enno.esspeeayem.1016_at_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