ORA-03113 in code. In addition, TNS-12535 and ORA-03137 in alert file

facebook twitter digg google delicious technorati stumbleupon myspace wordpress linkedin gmail igoogle windows live tumblr viadeo yahoo buzz yahoo mail yahoo bookmarks favorites email print

Posted by user1348107 on Stack Overflow See other posts from Stack Overflow or by user1348107
Published on 2012-11-02T02:45:41Z Indexed on 2012/11/02 5:01 UTC
Read the original article Hit count: 763

Filed under:

I've got an exception that contain ORA-03113:

(SiPPSS.GetPrintWorkDirectDetail) - ERR:ORA-03113: end-of-file on communication channel Process ID: 7448 Session ID: 30 Serial number: 9802 ?????:12110937 ????:T855
Oracle.DataAccess.Client.OracleException ORA-03113: end-of-file on communication channel Process ID: 7448
Session ID: 30 Serial number: 9802    ?? Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
   ?? Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
   ?? Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
   ?? Oracle.DataAccess.Client.OracleDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   ?? System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   ?? SiPPSS.VSireiMeisaiDsTableAdapters.V_SIREI_MEISAITableAdapter.FillByRunningNoAndProcNo(V_SIREI_MEISAIDataTable dataTable, String RUNNING_NO, String PROC_NO) ?? C:\SVM\trunk\SiPPSSServer\Server\Dao\View\VSireiMeisaiDs.Designer.vb:? 386
   ?? SiPPSS.GetPrintWorkDirectDetail.Execute(BLogicParam param) ?? C:\SVM\trunk\SiPPSSServer\Server\BLogic\Screen\Printing\Rprt0701\GetPrintWorkDirectDetail.vb:? 105

In this case, the oracle alert log as beblow:

Fatal NI connect error 12170.

  VERSION INFORMATION:
    TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
    Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
    Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
  Time: 01-11?-2012 13:50:45
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12535

TNS-12535: TNS: ??????·????????
    ns secondary err code: 12560
    nt main err code: 505

TNS-00505: ???????????
    nt secondary err code: 60
    nt OS err code: 0
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.41.102.53)(PORT=1794))
Thu Nov 01 13:54:17 2012
Thread 1 cannot allocate new log, sequence 1880
Private strand flush not complete
  Current log# 1 seq# 1879 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO01.LOG
Thread 1 advanced to log sequence 1880 (LGWR switch)
  Current log# 2 seq# 1880 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO02.LOG
Thu Nov 01 13:54:21 2012
Archived Log entry 1118 added for thread 1 sequence 1879 ID 0xe48db805 dest 1:
Thu Nov 01 14:40:12 2012
Thread 1 cannot allocate new log, sequence 1881
Private strand flush not complete
  Current log# 2 seq# 1880 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO02.LOG
Thread 1 advanced to log sequence 1881 (LGWR switch)
  Current log# 3 seq# 1881 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO03.LOG
Thu Nov 01 14:40:16 2012
Archived Log entry 1119 added for thread 1 sequence 1880 ID 0xe48db805 dest 1:
Thu Nov 01 15:27:42 2012
Thread 1 cannot allocate new log, sequence 1882
Private strand flush not complete
  Current log# 3 seq# 1881 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO03.LOG
Thread 1 advanced to log sequence 1882 (LGWR switch)
  Current log# 1 seq# 1882 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO01.LOG
Thu Nov 01 15:27:46 2012
Archived Log entry 1120 added for thread 1 sequence 1881 ID 0xe48db805 dest 1:
Thu Nov 01 16:23:48 2012
Thread 1 cannot allocate new log, sequence 1883
Private strand flush not complete
  Current log# 1 seq# 1882 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO01.LOG
Thread 1 advanced to log sequence 1883 (LGWR switch)
  Current log# 2 seq# 1883 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO02.LOG
Thu Nov 01 16:23:52 2012
Archived Log entry 1121 added for thread 1 sequence 1882 ID 0xe48db805 dest 1:
Thu Nov 01 17:05:50 2012
Thread 1 cannot allocate new log, sequence 1884
Private strand flush not complete
  Current log# 2 seq# 1883 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO02.LOG
Thread 1 advanced to log sequence 1884 (LGWR switch)
  Current log# 3 seq# 1884 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO03.LOG
