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).
2 comments:
tunsesaurne Matt Schaub Jersey
Torrey Smith Jersey
Owen Daniels Jersey
HelsimillGeno
In the end I wonder about the soul of Churchians who limit the spirit and awareness of the soul for all their 'flock'! Jesus said, 'We are all the children of God' and God must have people fulfilling his PURPOSE of harmonization here on earth4 AWARENESS When the symptoms first started, I had no idea what was happening to me
It doesn't have to be expensive, it just has to be fun!New Toy Give your parrot something new to do when hanging out in inside the cage! Remodel a littleRev Bresciani is the leader of a non-denominational ministry in the New Orleans area Sure, with some of your marketing strategies you will get instant, or direct, responseIn preparing for this new enlightenment you must let go of old belief systems and thoughts
[url=http://www.authenticnikefalconsshop.com/tony-gonzalez-jersey-for-sale-c-15_22.html]Nike Tony Gonzalez Jersey[/url]
[url=http://www.authenticnikefalconsshop.com/roddy-white-jersey-for-sale-c-15_21.html]Nike Roddy White Jersey[/url]
[url=http://www.authenticnikefalconsshop.com/matt-ryan-jersey-for-sale-c-15_18.html]Nike Matt Ryan Jersey[/url]
Post a Comment