Re: ORA-03113 ERROR

From: H. Clare <daveyj_at_nme.com>
Date: Wed, 13 Sep 2000 10:20:09 +0100
Message-ID: <8pngsi$fu4$1@gxsn.com>

Hi there,

had a very simmilar problem to this recently got this from Oracle, and haven't seen the problem since - so might be worth a try:

Solution Description:

On Windows NT:

Increase the retransmission setting on the Windows NT client by editing the registry and adding the key TcpMaxDataRetransmissions (REG_DWORD) set to 15.

For advanced users:

Go to HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services /Tcpip/Parameters in the registry, add TcpMaxDataRetransmissions and set it to 15.

For Non-Advanced users:

Click on the START menu and select RUN.
In the 'Run' dialog box, type 'regedt32' in the 'Open' field and hit ENTER.
In the 'View' menu at the top, make sure "Tree and Data" is selected.
Find the window labeled "HKEY_LOCAL_MACHINE on Local Machine".
Double-click on the folder that says "SYSTEM".
Double-click on the folder that says "CurrentControlSet".
Double-click on the folder that says "Services".
Double-click on the folder that says "Tcpip".
Click on the folder that says "Parameters".
Go to the 'Edit' menu and select "Add Value".
In the 'Value Name' field, type TcpMaxDataRetransmissions.
Change the 'Data Type' to REG_DWORD using the drop-down list.
Click OK.
In the 'DWORD Editor' dialog box, type '15' in the 'Data' field and make sure the Hex radio button is selected.
Click OK.
You should see the new parameter added to the data window. If not, repeat steps 1-15.

On Windows 95

Increase the retransmission setting on the Windows 95 client by editing the registry and adding the key MaxDataRetries(REG_DWORD) and set it to 15.

For advanced users:
Go to HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services /vxd/mstcp in the registry, add MaxDataRetires and set it to 15.

For Non-Advanced users:
1. Click on the START menu and select RUN.

2. In the 'Run' dialog box, type 'regedit' in the 'Open' field and hit ENTER. 3. The Registry program is displayed.

4. Double-Click on the folder labeled "HKEY_LOCAL_MACHINE".

5. Double-click on the folder that says "SYSTEM".

6. Double-click on the folder that says "CurrentControlSet".

7. Double-click on the folder that says "Services".

8. Double-click on the folder that says "vxd".

9. Click on the folder that says "MSTCP".

Go to the 'Edit' menu and select "New" and then "String Value".
A highlighted field is displayed that says "New Value #1". Type MaxDataRetries and hit return.
Right-Mouse-click on the new entry "MaxDataRetries" and select 'Modify'.
In the 'Value Data' field, type 15.
You should see the new parameter added to the data window. If not, repeat steps 1-13.

Solution Explanation:

SQL*Net tried to transmit the packet five times before it detected the network
was down. This is a default of TCP/IP on Windows NT and Windows 95.

Possibly the last packet sent is not being received by the server. Which returns the error 54, connection reset/network is busy. SQL*Net assumes the server is down and closes the connection.

Original Message ----- From: "Joel Ehrlich" <jehrlich_at_itis.com> Newsgroups: comp.databases.oracle.server Sent: Tuesday, September 12, 2000 9:29 PM Subject: ORA-03113 ERROR

> I have recently encountered a serious problem where I get kicked off of
the
> Oracle server when I try to create an index on a column in a
(coincidently)
> hash clustered table. Below is the run with the resulting Oracle error,
the
> error description, and the trace file that gets generated. Any help
> resolving the problem would be appreciated.
>
> --Joel
>
> *********************************************************************
> SQL OUTPUT
> *
> *********************************************************************
>
> Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
> With the Partitioning and Objects options
> PL/SQL Release 8.0.5.0.0 - Production
>
> SQLWKS> CREATE CLUSTER CLUSTX
> 2> (REFERRAL_ID VARCHAR2(10))
> 3> SIZE 8192
> 4> STORAGE (INITIAL 20M NEXT 5M PCTINCREASE 5)
> 5> PARALLEL;
> Statement processed.
> SQLWKS>
> SQLWKS>
> SQLWKS> create table table1
> 2> (cnty_spfcd VARCHAR2(2),
> 3> dispstn_cd VARCHAR2(1),
> 4> rcl_dispdt DATE,
> 5> fkclient_t VARCHAR2(10),
> 6> fkreferl_t VARCHAR2(10),
> 7> dsp_rsnc NUMBER(6),
> 8> lst_upd_ts DATE)
> 9> CLUSTER CLUSTX(fkreferl_t);
> Statement processed.
> SQLWKS> CREATE INDEX "user1"."REFRLCLT_IDX" ON "user1"."table1"
> (FKREFERL_T, FKCLIENT_T)
> 2> TABLESPACE "SHADIDX"
> 3> PCTFREE 10 INITRANS 2 MAXTRANS 255
> 4> STORAGE ( INITIAL 40K NEXT 19176K MINEXTENTS 1 MAXEXTENTS 505
> PCTINCREASE 50 FREELISTS 1)
> 5> NOSORT
> 6> PARALLEL (DEGREE 2)
> 7> NOLOGGING;
> CREATE INDEX "user1"."REFRLCLT_IDX" ON "user1"."table1" (FKREFERL_T,
> FKCLIENT_T)
> *
> ORA-03113: end-of-file on communication channel
>
> ****************************************************************
> DOCUMENTATION ON ORACLE ERROR MESSAGE ORA-03113 *
> ****************************************************************
>
> ORA-03113: end-of-file on communication channel
> Cause: An unexpected end-of-file was processed on the communication
channel.
> The problem could not be handled by the Net8, two task, software. This
> message could occur if the shadow two-task process associated with a Net8
> connect has terminated abnormally, or if there is a physical failure of
the
> interprocess communication vehicle, that is, the network or server machine
> went down.
>
> Action: If this message occurs during a connection attempt, check the
setup
> files for the appropriate Net8 driver and confirm Net8 software is
correctly
> installed on the server. If the message occurs after a connection is well
> established, and the error is not due to a physical failure, check if a
> trace file was generated on the server at failure time. Existence of a
trace
> file may suggest an Oracle internal error that requires the assistance of
> customer support.
>
>
> ****************************************************************
> TRACE FILE OUTPUT
> *
> ****************************************************************
>
> Dump file D:\orant\RDBMS80\trace\ORA00254.TRC
> Tue Sep 12 11:01:33 2000
> ORACLE V8.0.5.0.0 - Production vsnsta=0
> vsnsql=c vsnxtr=3
> Windows NT V4.0, OS V5.101, CPU type 586
> Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
> With the Partitioning and Objects options
> PL/SQL Release 8.0.5.0.0 - Production
> Windows NT V4.0, OS V5.101, CPU type 586
> Instance name: orng
>
> Redo thread mounted by this instance: 1
>
> Oracle process number: 11
>
> pid: fe
>
>
> *** 2000.09.12.11.01.33.593
> *** SESSION ID:(15.3772) 2000.09.12.11.01.33.437
> FATAL ERROR IN TWO-TASK SERVER: error = 12571
> *** 2000.09.12.11.01.33.593
> ksedmp: internal or fatal error
> Current SQL information unavailable - no session.
> ----- Call Stack Trace -----
> calling call entry
> argument values in hex
> location type point
> (? means dubious value)
> -------------------- -------- --------------------
-
> ---------------------------
> _ksedmp+9e CALLrel _ksedst+0
>
> 60E5F0
> _opitsk+cdb CALLrel _ksedmp+0
2
> _opiino+4fe CALLrel _opitsk+0
0
> _opiodr+4a6 CALLreg 00000000
> 3C 4
>
> F60FBFC
> _opidrv+335 CALLrel _opiodr+0
> 3C 4
>
> F60FBFC
>

