ORA-03113: 通信通道的文件结束

一直的经典，03113。查看还有没有其他伴随错误，提供更为详尽的信息。只有ORA-03113，可能性太多了。

一般是连接断掉了就会这样报的
先查一下你的数据库的连接数设置是多大？
select t.NAME,t.VALUE from v$parameter t where t.NAME='sessions';
select count(*) from v$session;
是不是连接数耗尽？

[Oracle] ORA-03113错误分析与解决

我摘录一部分trace文件/data3/hhzj/admin/hhzj/udump/hhzj_ora_13500.trc
Oracle9i Enterprise Edition Release 9.0.1.1.0 - 64bit Production
With the Partitioning option
JServer Release 9.0.1.1.0 - Production
ORACLE_HOME = /opt/oracle
System name: SunOS
Node name: ZJYDBserver
Release: 5.8
Version: Generic_117350-02
Machine: sun4u
Instance name: hhzj
Redo thread mounted by this instance: 1
Oracle process number: 14
Unix process pid: 13500, image: oracle@ZJYDBserver (TNS V1-V3)*** SESSION ID:(10.6) 2010-03-08 09:30:06.991
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0xc, PC: [0x101204134, 0000000101204134]
*** 2010-03-08 09:30:07.020
ksedmp: internal or fatal error
ORA-07445: 出现异常: 核心转储 [0000000101204134] [SIGSEGV] [Address not mapped to object] [0x00000000C] [] []
Current SQL statement for this session:
BEGIN
   LBACSYS.lbac_events.logon(dbms_standard.login_user);
  END;
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
3939cda18       517  package body LBACSYS.LBAC_CACHE
393a0a8e8        82  package body LBACSYS.LBAC_EVENTS
393a0ccb8         2  anonymous block
----- Call Stack Trace -----
calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp()+344         CALL     ksedst()+0           102954B60 ? 000000000 ?
                                                   000000001 ? 000000013 ?
                                                   000000000 ? 102954C30 ?
ssexhd()+608         CALL     ksedmp()+0           1004B7D20 ? 000000001 ?
                                                   000000010 ?
                                                   FFFFFFFF7FFF6870 ?
                                                   000000001 ? 000000007 ?
sigacthandler()+44   PTR_CALL 0000000000000000     00000000B ?
                                                   FFFFFFFF7FFF70A0 ?
                                                   FFFFFFFF7FFF6DC0 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ?
zllcini()+244        PTR_CALL 0000000000000000     00000000B ?
                                                   FFFFFFFF7FFF70A0 ?Files currently opened by this process:
===================================================
PROCESS STATE
-------------
Process global information:
     process: 394231b10, call: 3942cc1a0, xact: 394a75f98, curses: 3942632c0, usrses: 3942632c0
  ----------------------------------------
  SO: 394231b10, type: 2, owner: 0, flag: INIT/-/-/0x00
  (process) Oracle pid=14, calls cur/top: 3942cc1a0/3942cc020, flag: (0) -
            int error: 0, call error: 0, sess error: 0, txn error 0
  (post info) last post received: 120 0 4
              last post received-location: kslpsr
              last process to post me: 39422ee10 1 6
              last post sent: 0 0 15
              last post sent-location: ksasnd
              last process posted by me: 39422ee10 1 6
    (latch info) wait_event=0 bits=0
    Process Group: DEFAULT, pseudo proc: 3942580d8
    O/S info: user: oracle, term: UNKNOWN, ospid: 13500
    OSD pid info: 13500
    ----------------------------------------
    SO: 394797d90, type: 8, owner: 394231b10, flag: INIT/-/-/0x00
    (FOB) flags=2 fib ptr=948b4fb0 incno=3 pending i/o cnt=0
    ----------------------------------------
    SO: 394797cd8, type: 8, owner: 394231b10, flag: INIT/-/-/0x00
    (FOB) flags=2 fib ptr=948b5298 incno=0 pending i/o cnt=0
    ----------------------------------------
    SO: 3942632c0, type: 4, owner: 394231b10, flag: INIT/-/-/0x00
    (session) trans: 394a75f98, creator: 394231b10, flag: (58000041) USR/- BSY/-/-/-/-/-
              DID: 0001-000E-00000002, short-term DID: 0000-0000-00000000
              txn branch: 0
              oct: 0, prv: 0, user: 37/LBACSYS
    O/S info: user: SYSTEM, term: ZJYNET, ospid: 3980:3948, machine: WORKGROUP\ZJYNET
              program: MessageRemind.exe
    waiting for 'single-task message' blocking sess=0x0 seq=61 wait_time=0
                =0, =0, =0
    temporary object counter: 0
      ----------------------------------------
      SO: 394e1b3e8, type: 47, owner: 3942632c0, flag: INIT/-/-/0x00
      LIBRARY OBJECT LOCK: lock=394e1b3e8 handle=3939cda18 mode=N
      call pin=394e1c048 session pin=0
      user=3942632c0 session=3942632c0 count=1 flags=PNC/[04] savepoint=4630
      LIBRARY OBJECT HANDLE: handle=3939cda18
      name=LBACSYS.LBAC_CACHE
      hash=de911966 timestamp=08-11-2001 16:33:51
      namespace=BODY/TYBD flags=KGHP/TIM/SML/[02000000]
      kkkk-dddd-llll=0000-0011-0011 lock=N pin=S latch=1
      lwt=3939cda48[3939cda48,3939cda48] ltm=3939cda58[3939cda58,3939cda58]
      pwt=3939cda78[3939cda78,3939cda78] ptm=3939cdb08[3939cdb08,3939cdb08]
      ref=3939cda28[3939cda28, 3939cda28] lnd=3939cdb20[3939cdb20,3939cdb20]
        LIBRARY OBJECT: object=3939cd7d8
        type=PKBD flags=EXS/LOC[0005] pflags=NST/SWR [09] status=VALD load=0
        DEPENDENCIES: count=24 size=32
        READ ONLY DEPENDENCIES: count=6 size=16
        ACCESSES: count=15 size=16
        DATA BLOCKS:
        data#     heap  pointer status pins change

调试易

ORA-03113: 通信通道的文件结束

解决方案 »