Re: TNSPING question
- From: Jared Still <jkstill@xxxxxxxxx>
- To: "RStorey@xxxxxxxxxxxxxxxxxx" <RStorey@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 8 Nov 2016 06:53:45 -0800
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
Other related posts:
