Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-03113 ERROR

ORA-03113 ERROR

From: Joel Ehrlich <jehrlich_at_itis.com>
Date: Tue, 12 Sep 2000 15:29:03 -0500
Message-ID: <8pm3qq$gik$1@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

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 Tue Sep 12 2000 - 15:29:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US