Re: Debugging an Oracle connection

Marian Aldenhövel wrote:
...
>
> > niqname: Inserting CID.
> > niotns: entry
> > niotns: niotns: setting up interrupt handler...
> > niotns: Not trying to enable dead connection detection.
> > niotns: Calling address: (
> >
> DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dodo-mm)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=CMS)(CID=(PROGRAM=D:\prg\Delphi5\Delphi5\Bin\delphi32.exe)(HOST=DODO-MM)(USER=marian))))
...
>
> The non-working sample stops after "Inserting CID".

I think it simply means can't find the Oracle TNS entry. Not very informative. In fact, solving ORA-12154 is very easy in most cases and rarely needs SQL*Net tracing. On Windows, just launch Filemon (from sysinternals.com) and filter on your app name or "tns" or "ldap" (if you use LDAP). Run your application and check the Filemon output. In most cases, the application tries to find the file(s) in a directory you didn't expect.

Yong Huang Received on Mon Oct 31 2005 - 12:53:30 CST