Thu Nov 01 17:05:55 2012
Archived Log entry 1122 added for thread 1 sequence 1883 ID 0xe48db805 dest 1:
Thu Nov 01 17:26:52 2012

Fatal NI connect error 12170.

  VERSION INFORMATION:
    TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
    Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
    Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
  Time: 01-11?-2012 17:26:52
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12535

TNS-12535: TNS: ??????·????????
    ns secondary err code: 12560
    nt main err code: 505

TNS-00505: ???????????
    nt secondary err code: 60
    nt OS err code: 0
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.41.102.62)(PORT=1286))
Thu Nov 01 17:27:16 2012

Fatal NI connect error 12170.

  VERSION INFORMATION:
    TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
    Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
    Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
  Time: 01-11?-2012 17:27:16
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12535

TNS-12535: TNS: ??????·????????
    ns secondary err code: 12560
    nt main err code: 505

TNS-00505: ???????????
    nt secondary err code: 60
    nt OS err code: 0
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.41.102.62)(PORT=1285))
Thu Nov 01 18:08:39 2012
Thread 1 advanced to log sequence 1885 (LGWR switch)
  Current log# 1 seq# 1885 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO01.LOG
Thu Nov 01 18:08:40 2012
Archived Log entry 1123 added for thread 1 sequence 1884 ID 0xe48db805 dest 1:
Thu Nov 01 19:33:21 2012
Thread 1 cannot allocate new log, sequence 1886
Private strand flush not complete
  Current log# 1 seq# 1885 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO01.LOG
Thread 1 advanced to log sequence 1886 (LGWR switch)
  Current log# 2 seq# 1886 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO02.LOG
Thu Nov 01 19:33:25 2012
Archived Log entry 1124 added for thread 1 sequence 1885 ID 0xe48db805 dest 1:
Thu Nov 01 20:32:25 2012
Thread 1 cannot allocate new log, sequence 1887
Private strand flush not complete
  Current log# 2 seq# 1886 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO02.LOG
Thread 1 advanced to log sequence 1887 (LGWR switch)
  Current log# 3 seq# 1887 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO03.LOG
Thu Nov 01 20:32:29 2012
Archived Log entry 1125 added for thread 1 sequence 1886 ID 0xe48db805 dest 1:
Thu Nov 01 21:13:07 2012
Thread 1 advanced to log sequence 1888 (LGWR switch)
  Current log# 1 seq# 1888 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO01.LOG
Thu Nov 01 21:13:08 2012
Archived Log entry 1126 added for thread 1 sequence 1887 ID 0xe48db805 dest 1:
Thu Nov 01 22:00:00 2012
Setting Resource Manager plan SCHEDULER[0x3006]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Thu Nov 01 22:00:00 2012
Starting background process VKRM
Thu Nov 01 22:00:00 2012
VKRM started with pid=32, OS id=4048 
Thu Nov 01 22:00:59 2012
Thread 1 cannot allocate new log, sequence 1889
Private strand flush not complete
  Current log# 1 seq# 1888 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO01.LOG
Thread 1 advanced to log sequence 1889 (LGWR switch)
  Current log# 2 seq# 1889 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO02.LOG
Thu Nov 01 22:01:03 2012
Archived Log entry 1127 added for thread 1 sequence 1888 ID 0xe48db805 dest 1:
Thu Nov 01 22:32:36 2012
Thread 1 advanced to log sequence 1890 (LGWR switch)
  Current log# 3 seq# 1890 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO03.LOG
Thu Nov 01 22:32:37 2012
Archived Log entry 1128 added for thread 1 sequence 1889 ID 0xe48db805 dest 1:
Thu Nov 01 22:33:18 2012
Errors in file d:\oracle\diag\rdbms\siporex\siporex\trace\siporex_ora_11884.trc  (incident=101313):
ORA-03137: TTC protocol internal error : [12333] [8] [49] [50] [] [] [] []
Incident details in: d:\oracle\diag\rdbms\siporex\siporex\incident\incdir_101313\siporex_ora_11884_i101313.trc
Thu Nov 01 22:33:21 2012
Trace dumping is performing id=[cdmp_20121101223321]
Thu Nov 01 22:40:43 2012
Thread 1 cannot allocate new log, sequence 1891
Private strand flush not complete
  Current log# 3 seq# 1890 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO03.LOG
Thread 1 advanced to log sequence 1891 (LGWR switch)
  Current log# 1 seq# 1891 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO01.LOG
