Solved

Generating oracle trace error in bdump file

Posted on 2006-06-20
5
2,916 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 35

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 35

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
PL/SQL LOOP CURSOR 3 58
File generation using utl_file 4 46
How do I call MySQL Stored Procedure from oracle using HS link ? 5 27
PL/SQL Display based on value 4 20
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

867 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