Use of netcat should be cleared with Security , lest you get escorted off
the premises
sent from my mobile, so expert typos
On Nov 8, 2016 4:41 PM, "Mladen Gogala" <gogala.mladen@xxxxxxxxx> wrote:
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> 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
--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217