Thu Nov 01 22:40:47 2012
Archived Log entry 1129 added for thread 1 sequence 1890 ID 0xe48db805 dest 1:
Thu Nov 01 23:47:30 2012
Thread 1 cannot allocate new log, sequence 1892
Private strand flush not complete
  Current log# 1 seq# 1891 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO01.LOG
Thread 1 advanced to log sequence 1892 (LGWR switch)
  Current log# 2 seq# 1892 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO02.LOG
Thu Nov 01 23:47:34 2012
Archived Log entry 1130 added for thread 1 sequence 1891 ID 0xe48db805 dest 1:
Fri Nov 02 00:49:31 2012
Thread 1 cannot allocate new log, sequence 1893
Private strand flush not complete
  Current log# 2 seq# 1892 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO02.LOG
Thread 1 advanced to log sequence 1893 (LGWR switch)
  Current log# 3 seq# 1893 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO03.LOG
Fri Nov 02 00:49:35 2012
Archived Log entry 1131 added for thread 1 sequence 1892 ID 0xe48db805 dest 1:
Fri Nov 02 01:43:12 2012
Thread 1 cannot allocate new log, sequence 1894
Private strand flush not complete
  Current log# 3 seq# 1893 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO03.LOG
Thread 1 advanced to log sequence 1894 (LGWR switch)
  Current log# 1 seq# 1894 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO01.LOG
Fri Nov 02 01:43:17 2012
Archived Log entry 1132 added for thread 1 sequence 1893 ID 0xe48db805 dest 1:
Fri Nov 02 01:52:51 2012
Errors in file d:\oracle\diag\rdbms\siporex\siporex\trace\siporex_ora_6124.trc  (incident=101273):
ORA-03137: TTC protocol internal error : [12333] [4] [80] [82] [] [] [] []
Incident details in: d:\oracle\diag\rdbms\siporex\siporex\incident\incdir_101273\siporex_ora_6124_i101273.trc
Fri Nov 02 01:52:54 2012
Trace dumping is performing id=[cdmp_20121102015254]
Fri Nov 02 02:00:00 2012
Clearing Resource Manager plan via parameter
Fri Nov 02 02:43:37 2012
Thread 1 cannot allocate new log, sequence 1895
Private strand flush not complete
  Current log# 1 seq# 1894 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO01.LOG
Thread 1 advanced to log sequence 1895 (LGWR switch)
  Current log# 2 seq# 1895 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO02.LOG
Fri Nov 02 02:43:41 2012
Archived Log entry 1133 added for thread 1 sequence 1894 ID 0xe48db805 dest 1:
Fri Nov 02 04:46:18 2012
Thread 1 cannot allocate new log, sequence 1896
Private strand flush not complete
  Current log# 2 seq# 1895 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO02.LOG
Thread 1 advanced to log sequence 1896 (LGWR switch)
  Current log# 3 seq# 1896 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO03.LOG
Fri Nov 02 04:46:22 2012
Archived Log entry 1134 added for thread 1 sequence 1895 ID 0xe48db805 dest 1:
Fri Nov 02 04:51:41 2012
Errors in file d:\oracle\diag\rdbms\siporex\siporex\trace\siporex_ora_4048.trc  (incident=101425):
ORA-03137: TTC protocol internal error : [12333] [4] [67] [85] [] [] [] []
Incident details in: d:\oracle\diag\rdbms\siporex\siporex\incident\incdir_101425\siporex_ora_4048_i101425.trc
Fri Nov 02 04:51:44 2012
Trace dumping is performing id=[cdmp_20121102045144]
Fri Nov 02 05:54:44 2012
Thread 1 cannot allocate new log, sequence 1897
Private strand flush not complete
  Current log# 3 seq# 1896 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO03.LOG
Thread 1 advanced to log sequence 1897 (LGWR switch)
  Current log# 1 seq# 1897 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO01.LOG
Fri Nov 02 05:54:48 2012
Archived Log entry 1135 added for thread 1 sequence 1896 ID 0xe48db805 dest 1:
Fri Nov 02 07:00:34 2012
Thread 1 cannot allocate new log, sequence 1898
Private strand flush not complete
  Current log# 1 seq# 1897 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO01.LOG
Thread 1 advanced to log sequence 1898 (LGWR switch)
  Current log# 2 seq# 1898 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO02.LOG
