Solved

Generating oracle trace error in bdump file

Posted on 2006-06-20
5
2,922 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Character matching different date formats for dates between 6 72
migration MS SQL database to Oracle 30 71
Oracle 12c Default Isolation Level 17 56
Password_rules_securitty.. 12 33
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

733 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