Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2931
  • Last Modified:

Generating oracle trace error in bdump file

Hi,

I am working on oracle 9i database. I am getting following error bdump trace file.
pl suggest.


Dump file d:\oracle\admin\hrms\bdump\hrms_smon_2992.trc
Thu May 04 12:32:09 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Instance name: hrms

Redo thread mounted by this instance: 1

Oracle process number: 6

Windows thread id: 2992, image: ORACLE.EXE


*** 2006-05-04 12:32:10.000
*** SESSION ID:(5.1) 2006-05-04 12:32:09.000
*** 2006-05-04 12:32:10.000
SMON: Parallel transaction recovery tried
*** 2006-05-11 04:20:45.000
SMON: Parallel transaction recovery tried
*** 2006-05-25 06:54:54.000
SMON: Parallel transaction recovery tried
*** 2006-05-25 09:21:05.000
SMON: Parallel transaction recovery tried
*** 2006-05-26 03:50:08.000
SMON: Parallel transaction recovery tried
*** 2006-05-26 04:14:02.000
SMON: Parallel transaction recovery tried
*** 2006-06-05 10:01:36.000
SMON: Parallel transaction recovery tried
*** 2006-06-05 10:33:19.000
SMON: Parallel transaction recovery tried


thanks in advance

Regards,
Sandeep
0
sandy261978
Asked:
sandy261978
  • 2
1 Solution
 
Mark GeerlingsDatabase AdministratorCommented:
What happened before this?  Was there a server or instance crash, and this happened after a reboot?  Have any users indicated any problems?  Or, did these messages just start appearing without any other problems that you know of?
0
 
sandy261978Author Commented:
Server and instance are working fine.
But user inform me that theri session gets disconnected after 45 min to 80min giving error
ora-03113 end-of-file on communication channel.

0
 
Mark GeerlingsDatabase AdministratorCommented:
The ORA-03113 error is one of the most difficult Oracle errors to deal with and troubleshoot for two reasons:
1. It doesn't really tell us anything other than the fact that the Oracle client lost its connection to the server, but there is no clue as to whether this is a database problem, a client application problem, a network problem, etc.
2. It is not possible to code an exception-handler to deal with this error.

You may need to open a Service Request with Oracle and have them help you with some SQL*Net debugging.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now