0
> _sou2o+f CALLrel _opidrv+0
> 3C 4
>
> F60FBFC
> _opimai+10c CALLrel _sou2o+0
> _OracleThreadStart_at_4+47e CALLrel _opimai+0
2
>
> F60FE78
> 77F04EDB CALLreg 00000000
> ----- Argument/Register Address Dump -----
> Argument/Register addr=f60e5f0. Dump of memory from F60E5B0 to F60E6F0
> F60E5A0 00000000 00000003 00000000
> 65522140
> F60E5C0 00000033 00000000 00000003 0F60E589 00000001 00000000 00000000
> 00000000
> F60E5E0 00000000 0000001D 0019E440 0F60E600 009E7F78 009E7F78 009E7F78
> 009E7F80
> F60E600 009E7F78 009E7F78 009E7F78 009E7F78 009E7F80 0019E440 00000000
> 00000000
> F60E620 00000000 0019E440 0F60E6D8 007F85BC 0F60E63C 0000001C 00000000
> 2A2A2A0A
> F60E640 30303220 39302E30 2E32312E 302E3131 33332E31 32332D25 2D252073
> 25207338
> F60E660 7332332D 0F660020 00000001 00002F78 0000311B 30364620 38374546
> 25207300
> F60E680 7332332D 342D2520 00000A73 0F660030 655221F4 00000033 00000000
> 0019E440
> F60E6A0 0F60E6C0 00000020 00000000 00000000 0F60FFEC 00000000 0F60FE78
> 00000000
> F60E6C0 00000001 00000001 00000000 0F60DE38 00000003 0F60E6FC 007BB0F3
> 0F60E614
> F60E6E0 00000000 0000311B 001A0CD8 00000001
> Argument/Register addr=f60fbfc. Dump of memory from F60FBBC to F60FCFC
> F60FBA0
> 77F1C807
> F60FBC0 0F60FBF0 001F0003 0F663BD8 002C40E0 00000000 00000000 00000000
> 00000048
> F60FBE0 0F60FBD0 00000000 00000000 00000000 00000774 0F60FC14 77F1C78A
> 0F60FD85
> F60FC00 FFFFFFFF 00000000 00000001 00000000 0F60FE8C 77F02EC6 0F60FFB8
> 004027D3
> F60FC20 00000002 0F60FE78 00000000 00000000 013B9768 001A28F0 00000000
> 00000000
> F60FC40 00000000 00000000 00000000 00000000 00000000 00000000 00000000
> 44414853
> F60FC60 00000000 00000000 00000002 00C37E88 00000734 00000000 00000000
> 00000000
> F60FC80 00000000 00000000 00000000 00000000 00000000 00000000 00000000
> 00000000
> Repeat 2 times
> F60FCE0 00000000 00000000 00000000 00000000 77B24C52 77B20000 00000002
> Argument/Register addr=f60fe78. Dump of memory from F60FE38 to F60FF78
> F60FE20 FFFFFFFF
> 0F60FE54
> F60FE40 77F8896D 00400000 00131DDC 00400000 00000000 0F60FE9C 77F6406D
> 00400000
> F60FE60 00000001 00000009 0F60FE78 00131DDC 7FFDF000 00000000 0F60FD78
> 0F60FD85
> F60FE80 00E90000 0F60FE6C 00000000 61726F2A 77617073 65725F6E 5F796C70
> 676E726F
> F60FEA0 3435325F 0040002A 00000002 0F60FF1C 00000000 77F61292 77FA5560
> 77F61298
> F60FEC0 0F60FF30 00000000 013B9768 00000000 00000000 00000000 00000000
> 00000000
> F60FEE0 00000000 00000000 00000000 00000000 00000000 00000000 00000000
> 00000000
> F60FF00 00000000 0F60FEC0 00000000 FFFFFFFF 77F92CD4 77F9D0E8 FFFFFFFF
> 00000000
> F60FF20 77F763D3 77F763DB 0F60FF30 00000001 00010017 F1D7DB80 F1D7DC80
> 00000000
> F60FF40 F1D7DD98 F1D84C33 00000000 80ECC020 80AD4533 80D92400 80116FE0
> F1597E4C
> F60FF60 00000246 80145589 F1597DD8 80A64FA8 00000000 8014A590
> ----- End of Call Stack Trace -----
> ===================================================
> Files currently opened by this process:
> ===================================================
> PROCESS STATE
> -------------
> Process global information:
> process: e0b10cc, call: 0, xact: 0, curses: 0, usrses: 0
> ----------------------------------------
> SO: e0b10cc, type: 1, owner: 0, flag: INIT/-/-/0x00
> (process) Oracle pid=11, calls cur/top: 0/e0fe518, flag: (0) -
> int error: 0, call error: 0, sess error: 0, txn error 0
> (post info) last post received: 51 0 4
> last post received-location: kslpsr
> last process to post me: e0afad0 1 2
> last post sent: 0 0 15
> last post sent-location: ksasnd
> last process posted by me: e0afad0 1 2
> (latch info) wait_event=0 bits=0
> O/S info: user: SYSTEM, term: ORACLE, ospid: 000FE
> OSD pid info: pid: fe
> ----------------------------------------
> SO: e0fe518, type: 2, owner: e0b10cc, flag: INIT/-/-/0x00
> (call) sess: cur 0, rec 0, usr 0; depth: 0
> END OF PROCESS STATE
>
> --
> Joel Ehrlich, Research Associate
> NCCD/CRC
> 426 South Yellowstone Drive, Suite 250
> Madison, WI 53719
> Phone (608) 831-8882
> Fax (608) 831-6446
> Email: jehrlich_at_itis.com
>
>

