-
Getting an ORA-03113 end of communication channel
error when a particular trigger fires. Actually the error occurs at a specific assignment statement in the trigger. I can reproduce it however sometimes it seems to resolve itself and then reappear later on. I'm pretty sure nothing is wrong with the pl/sql code.
Any insight appreceiated. Thanks.
-
more info about the problem
this is what the lsnrctl's status shows.
---------------------------------------------------------------------
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias ORACLE_LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Produc
tion
Start Date 29-MAR-2003 12:41:41
Uptime 0 days 2 hr. 30 min. 31 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File D:\ORACLE\OraHome\network\admin\listener.ora
Listener Log File D:\ORACLE\OraHome\network\log\oracle_listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=HOME)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=HOME)(PORT=8080))(Presentation=HTTP)
(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=HOME)(PORT=2100))(Presentation=FTP)(
Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "oracledb" has 2 instance(s).
Instance "oracledb", status UNKNOWN, has 1 handler(s) for this service...
Instance "oracledb", status READY, has 1 handler(s) for this service...
Service "oracledbXDB" has 1 instance(s).
Instance "oracledb", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>
--------------------------------------------------------------------
Does the 2 instances of oracledb have something to do with this?
Also the oracledbCore.log has stuff likes this in it showing something or other about an ACCESS_VIO on the insert...
-------------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
Process Id: 0x000003a0 Thread Id : 0x00000834 Time : Sat Mar 29 14:51:43
Excp. Code: 0xc0000005 Excp. Type: ACCESS_VIO Flags: 0x00000000
------------------- Registers ----------------------------
eip = 017f0d6f esp = 05aec6d4 ebp = 05aed6e8 edi = 00000010 esi = 06000010
eax = 06000000 ebx = 0000000d ecx = 00000003 edx = 67e8b19c
ecs = 0000001b eds = 00000023 ees = 00000023 ess = 00000023
egs = 00000000 efs = 0000003b
eflags = 00010206
------------------- End of Registers ---------------------
------------------- Instruction Disassembly --------------
------------------- End of Disassembly -------------------
------------------- Call Stack Trace ---------------------
Frameptr RetAddr Param#1 Param#2 Param#3 Param#4 Function Name
0x05aed6e8 00602a52 05b9e678 67e95704 67e95498 05b9e2ec __VInfreq__insrow+b1
0x05aed770 0076c1c6 05b9e678 05aed7ec 00000000 67e95704 _insrow+66
0x05aed844 00601afa 05b9e678 67e95498 00000000 05b9e2ec _insdrv.73+252
0x05aed950 005f692c 67e95704 05aeda30 00000000 05bbcbc8 ..1.6_1.filter.73+11
0x05aedcb4 00663a4e 00000004 00000003 05aede0c 0021f2e0 ..1.5_1.filter.29+12
0x05aedf40 00ff35b0 0000003e 00000022 05aedf84 05aee734 _opiall0+84e
0x05aee044 005dfc74 00000047 0000000f 05aee734 01991d50 _opial7+150
0x05aee260 6050bd40 00000047 0000000f 05aee734 00000002 _opiodr+4d0
0x05aee6fc 00628c1d 0021f2e0 00000047 05aee734 00000000 _ttcpip+a88
0x05aef7a0 00627a91 00000000 00000000 0021f2e0 05b82d90 _opitsk+2f9
0x05aef8a8 005dfc74 0000003c 00000004 05aefbd4 01991ca0 _opiino+601
0x05aefac4 007dd4e8 0000003c 00000004 05aefbd4 00000000 _opiodr+4d0
0x05aefb54 00714d8e 0000003c 00000004 05aefbd4 00000000 _opidrv+238
0x05aefb6c 0070fb5f 05aefbf0 0000003c 00000004 05aefbd4 _sou2o+1e
0x05aefc08 00710511 00000002 05aefe74 00df7298 77d4ea27 _opimai+10f
0x05aeffb4 77e8758a 00df7c34 00df7298 77d4ea27 00df7c34 _OracleThreadStart@4
0x05aeffec 00000000 007101b0 00df7c34 00000000 00000000 0x77e8758a
------------------- End of Stack Trace -------------------
------------------- Raw Stack Dump -----------------------
Address Dump of bytes
0x05aec6d4 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x05aec6e4 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
---------------------------------------------------------------------
-
hi,
if my memory serve me correctly..sometimes intermittent network connection will result in remote user accessing Oracle database to encounter this error...comments?
WH
-
Hi
Check the SQLNET.EXPIRE_TIME. If it is more than zero, set it to zero and try.
Hope this helps.
Nagesh
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|