Solved

Generating oracle trace error in bdump file

Posted on 2006-06-20
5
2,914 Views
Last Modified: 2008-01-09
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
Comment
Question by:sandy261978
  • 2
5 Comments
 
LVL 34

Expert Comment

by:Mark Geerlings
ID: 16944010
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
 

Author Comment

by:sandy261978
ID: 16949226
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
 
LVL 34

Accepted Solution

by:
Mark Geerlings earned 125 total points
ID: 16950688
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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now