| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> 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
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;
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);
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;
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.
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 000000003C 4
F60FBFC
_opidrv+335 CALLrel _opiodr+03C 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 0000000065522140
Repeat 2 times
F60FCE0 00000000 00000000 00000000 00000000 77B24C52 77B20000 00000002
Argument/Register addr=f60fe78. Dump of memory from F60FE38 to F60FF78
F60FE20 FFFFFFFF0F60FE54
process: e0b10cc, call: 0, xact: 0, curses: 0, usrses: 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
-- 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.comReceived on Tue Sep 12 2000 - 15:29:03 CDT
 |
 |