This content has been marked as final. Show 8 replies
I think you have the answer :)1 person found this helpful
Error: ORA 2396
Text: exceeded max Idle Time, please connect again
Cause: A user has exceeded the maximum time allowed to remain idle.
Action: The user must reconnect to the database.
reconnect database again.or you can change in the profile "IDLE_TIME" resource
select resource_name,limit from dba_profiles where resource_name='IDLE_TIME';check http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_2007.htm
Edited by: CKPT on Nov 15, 2010 11:37 AM
Hi CKPT. thanks for immediate response.
Could you please elaborate on this : "opidcl aborting process unknown ospid (14605_1)"
what is exactly opidcl ?
what it seems to me is :
<something> is aborting process <unknown> with ospid (14605_1)
what is that something ? as in opidcl , what is it ? and what is <unknown> here ?
i know its a little confusing question .. :( :O
1 person found this helpful
what is that something ? as in opidcl , what is it ? and what is <unknown> here ?This is a function which called when session disappear.
I forgot to ask what the DB Versio, can you post
and any errors followed with ORA-2396 is so please post
aborting process unknown ospidit may be with so many incidents may be due to PMON or any internal errors...
@ Chinar : Thanks :)
@ CKPT : database version 188.8.131.52
and yeah i will post the entire part of the trace file where the error started and where it ended.
Fatal NI connect error 12170.
TNS for Solaris: Version 184.108.40.206.0 - Production
Oracle Bequeath NT Protocol Adapter for Solaris: Version 220.127.116.11.0 - Production
TCP/IP NT Protocol Adapter for Solaris: Version 18.104.22.168.0 - Production
Time: 12-NOV-2010 10:53:07
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 145
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=xx.xxx.xxx.xxx)(PORT=xxxx))
opidcl aborting process unknown ospid (23231_1) due to error ORA-2396
Fri Nov 12 21:33:12 2010
Starting background process CJQ0
< startup continues from here >
I also observed that this error is not new in the alertfile.. this has been coming since the last 1 year.. Since now i have moved into project , i thought may be i could resolve this.
it doesn come very often though..
Read Tom article1 person found this helpful
Hi CKPT ,
How are you ?
I am on oracle 11G SPARC machine .
I checked the link you have mentioned. It simply says that the network connection is breaking down and this process is cleaning it. Also , it speaks that we need to alter the profile.
I checked in my database , but the profile that is being used for all the schemas is either set to unlimited or to 120 minutes.
So what could be the reason ?
The error in the alert log is:
Also , can you please tell me the severity of such an error. ? How severe is this error ?
opidcl aborting process unknown ospid (629_1) due to error ORA-2396
Edited by: Kk on Apr 6, 2011 4:47 AM
Please see : Metalink Note [ID 1286376.1]