Re: Debugging an Oracle connection

Hi,

> By that time the error-message is on the screen and I have stopped > the monitoring.

The working version goes on to load oran9.dll and orantcp9.dll. A lot of windows-stuff. Then orank59.dll, orangss9.dll and more oracle-DLLs. I assume oran* to constitute the networking layer. So all that tells me is that the name has been resolved correctly and it has been decided to connect using TCP/IP (which is correct).

So in both cases tnsnames.ora is found, opened and read. In one case the resolution of the name works and in the other fails. My tnsnames.ora is 814 bytes long. Filemon says:

Non-Working:
> QUERY INFORMATION O:\oracle\ora92\network\admin\tnsnames.ora SUCCESS
Attributes: A
> DIRECTORY O:\oracle\ora92\network\admin\ SUCCESS
FileBothDirectoryInformation: tnsnames.ora
> OPEN O:\oracle\ora92\network\admin\tnsnames.ora SUCCESS Options: Open
Access: All
> READ O:\oracle\ora92\network\admin\tnsnames.ora SUCCESS Offset: 0
Length: 4096
> READ O:\oracle\ora92\network\admin\tnsnames.ora SUCCESS Offset: 0
Length: 4096
> READ O:\oracle\ora92\network\admin\tnsnames.ora END OF FILE Offset: 812
Length: 4096
> CLOSE O:\oracle\ora92\network\admin\tnsnames.ora SUCCESS

Working:
> QUERY INFORMATION O:\oracle\ora92\network\admin\tnsnames.ora SUCCESS
Attributes: A
> DIRECTORY O:\oracle\ora92\network\admin\ SUCCESS
FileBothDirectoryInformation: tnsnames.ora
> OPEN O:\oracle\ora92\network\admin\tnsnames.ora SUCCESS Options: Open
Access: All
> READ O:\oracle\ora92\network\admin\tnsnames.ora SUCCESS Offset: 0
Length: 4096
> READ O:\oracle\ora92\network\admin\tnsnames.ora END OF FILE Offset: 812
Length: 4096
> CLOSE O:\oracle\ora92\network\admin\tnsnames.ora SUCCESS

Identical. I think tnsnames.ora is out of it. What can I check now?

Ciao, MM Received on Wed Nov 02 2005 - 02:22:15 CST