"Joel Ehrlich" <jehrlich_at_itis.com> wrote in message news:8pm3qq$gik$1_at_news.chorus.net...
> I have recently encountered a serious problem where I get kicked off of
the
> Oracle server when I try to create an index on a column in a
(coincidently)
> hash clustered table. Below is the run with the resulting Oracle error,
the
> error description, and the trace file that gets generated. Any help
> resolving the problem would be appreciated.
>
> --Joel
>
> *********************************************************************
> SQL OUTPUT
> *
> *********************************************************************
>
> Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
> With the Partitioning and Objects options
> PL/SQL Release 8.0.5.0.0 - Production
>
> SQLWKS> CREATE CLUSTER CLUSTX
> 2> (REFERRAL_ID VARCHAR2(10))
> 3> SIZE 8192
> 4> STORAGE (INITIAL 20M NEXT 5M PCTINCREASE 5)
> 5> PARALLEL;
> Statement processed.
> SQLWKS>
> SQLWKS>
> SQLWKS> create table table1
> 2> (cnty_spfcd VARCHAR2(2),
> 3> dispstn_cd VARCHAR2(1),
> 4> rcl_dispdt DATE,
> 5> fkclient_t VARCHAR2(10),
> 6> fkreferl_t VARCHAR2(10),
> 7> dsp_rsnc NUMBER(6),
> 8> lst_upd_ts DATE)
> 9> CLUSTER CLUSTX(fkreferl_t);
> Statement processed.
> SQLWKS> CREATE INDEX "user1"."REFRLCLT_IDX" ON "user1"."table1"
> (FKREFERL_T, FKCLIENT_T)
> 2> TABLESPACE "SHADIDX"
> 3> PCTFREE 10 INITRANS 2 MAXTRANS 255
> 4> STORAGE ( INITIAL 40K NEXT 19176K MINEXTENTS 1 MAXEXTENTS 505
> PCTINCREASE 50 FREELISTS 1)
> 5> NOSORT
> 6> PARALLEL (DEGREE 2)
> 7> NOLOGGING;
> CREATE INDEX "user1"."REFRLCLT_IDX" ON "user1"."table1" (FKREFERL_T,
> FKCLIENT_T)
> *
> ORA-03113: end-of-file on communication channel
>
> ****************************************************************
> DOCUMENTATION ON ORACLE ERROR MESSAGE ORA-03113 *
> ****************************************************************
>
> ORA-03113: end-of-file on communication channel
> Cause: An unexpected end-of-file was processed on the communication
channel.
> The problem could not be handled by the Net8, two task, software. This
> message could occur if the shadow two-task process associated with a Net8
> connect has terminated abnormally, or if there is a physical failure of
the
> interprocess communication vehicle, that is, the network or server machine
> went down.
>
> Action: If this message occurs during a connection attempt, check the
setup
> files for the appropriate Net8 driver and confirm Net8 software is
correctly
> installed on the server. If the message occurs after a connection is well
> established, and the error is not due to a physical failure, check if a
> trace file was generated on the server at failure time. Existence of a
trace
> file may suggest an Oracle internal error that requires the assistance of
> customer support.
>
>
> ****************************************************************
> TRACE FILE OUTPUT
> *
> ****************************************************************
>
> Dump file D:\orant\RDBMS80\trace\ORA00254.TRC
> Tue Sep 12 11:01:33 2000
> ORACLE V8.0.5.0.0 - Production vsnsta=0
> vsnsql=c vsnxtr=3
> Windows NT V4.0, OS V5.101, CPU type 586
> Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
> With the Partitioning and Objects options
> PL/SQL Release 8.0.5.0.0 - Production
> Windows NT V4.0, OS V5.101, CPU type 586
> Instance name: orng
>
> Redo thread mounted by this instance: 1
>
> Oracle process number: 11
>
> pid: fe
>
>
> *** 2000.09.12.11.01.33.593
> *** SESSION ID:(15.3772) 2000.09.12.11.01.33.437
> FATAL ERROR IN TWO-TASK SERVER: error = 12571
> *** 2000.09.12.11.01.33.593
> ksedmp: internal or fatal error
> Current SQL information unavailable - no session.
> ----- Call Stack Trace -----
> calling call entry
> argument values in hex
> location type point
> (? means dubious value)
> -------------------- -------- --------------------
-
> ---------------------------
> _ksedmp+9e CALLrel _ksedst+0
>
> 60E5F0
> _opitsk+cdb CALLrel _ksedmp+0
2
> _opiino+4fe CALLrel _opitsk+0
0
> _opiodr+4a6 CALLreg 00000000
> 3C 4
>
> F60FBFC
> _opidrv+335 CALLrel _opiodr+0
> 3C 4
>
> F60FBFC
>

