Or you can emulate tnsping by using netcat. It works on Windows, in cygwin.
On 11/08/2016 09:53 AM, Jared Still wrote:
On Tue, Oct 11, 2016 at 12:03 PM, Storey, Robert (DCSO) <RStorey@xxxxxxxxxxxxxxxxxx <mailto:RStorey@xxxxxxxxxxxxxxxxxx>> wrote:
I am testing a connection using tnpsing. Unfortunately, the
service name I am tnsping’ing is not in my tnsnames file. The cmd
windows tells me it is using the tnsnames adaptor at the location
of my tnsnames, but the service name is not in there.
Here's one method to find just what files are being used by tnsping.
Get the windows equivalent of strace: http://www.howzatt.demon.co.uk/NtTrace/
Following is an example usage with tnsping:
X:\zips\Windows_Utilities\Tracing\NtTrace\NtTrace-x64\NtTrace>nttrace tnsping js03 | find /i ".ora"
NtQueryAttributesFile( ObjectAttributes="\??\C:\Oracle\sqlnet.ora", Attributes=0x1ac8a0 [ARCHIVE] ) => 0
NtCreateFile( FileHandle=0x1ac5f8 [0x120], DesiredAccess=SYNCHRONIZE|GENERIC_READ|0x80, ObjectAttributes="\??\C:\Oracle\sqlnet.ora", IoStatusBlock=0x1ac608 [0/1], AllocationSize=null, FileAttributes=0
x80, ShareAccess=3, CreateDisposition=1, CreateOptions=0x60, EaBuffer=null, EaLength=0 ) => 0
NtQueryAttributesFile( ObjectAttributes="\??\C:\Oracle\sqlnet.ora", Attributes=0x1ac700 [ARCHIVE] ) => 0
NtCreateFile( FileHandle=0x1ac458 [0x120], DesiredAccess=SYNCHRONIZE|GENERIC_READ|0x80, ObjectAttributes="\??\C:\Oracle\sqlnet.ora", IoStatusBlock=0x1ac468 [0/1], AllocationSize=null, FileAttributes=0
x80, ShareAccess=3, CreateDisposition=1, CreateOptions=0x60, EaBuffer=null, EaLength=0 ) => 0
NtQueryAttributesFile( ObjectAttributes="\??\X:\zips\Windows_Utilities\Tracing\NtTrace\NtTrace-x64\NtTrace\tnsnames.ora", Attributes=0x1aba60 ) => 0xc0000034 [2 'The system cannot find the file specif
ied.']
NtQueryAttributesFile( ObjectAttributes="\??\C:\Oracle\tnsnames.ora", Attributes=0x1abb70 [ARCHIVE] ) => 0
NtQueryDirectoryFile( FileHandle=0x120, Event=0, ApcRoutine=null, ApcContext=null, IoStatusBlock=0x1ab1b8 [0/0x76], FileInformation=0x1ab200, Length=0x268, FileInformationClass=3 [FileBothDirectoryInf
ormation], ReturnSingleEntry=true, FileName="tnsnames.ora", RestartScan=false ) => 0
NtCreateFile( FileHandle=0x1ab528 [0x120], DesiredAccess=SYNCHRONIZE|GENERIC_READ|0x80, ObjectAttributes="\??\C:\Oracle\tnsnames.ora", IoStatusBlock=0x1ab538 [0/1], AllocationSize=null, FileAttributes
=0x80, ShareAccess=3, CreateDisposition=1, CreateOptions=0x60, EaBuffer=null, EaLength=0 ) => 0
C:\Oracle\sqlnet.ora
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Principal Consultant at Pythian
Pythian Blog http://www.pythian.com/blog/author/still/
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
