Oracle Net Services
Oracle Net trace 用于跟踪或调试oracle连接故障,连接异常断开或者连接超时等情形,通过产生详细的跟踪信息来进行分析和诊断Ora
Oracle Net trace 用于跟踪或调试oracle连接故障,连接异常断开或者连接超时等情形,通过产生详细的跟踪信息来进行分析和诊断Oracle Net相关故障。关于这个网络调试主要是通过为相关的网络配置文件添加相关的参数来实现。MetaLink上ID 219968.1有详尽的描述。
一、Oracle trace的相关参数
TRACE_LEVEL_[CLIENT|SERVER|LISTENER] = [0-16|USER|ADMIN|SUPPORT|OFF]
TRACE_FILE_[CLIENT|SERVER|LISTENER] =
TRACE_DIRECTORY_[CLIENT|SERVER|LISTENER] =
TRACE_UNIQUE_[CLIENT|SERVER|LISTENER] = [ON|TRUE|OFF|FALSE]
TRACE_TIMESTAMP_[CLIENT|SERVER|LISTENER] = [ON|TRUE|OFF|FALSE] #Oracle8i+
TRACE_FILELEN_[CLIENT|SERVER|LISTENER] =
TRACE_FILENO_[CLIENT|SERVER|LISTENER] =
LOG_FILE_[CLIENT|SERVER|LISTENER] =
LOG_DIRECTORY_[CLIENT|SERVER|LISTENER] =
LOGGING_LISTENER = [ON|OFF]
TNSPING.TRACE_LEVEL = [0-16|USER|ADMIN|SUPPORT|OFF]
TNSPING.TRACE_DIRECTORY =
NAMES.TRACE_LEVEL = [0-16|USER|ADMIN|SUPPORT|OFF]
NAMES.TRACE_FILE =
NAMES.TRACE_DIRECTORY =
NAMES.TRACE_UNIQUE = [ON|OFF]
NAMES.LOG_FILE =
NAMES.LOG_DIRECTORY =
NAMES.LOG_UNIQUE = [ON|OFF]
NAMESCTL.TRACE_LEVEL = [0-16|USER|ADMIN|SUPPORT|OFF]
NAMESCTL.TRACE_FILE =
NAMESCTL.TRACE_DIRECTORY =
NAMESCTL.TRACE_UNIQUE = [ON|OFF]NOTES ON TRACING 11g AND NEWER CLIENT/SERVER/LISTENER/CMAN
对于Oracle 11g,使用传统的Oracle net tracing时,,必须添加下列参数
Sqlnet.ora file on either client or server:
DIAG_ADR_ENABLED=OFF
Listener.ora file:
DIAG_ADR_ENABLED_
CMAN.ORA:
DIAG_ADR_ENABLED=OFF
ADR_BASE=c:\your_directory
推荐阅读
-
初步了解 Oracle Real User Experience Insight (RUEI)
-
Linux下新建Oracle数据库实例
-
想学php,不知道学完后找工作的薪水比ASP.NET的低么?解决方案
-
oracle数据库中关于游标的常见用法
-
移动联通电信wap和net接入点判断
-
修改计算机名或IP后Oracle10g无法启动服务的解决办法
-
asp.net访问网络路径方法(模拟用户登录)_php技巧
-
ASP.NET Core在支付宝小程序中使用signalR
-
Oracle性能究极优化 上第1/2页
-
Why ngx-uploader doesn't like to cooperate with .net core 2.x?