Re: ORA-03135 only for certain users?

You can also try generating a trace file (MOS 404724.1) to see what the recursive processes are doing before your session is disconnected.

Seth Miller

On Mon, Nov 10, 2014 at 9:46 AM, Tim Gorman <tim_at_evdbt.com> wrote:

> 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_at_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_at_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_at_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
>
>
>

--
http://www.freelists.org/webpage/oracle-l