Ora-3113 in client while Ora-3137 in alert log of Oracle 11.1.0.7
edited Mar 21, 2014 11:30PM in Database ORA-600 / ORA-7445 Analysis , Diagnostic Repository (ADR) & Packaging (MOSC) 10 commentsAnswered
I have a database running in Oracle 11.1.0.7 and there is replication process that replicates data to the Db, and it consistently have connection lost issues. It will throw Ora-3113. When the apps sends record in one by one, it lasts longer time and when the apps tries to group the transactions in larger amount(e.g:100), it quickly hit the error and abend. Looking in the alert log, it have ora-3137 on and off.
Sun Dec 08 11:36:30 2013 Thread 1 advanced to log sequence 43411 (LGWR switch) Current log# 1 seq# 43411 mem# 0: +DATA_1/aedjp/onlinelog/group_1.799.774696121 Current log# 1 seq# 43411 mem# 1: +ARCH_1/aedjp/onlinelog/group_1.9863.774696123 Sun Dec 08 11:36:31 2013 Archived Log entry 87110 added for thread 1 sequence 43410 ID 0x2300dcb5 dest 1: Sun Dec 08 11:43:43 2013 Errors in file /u01/app/oracle/diag/rdbms/aedjp/aedjp1/trace/aedjp1_ora_6940.trc: ORA-03137: TTC protocol internal error : [12333] [254] [64] [42] [] [] [] []
0