Another, not very simple, solution is ANTLR. You can use ANTLR to parse tnsnames.ora. On ANTLR Grammar List page you will find grammar which can parse tnsnames.ora, sqlnet.ora and listener.ora
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production
on 01-MAR-2009 02:02:33
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)
(HOST = myhostname)(PORT = 1521)) (CONNECT_DATA = (SID = mydb)))
OK (80 msec)
问题是您必须将 TNS 名称传递给 ping，这在您的场景中可能可行，也可能不可能。
I'm not sure if TNSPing would be more useful to you. It will output like:
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production
on 01-MAR-2009 02:02:33
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)
(HOST = myhostname)(PORT = 1521)) (CONNECT_DATA = (SID = mydb)))
OK (80 msec)
The problem is you must pass it the TNS name to ping, which may or may not be possible in your scenario.
发布评论
评论（2）
另一个不是很简单的解决方案是 ANTLR。您可以使用 ANTLR 来解析 tnsnames.ora。在ANTLR语法列表页面上您会找到可以解析
tnsnames.ora、<代码>sqlnet.ora和<代码>listener.oraAnother, not very simple, solution is ANTLR. You can use ANTLR to parse
tnsnames.ora. On ANTLR Grammar List page you will find grammar which can parsetnsnames.ora,sqlnet.oraandlistener.ora我不确定 TNSPing 是否对您更有用。它将输出如下：
问题是您必须将 TNS 名称传递给 ping，这在您的场景中可能可行，也可能不可能。
I'm not sure if TNSPing would be more useful to you. It will output like:
The problem is you must pass it the TNS name to ping, which may or may not be possible in your scenario.