Re: ORA-03135 only for certain users?

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