How to generate Oracle Net tracing for a DBMS_JOB using a database link
来源:互联网 发布:windows白屏 编辑:程序博客网 时间:2024/05/01 04:50
Problem Description
-------------------
A job that is scheduled via the DBMS_JOB system fails with a general error
returned from the network layer. The job makes use of distributed transactions
(i.e a Database Lin)..
You wish to determine the underlying cause by activating Oracle Net tracing
on the Data Server, where the job was executed. However, no Oracle Net trace
files are created upon job failure.
Solution Description
--------------------
DBMS_JOBs are executed by the SNP background processes which are automatically
started when the database is started. No new client process/session is
created to serve the communication over the database link. Instead, the SNP
process acts as a client on behalf of the database link session.
Therefore, you must trace the SNP background process/es by enabling Oracle Net
server-side tracing for the database where the job is executed.
Solution Explanation
--------------------
1. Enable server-side sqlnet tracing where the job is executed as follows:
# Data Server SQLNET.ORA file:
SQLNET_LEVEL_SERVER=16
SQLNET_FILE_SERVER=server
SQLNET_DIRECTORY_SERVER=/tmp/tns_trace
2. Restart the Listener and Database for the Oracle Net tracing parameters to
take effect.
3. Determine the process id's (PID) for the SNP background process/es as
follows:
SQL> select spid from v$process where program like '%SNP%';
SPID
----------
4894
4896
4. Verify the trace files are created.
Note that the file location and format depends on the Oracle Net trace
parammeters defined in the SQLNET.ORA file.
Based on the above configuration, trace files would have the following
format:
/tmp/tns_trace/server_<spid>.trc
5. Either execute the job manually using 'dbms_job.run(jobno)' or wait until
the job is next executed automatically. Then, determine which of the above
trace files represents your job for further analysis.
References
----------
Note:16658.1 : Tracing SQL*Net/Net8
Additional Search Words
-----------------------
DATABASE; DBLINK; DBMS_JOB; DISTRIBUTED; JOB; LINK; NET; SNP; SQLNET; TRACE;
NET8; NETWORK;
-------------------
A job that is scheduled via the DBMS_JOB system fails with a general error
returned from the network layer. The job makes use of distributed transactions
(i.e a Database Lin)..
You wish to determine the underlying cause by activating Oracle Net tracing
on the Data Server, where the job was executed. However, no Oracle Net trace
files are created upon job failure.
Solution Description
--------------------
DBMS_JOBs are executed by the SNP background processes which are automatically
started when the database is started. No new client process/session is
created to serve the communication over the database link. Instead, the SNP
process acts as a client on behalf of the database link session.
Therefore, you must trace the SNP background process/es by enabling Oracle Net
server-side tracing for the database where the job is executed.
Solution Explanation
--------------------
1. Enable server-side sqlnet tracing where the job is executed as follows:
# Data Server SQLNET.ORA file:
SQLNET_LEVEL_SERVER=16
SQLNET_FILE_SERVER=server
SQLNET_DIRECTORY_SERVER=/tmp/tns_trace
2. Restart the Listener and Database for the Oracle Net tracing parameters to
take effect.
3. Determine the process id's (PID) for the SNP background process/es as
follows:
SQL> select spid from v$process where program like '%SNP%';
SPID
----------
4894
4896
4. Verify the trace files are created.
Note that the file location and format depends on the Oracle Net trace
parammeters defined in the SQLNET.ORA file.
Based on the above configuration, trace files would have the following
format:
/tmp/tns_trace/server_<spid>.trc
5. Either execute the job manually using 'dbms_job.run(jobno)' or wait until
the job is next executed automatically. Then, determine which of the above
trace files represents your job for further analysis.
References
----------
Note:16658.1 : Tracing SQL*Net/Net8
Additional Search Words
-----------------------
DATABASE; DBLINK; DBMS_JOB; DISTRIBUTED; JOB; LINK; NET; SNP; SQLNET; TRACE;
NET8; NETWORK;
0 0
- How to generate Oracle Net tracing for a DBMS_JOB using a database link
- How to read and save Images in a Sql Server Database using ADO.NET and C#
- How to display column values in a single cell in Web Intelligence using Oracle database ?
- How to generate a selective deletion program for info provider
- How To Generate A Wallet Containing A Self Signed Certificate Using ORAPKI [ID 560982.1]
- How to Quiesce a Database
- How to Setup A Database
- Using .NET Databinding to Display Ink from a Database
- Oracle 11g Active Data Guard step by step: How to create a Physical Standby Database using RMAN
- How to Generate a Good Word Embedding?
- illustrates how to perform a SELECT statement using ADO.NET
- using html:link to pass a param
- How to create a link in Linux
- How to recover a SQL Server Database
- How to drop a SQL Server database?
- How to catalog a db2 database
- How To Generate An XML File As A Target Datastore Using ODI In An Integration Interface ? [ID 454268
- Using .NET Databinding to Bind an Editable InkPicture Control to a Database
- 理工大学ACM平台题答案关于C语言 1145 面向对象程序设计上机练习六(类和对象)
- php连接数据库
- LeetCode Multiply Strings
- MySQL:UNION -- 多张表查询出的结果集合并
- Maven搭建多模块企业级项目
- How to generate Oracle Net tracing for a DBMS_JOB using a database link
- ios重要的官方文档地址
- 新手入门--输入格式二
- try()语句,自动资源释放
- DEDE织梦CMS模板在runphp=yes的标签中调用其他field值的方法
- php从数据库中取数据转换为json格式
- [深入理解计算机系统][2.2.5]有符号数和无符号数不匹配导致的安全漏洞
- 我飞舞的思绪
- 使用EMERGENCY模式去访问一个RECOVERY PENDING状态或者SUSPECT状态的数据库