0
> _sou2o+f CALLrel _opidrv+0
> 3C 4
>
> F60FBFC
> _opimai+10c CALLrel _sou2o+0
> _OracleThreadStart_at_4+47e CALLrel _opimai+0
2
>
> F60FE78
> 77F04EDB CALLreg 00000000
> ----- Argument/Register Address Dump -----
> Argument/Register addr=f60e5f0. Dump of memory from F60E5B0 to F60E6F0
> F60E5A0 00000000 00000003 00000000
> 65522140
> F60E5C0 00000033 00000000 00000003 0F60E589 00000001 00000000 00000000
> 00000000
> F60E5E0 00000000 0000001D 0019E440 0F60E600 009E7F78 009E7F78 009E7F78
> 009E7F80
> F60E600 009E7F78 009E7F78 009E7F78 009E7F78 009E7F80 0019E440 00000000
> 00000000
> F60E620 00000000 0019E440 0F60E6D8 007F85BC 0F60E63C 0000001C 00000000
> 2A2A2A0A
> F60E640 30303220 39302E30 2E32312E 302E3131 33332E31 32332D25 2D252073
> 25207338
> F60E660 7332332D 0F660020 00000001 00002F78 0000311B 30364620 38374546
> 25207300
> F60E680 7332332D 342D2520 00000A73 0F660030 655221F4 00000033 00000000
> 0019E440
> F60E6A0 0F60E6C0 00000020 00000000 00000000 0F60FFEC 00000000 0F60FE78
> 00000000
> F60E6C0 00000001 00000001 00000000 0F60DE38 00000003 0F60E6FC 007BB0F3
> 0F60E614
> F60E6E0 00000000 0000311B 001A0CD8 00000001
> Argument/Register addr=f60fbfc. Dump of memory from F60FBBC to F60FCFC
> F60FBA0
> 77F1C807
> F60FBC0 0F60FBF0 001F0003 0F663BD8 002C40E0 00000000 00000000 00000000
> 00000048
> F60FBE0 0F60FBD0 00000000 00000000 00000000 00000774 0F60FC14 77F1C78A
> 0F60FD85
> F60FC00 FFFFFFFF 00000000 00000001 00000000 0F60FE8C 77F02EC6 0F60FFB8
> 004027D3
> F60FC20 00000002 0F60FE78 00000000 00000000 013B9768 001A28F0 00000000
> 00000000
> F60FC40 00000000 00000000 00000000 00000000 00000000 00000000 00000000
> 44414853
> F60FC60 00000000 00000000 00000002 00C37E88 00000734 00000000 00000000
> 00000000
> F60FC80 00000000 00000000 00000000 00000000 00000000 00000000 00000000
> 00000000
> Repeat 2 times
> F60FCE0 00000000 00000000 00000000 00000000 77B24C52 77B20000 00000002
> Argument/Register addr=f60fe78. Dump of memory from F60FE38 to F60FF78
> F60FE20 FFFFFFFF
> 0F60FE54
> F60FE40 77F8896D 00400000 00131DDC 00400000 00000000 0F60FE9C 77F6406D
> 00400000
> F60FE60 00000001 00000009 0F60FE78 00131DDC 7FFDF000 00000000 0F60FD78
> 0F60FD85
> F60FE80 00E90000 0F60FE6C 00000000 61726F2A 77617073 65725F6E 5F796C70
> 676E726F
> F60FEA0 3435325F 0040002A 00000002 0F60FF1C 00000000 77F61292 77FA5560
> 77F61298
> F60FEC0 0F60FF30 00000000 013B9768 00000000 00000000 00000000 00000000
> 00000000
> F60FEE0 00000000 00000000 00000000 00000000 00000000 00000000 00000000
> 00000000
> F60FF00 00000000 0F60FEC0 00000000 FFFFFFFF 77F92CD4 77F9D0E8 FFFFFFFF
> 00000000
> F60FF20 77F763D3 77F763DB 0F60FF30 00000001 00010017 F1D7DB80 F1D7DC80
> 00000000
> F60FF40 F1D7DD98 F1D84C33 00000000 80ECC020 80AD4533 80D92400 80116FE0
> F1597E4C
> F60FF60 00000246 80145589 F1597DD8 80A64FA8 00000000 8014A590
> ----- End of Call Stack Trace -----
> ===================================================
> Files currently opened by this process:
> ===================================================
> PROCESS STATE
> -------------
> Process global information:
> process: e0b10cc, call: 0, xact: 0, curses: 0, usrses: 0
> ----------------------------------------
> SO: e0b10cc, type: 1, owner: 0, flag: INIT/-/-/0x00
> (process) Oracle pid=11, calls cur/top: 0/e0fe518, flag: (0) -
> int error: 0, call error: 0, sess error: 0, txn error 0
> (post info) last post received: 51 0 4
> last post received-location: kslpsr
> last process to post me: e0afad0 1 2
> last post sent: 0 0 15
> last post sent-location: ksasnd
> last process posted by me: e0afad0 1 2
> (latch info) wait_event=0 bits=0
> O/S info: user: SYSTEM, term: ORACLE, ospid: 000FE
> OSD pid info: pid: fe
> ----------------------------------------
> SO: e0fe518, type: 2, owner: e0b10cc, flag: INIT/-/-/0x00
> (call) sess: cur 0, rec 0, usr 0; depth: 0
> END OF PROCESS STATE
>
> --
> Joel Ehrlich, Research Associate
> NCCD/CRC
> 426 South Yellowstone Drive, Suite 250
> Madison, WI 53719
> Phone (608) 831-8882
> Fax (608) 831-6446
> Email: jehrlich_at_itis.com
>
>
Received on Wed Sep 13 2000 - 04:20:09 CDT