Solved

Generating oracle trace error in bdump file

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

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Dataware house query tuning 9 78
Wrong number of values in the INTO list of a FETCH statement 16 60
MULTIPLE DATE QUERY 15 77
make null the repeated levels 2 18
Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
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…
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.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

786 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