Re: ORA-03135 only for certain users?

  • From: Tim Gorman <tim@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 10 Nov 2014 08:46:11 -0700

Stephan,
Please query V$ACTIVE_SESSION_HISTORY for the USER_ID (translated from DBA_USERS view) for the time period from a few seconds before and during when you received the ORA-03135 error. Specifically, display the EVENT, P1, P2, and P3 of each ASH row retrieved, in addition to SESSION_ID, SESSION_SERIAL#, and PROGRAM. 

Please let us know what you find?

Thanks!

-Tim



On 11/10/14 2:59, Stephan Uzzell wrote:
Copied off my command prompt, no modifications other than obscuring the password: 

W:\>sqlplus opera_aspx/XXXXXXXX@opapp

SQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 10 04:51:40 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

ERROR:

ORA-03135: connection lost contact

Process ID: 0

Session ID: 0 Serial number: 0

Enter user-name: ^C

W:\>sqlplus usdcdba/XXXXXXXX@opapp

SQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 10 04:53:08 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, 

Data Mining and Real Application Testing options

primary:usdcdba@OPOPERA1>
Everything I can find about the 03135 talks about network, firewall, something in between the client and the server. Any thoughts on tracking this down? 

stephan

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2014