opidcl aborting process unknown ospid (27181) as a result of ORA-2396


bash-3.2$ sqll
 SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 13 14:44:53 2013
 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
 SQL> show parameter user
 NAME TYPE VALUE
 ------------------------------------ ----------- ------------------------------
 license_max_users integer 0
 parallel_adaptive_multi_user boolean TRUE
 redo_transport_user string
 user_dump_dest string /u01/app/oracle/diag/rdbms/ANARDB/ANARDB1/trace
 
 SQL> exit
 Disconnected from 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
 bash-3.2$ 
 bash-3.2$ cd /u01/app/oracle/diag/rdbms/ANARDB/ANARDB1/trace
 bash-3.2$ tail -100f alert_ANARDB1.log
 
 opidcl aborting process unknown ospid (3872) as a result of ORA-2396
 Fri Dec 13 13:25:00 2013
 ALTER SYSTEM ARCHIVE LOG
 Fri Dec 13 13:25:00 2013
 Thread 1 advanced to log sequence 52427 (LGWR switch)
 If you face the above error,
 You can safely ignore.
 It was written in alertlog because of timed out sessions. 
 If you dont want this in alertlog you may have to reset your 
 idle time to unlimited which is not possible in huge environment. 
 So it is better to ignore the above error message.

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: