• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 656
  • Last Modified:

Tools to use to figure out how/why Oracle 11gR1 DB is dropping connections

We have an application that is continuing to experience DB connectivity errors while trying to work with Oracle 11gR1 DB Instance. For some reasons, connectivity continues to be dropped and the application throws an error.

I have two questions:
1. Are there any tools that would help me determine how or why connections are being dropped? If so what are they?
2. Is there any technique (i.e. modifying SQLNET.ora or TNSNAMES.ora) that can help keep connections persistent so they don't expire?
3. Note we are using three methiods to connect to the DB: JDBC, OLE DB, and Web Logic.

[24] ERROR ORA-03113: end-of-file on communication channel
Process ID: 11635
Session ID: 573 Serial number: 23072
   at Hyperion.DimensionServer.Library.CopyDimensionInSQL(Application sourceApp, Dimension sourceDimension, String targetName, String targetDescription, Application targetApplication, Boolean retainFilters, Boolean retainPropOverrides)
   at Hyperion.DimensionServer.Library.CopyDimension(Int32 libraryID, Int32 sourceAppID, Int32 sourceDimensionID, String targetName, String targetDescription, Int32 targetApplicationID, Boolean retainFilters, Boolean retainPropOverrides, Boolean updateAppSyncProp, Boolean skipUpdateSync, Boolean allowIsClonedUpdate)
   at Hyperion.DimensionServer.Automators.CopyDimension.Execute()
   at Hyperion.DimensionServer.Proxies.DimensionsProxy.<>c__DisplayClass1e.<>c__DisplayClass20.<CopyDimension2>b__1d(Object job)Oracle.DataAccess.Client.OracleException ORA-03113: end-of-file on communication channel
Process ID: 11635
Session ID: 573 Serial number: 23072    at Hyperion.DimensionServer.Library.CopyDimensionInSQL(Application sourceApp, Dimension sourceDimension, String targetName, String targetDescription, Application targetApplication, Boolean retainFilters, Boolean retainPropOverrides)
   at Hyperion.DimensionServer.Library.CopyDimension(Int32 libraryID, Int32 sourceAppID, Int32 sourceDimensionID, String targetName, String targetDescription, Int32 targetApplicationID, Boolean retainFilters, Boolean retainPropOverrides, Boolean updateAppSyncProp, Boolean skipUpdateSync, Boolean allowIsClonedUpdate)
   at Hyperion.DimensionServer.Automators.CopyDimension.Execute()
   at Hyperion.DimensionServer.Proxies.DimensionsProxy.<>c__DisplayClass1e.<>c__DisplayClass20.<CopyDimension2>b__1d(Object job)
0
dlnewman70
Asked:
dlnewman70
2 Solutions
 
tangchunfengCommented:
There should be a trace file from the failed session in
           USER_DUMP_DEST
0
 
slightwv (䄆 Netminder) Commented:
The bad news is a ORA-03113 is a pretty generic error.

You can enable tracing at various levels.  The docs talk about them:

http://docs.oracle.com/cd/E11882_01/network.112/e10835/sqlnet.htm

You can also trace connections:
http://www.orafaq.com/wiki/SQL_Trace

I've had a specific row in a table cause a ORA-03113.  Every time I would select it, disconnect.  I deleted the row, reinserted it, and everything was fine.  It was just one of those obscure bugs.

I strongly suggest you work directly with Oracle Support on this one.  They have the knowledge of where to start the diagnosis and can tell you exactly what to trace and when.
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

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

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