ITPub博客

首页 > Linux操作系统 > Linux操作系统 > SQLNET Trace Route from Client to Server[akadia]

SQLNET Trace Route from Client to Server[akadia]

原创 Linux操作系统 作者:jlandzpa 时间:2019-06-25 13:09:05 0 删除 编辑

The Trace Route Utility (TRCROUTE) enables administrators to discover what path or route a connection is taking from a client to a server. If TRCROUTE encounters a problem, it returns an error stack to the client instead of a single error. These additional error messages make troubleshooting easier.

TRCROUTE is different from TNSPING in that it travels as a special type of connect packet, and is routed as such. As it travels toward its destination, the TRCROUTE connect packet collects the TNS addresses of every node it travels through. If an error occurs, TRCROUTE collects error information that shows where the error occurred. The Trace Route Utility displays the information collected on the client screen. You can redirect the TRCROUTE output to a file, and print it if you wish.

Requirements

Trace Route works only over Net8 and SQL*Net version 2.3 and later. Every node along the route from client to server must use SQL*Net version 2.3 or later. If a pre-2.3 node is on the path, the following error is displayed:

TNS-03603: Encountered a node with pre-2.3 version of SQL*Net

TRCROUTE shows what node along the path is responsible for any errors.

Effect on Performance

The Trace Route Utility uses minimal resources. It gathers information in the connect data of a special connect packet; standard connect packets are not affected.

The server is not affected by TRCROUTE. The listener receives and processes the TRCROUTE connect packet. It returns the information to the client by putting it into a refuse packet. The server does not need to start up any new processes or deal with dummy connections.

Using TCROUTE

To invoke TRCROUTE, enter the following from the command line:

$ trcroute net_service_name

Example

$ trcroute DIA3.WORLD

Copyright (c) 1999 Oracle Corporation. All rights reserved.

Route of TrcRoute:
------------------

Node: Client Time and address of entry into node:
-------------------------------------------------------------
15-JUL-2001 ADDRESS= PROTOCOL=TCP HOST=192.168.138.21 PORT=1523

Node: Server Time and address of entry into node:
-------------------------------------------------------------
15-JUL-2001 ADDRESS= PROTOCOL=TCP HOST=192.168.138.21 PORT=1523


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/936/viewspace-60604/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2001-10-12

  • 博文量
    268
  • 访问量
    172265