Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
Problem Description: Frequent Forms Processes sessions dis-connectivity
Symptoms:
on the application tier,on plsql module , database log file show the below:
Thu Feb 18 06:37:36 2010
Database adp encountered ORA-3113ORA-03113: end-of-file on communication channel
------------------------------------------------------------------------------
Thu Feb 18 06:37:42 2010
Database adp encountered ORA-3113ORA-03113: end-of-file on communication channel
------------------------------------------------------------------------------
Thu Feb 18 06:37:57 2010
Database adp encountered ORA-3113ORA-03113: end-of-file on communication channel
Some users while running sql statements from sqlplus that takes roughly >15s, they got disconnected.
Other users while working on PL/SQL application got page cannot be displayed, refresh the page sometime works and sometimes not.
Sqlnet.log shows
Fatal NI connect error 12518, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521))(CONNECT_DATA=(oracle_sid=)(CID=(PROGRAM=oracle@)(HOST=)(USER=oracle))))
VERSION INFORMATION:
TNS for Solaris: Version 10.2.0.3.0 - Production
TCP/IP NT Protocol Adapter for Solaris: Version 10.2.0.3.0 - Production
Time: 18-FEB-2010 06:14:37
Tracing not turned on.
Tns error struct:
ns main err code: 12564
TNS-12564: TNS:connection refused
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Dbstatus.log
Thu Feb 18 06:14:19 2010
Database adp encountered ORA-3113ORA-03113: end-of-file on communication channel
------------------------------------------------------------------------------
Thu Feb 18 06:14:32 2010
Database adp encountered ORA-3113ORA-03113: end-of-file on communication channel
------------------------------------------------------------------------------
Thu Feb 18 06:14:36 2010
Database adp encountered ORA-3113ORA-03113: end-of-file on communication channel
Alert log
Thu Feb 18 08:23:35 2010
WARNING: inbound connection timed out (ORA-3136)
Thu Feb 18 08:25:35 2010
WARNING: inbound connection timed out (ORA-3136)
Solution:
1. During the time of error ORA-03113 please check is there is any trace files got generated under udump/bdump/cdump location
If there exist a core dump file under location cdump then please extract the call stack functions from that core file
using the steps as mentioned in the below article :
Article-ID: Note 1812.1
Title: TECH: Getting a Stack Trace from a CORE file
2. Follow Article-ID: Note 120498.1 Title: How To Resolve Most ORA-3113 Errors
3.Check if your server administrator has any scripts which abort long running or CPU intensive processes.
An ORA-3113 process can occur if someone kills your Oracle shadow process at O/S level (Eg: kill -9 on Unix).
Symptoms:
on the application tier,on plsql module , database log file show the below:
Thu Feb 18 06:37:36 2010
Database adp encountered ORA-3113ORA-03113: end-of-file on communication channel
------------------------------------------------------------------------------
Thu Feb 18 06:37:42 2010
Database adp encountered ORA-3113ORA-03113: end-of-file on communication channel
------------------------------------------------------------------------------
Thu Feb 18 06:37:57 2010
Database adp encountered ORA-3113ORA-03113: end-of-file on communication channel
Some users while running sql statements from sqlplus that takes roughly >15s, they got disconnected.
Other users while working on PL/SQL application got page cannot be displayed, refresh the page sometime works and sometimes not.
Sqlnet.log shows
Fatal NI connect error 12518, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521))(CONNECT_DATA=(oracle_sid=)(CID=(PROGRAM=oracle@)(HOST=)(USER=oracle))))
VERSION INFORMATION:
TNS for Solaris: Version 10.2.0.3.0 - Production
TCP/IP NT Protocol Adapter for Solaris: Version 10.2.0.3.0 - Production
Time: 18-FEB-2010 06:14:37
Tracing not turned on.
Tns error struct:
ns main err code: 12564
TNS-12564: TNS:connection refused
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Dbstatus.log
Thu Feb 18 06:14:19 2010
Database adp encountered ORA-3113ORA-03113: end-of-file on communication channel
------------------------------------------------------------------------------
Thu Feb 18 06:14:32 2010
Database adp encountered ORA-3113ORA-03113: end-of-file on communication channel
------------------------------------------------------------------------------
Thu Feb 18 06:14:36 2010
Database adp encountered ORA-3113ORA-03113: end-of-file on communication channel
Alert log
Thu Feb 18 08:23:35 2010
WARNING: inbound connection timed out (ORA-3136)
Thu Feb 18 08:25:35 2010
WARNING: inbound connection timed out (ORA-3136)
Solution:
1. During the time of error ORA-03113 please check is there is any trace files got generated under udump/bdump/cdump location
If there exist a core dump file under location cdump then please extract the call stack functions from that core file
using the steps as mentioned in the below article :
Article-ID: Note 1812.1
Title: TECH: Getting a Stack Trace from a CORE file
2. Follow Article-ID: Note 120498.1 Title: How To Resolve Most ORA-3113 Errors
3.Check if your server administrator has any scripts which abort long running or CPU intensive processes.
An ORA-3113 process can occur if someone kills your Oracle shadow process at O/S level (Eg: kill -9 on Unix).
No comments:
Post a Comment