Fri Nov 02 07:00:38 2012
Archived Log entry 1136 added for thread 1 sequence 1897 ID 0xe48db805 dest 1:
Fri Nov 02 08:32:41 2012
Thread 1 cannot allocate new log, sequence 1899
Private strand flush not complete
  Current log# 2 seq# 1898 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO02.LOG
Thread 1 advanced to log sequence 1899 (LGWR switch)
  Current log# 3 seq# 1899 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO03.LOG
Fri Nov 02 08:32:45 2012
Archived Log entry 1137 added for thread 1 sequence 1898 ID 0xe48db805 dest 1:
Fri Nov 02 09:48:57 2012
Thread 1 advanced to log sequence 1900 (LGWR switch)
  Current log# 1 seq# 1900 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO01.LOG
Fri Nov 02 09:48:58 2012
Archived Log entry 1138 added for thread 1 sequence 1899 ID 0xe48db805 dest 1:
Fri Nov 02 10:18:15 2012
Thread 1 cannot allocate new log, sequence 1901
Private strand flush not complete
  Current log# 1 seq# 1900 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO01.LOG
Thread 1 advanced to log sequence 1901 (LGWR switch)
  Current log# 2 seq# 1901 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO02.LOG
Fri Nov 02 10:18:19 2012
Archived Log entry 1139 added for thread 1 sequence 1900 ID 0xe48db805 dest 1:
Fri Nov 02 10:22:58 2012
Thread 1 cannot allocate new log, sequence 1902
Private strand flush not complete
  Current log# 2 seq# 1901 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO02.LOG
Thread 1 advanced to log sequence 1902 (LGWR switch)
  Current log# 3 seq# 1902 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO03.LOG
Fri Nov 02 10:23:02 2012
Archived Log entry 1140 added for thread 1 sequence 1901 ID 0xe48db805 dest 1:
Fri Nov 02 10:27:38 2012
Thread 1 cannot allocate new log, sequence 1903
Checkpoint not complete
  Current log# 3 seq# 1902 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO03.LOG
Thread 1 cannot allocate new log, sequence 1903
Private strand flush not complete
  Current log# 3 seq# 1902 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO03.LOG
Thread 1 advanced to log sequence 1903 (LGWR switch)
  Current log# 1 seq# 1903 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO01.LOG
Fri Nov 02 10:27:45 2012
Archived Log entry 1141 added for thread 1 sequence 1902 ID 0xe48db805 dest 1:
Fri Nov 02 10:32:27 2012
Thread 1 cannot allocate new log, sequence 1904
Checkpoint not complete
  Current log# 1 seq# 1903 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO01.LOG
Thread 1 cannot allocate new log, sequence 1904
Private strand flush not complete
  Current log# 1 seq# 1903 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO01.LOG
Thread 1 advanced to log sequence 1904 (LGWR switch)
  Current log# 2 seq# 1904 mem# 0: D:\ORACLE\ORADATA\SIPOREX\REDO02.LOG
Fri Nov 02 10:32:34 2012
Archived Log entry 1142 added for thread 1 sequence 1903 ID 0xe48db805 dest 1:
Fri Nov 02 10:35:42 2012
Errors in file d:\oracle\diag\rdbms\siporex\siporex\trace\siporex_ora_15856.trc  (incident=101353):
ORA-03137: TTC protocol internal error : [12333] [8] [49] [50] [] [] [] []
Incident details in: d:\oracle\diag\rdbms\siporex\siporex\incident\incdir_101353\siporex_ora_15856_i101353.trc
Fri Nov 02 10:35:44 2012
Trace dumping is performing id=[cdmp_20121102103544]

I don't know main reason of this issue as well as how to fixing it. Please help me.

© Stack Overflow or respective owner

facebook twitter digg google delicious technorati stumbleupon myspace wordpress linkedin gmail igoogle windows live tumblr viadeo yahoo buzz yahoo mail yahoo bookmarks favorites email print

Related posts about oracle11g

Categories cloud

.NET ASP.NET iphone linux python Windows mysql android sql windows-7 html c ruby-on-rails css objective-c ubuntu networking sql-server wpf asp.net-mvc ruby database Xml apache AJAX osx security regex django Performance 12.04 windows-xp mac web-development iphone-sdk vb.net Silverlight apache2 flash server perl best-practices email installation eclipse visual-studio algorithm windows-server-2008 winforms wcf firefox bash dns /Oracle