|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: McTnsping: a tnsping-like program for Windows [message #681468 is a reply to message #681437] |
Mon, 20 July 2020 12:25 |
|
Michel Cadot
Messages: 68645 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
A new version is available to download (see link in the first post of this topic).
This version adds a new option on command line: -rc
This option tells what would be the return code of McTnsping in cases there are several addresses in a tnsnames.ora entry and some addresses work and others not (see first post for details).
[Updated on: Mon, 20 July 2020 12:27] Report message to a moderator
|
|
|
|
|
Re: McTnsping: a tnsping-like program for Windows [message #683551 is a reply to message #683544] |
Fri, 29 January 2021 11:59 |
|
Michel Cadot
Messages: 68645 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
The problem came from an hyphen in the service name.
It appears that Oracle does not follow its rules defined in Database Net Services Reference, section 3.4 Permitted Listener and Net Service Name Character Set:
Quote:Listener names and net service names are limited to the following character set:
[a...z] [A...Z] [0...9] _
The first character in the listener name or net service name must be an alphanumeric character.
but more the ones defined in section 3.3 Network Character Set for Keywords.
So McTnsping now accepts service names starting with an alphanumeric character followed by zero or more characters in the following set (and you can actually connect with service names following this rule):
[a...z] [A...Z] [0...9] < > / \ : - _ $ + * & ! % ? @ . ;
(Some of them are meaningful shell characters, good luck for those who want to use them. )
[Updated on: Fri, 29 January 2021 14:50] Report message to a moderator
|
|
|
|
|
|
Re: Negative Values using McTnsping [message #685027 is a reply to message #685026] |
Tue, 12 October 2021 03:58 |
|
Michel Cadot
Messages: 68645 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Your post has been appended to McTnsping topic, please use this thread for all your remarks or reports to McTnsping.
It seems the internal time counter is fooled when the interval is too short.
This is now fixed, you will find the new version in tnsping wiki page.
[Updated on: Tue, 12 October 2021 07:53] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
Re: McTnsping: a tnsping-like program for Windows [message #687887 is a reply to message #687856] |
Tue, 11 July 2023 03:36 |
|
Michel Cadot
Messages: 68645 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
McTnsping now supports IFILE in sqlnet.ora and tnsnames.ora.
Note that IFILE in these files is not documented and only partially supported (many bugs) by Oracle which recommends to not use it, thus the behavior of McTnsping may be different than Oracle's.
McTnsping (unlike Oracle) displays the files referenced in IFILE statements, indented.
Here's an example (tnsnames.ora from TNS_ADMIN calls foo1.ora which calls foo2 and foo3 (inexistent), and foo4 (inexistent) and in the end the standard tnsnames.ora; foo2 calls foo1 which creates a loop in IFILE calls):
C:\> McTnsping mikl
McTnsping Utility by Michel Cadot: Version 2023.07.11 on 11-JUIL.-2023 10:19:10
Copyright (c) Michel Cadot, 2016-2023. All rights reserved.
Using ping version 11
TNS_ADMIN set to e:\
ORACLE_HOME set to E:\oracle\ora11204
Used parameter files:
e:\sqlnet.ora
Used TNSNAMES adapter to resolve the alias:
e:\tnsnames.ora
e:\foo1.ora
e:\foo2.ora
** e:\foo1.ora: loop in IFILE, file skipped
* foo3.ora: file not found
* foo4.ora: file not found
E:\Oracle\Ora11204\NETWORK\ADMIN\tnsnames.ora
Found entry:
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.0.0.3)
(PORT=1538)))
(CONNECT_DATA=
(SERVICE_NAME=mikl.arda)
(SERVER=DEDICATED)))
Attempting to contact 10.0.0.3:1538
OK (142 msec)
From my tests, Oracle does the same thing (about not found files and loops) but silently.
Note: if "-dir" option is not given, McTnsping now displays TNS_ADMIN and ORACLE_HOME values (if set).
|
|
|