Re: TNSPING question

On Tue, Oct 11, 2016 at 12:03 PM, Storey, Robert (DCSO) < RStorey_at_dcso.nashville.org> 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

--
http://www.freelists.org/webpage/oracle-l