DB connection disconnect abnormal

[itfrank]

After Migration from 8.1.7.4.0 to 9.2.0.6, our DB instance u04asprod encounter
the same Oracle Error continually/arbitrary as follows:
ORA-07445: exception encountered: core dump [00000001022FFF88] [SIGSEGV]
[Address not mapped to object] [0x000000010] [] []
After the above Oracle error encounter, the Database Connection will
disconnected.
By Evaluate the relevant files, the Scenario seems caused by PL/SQL Developer
with same query.
Then I have the following questions:
1) any ideas for the error? whether the PL/SQL Developer version 6.0.3.893 certify Oracle 9i DataBase 9.2.0.6 with Client 9.2.0.5?
2) any workaround or upgrade version?
Please advise. Thanks.

Regards,
Frank

 

[Marco Kalter]

Do you have an idea what action in PL/SQL Developer is related to this issue (e.g. compilation, debugging, connecting, ...)?

 

[JJ]

Hi,

I'm currently having similar problem.
Its happening when compiling a package in the PL/Sql Dev (in Sql*Plus it doesn't happens).
I found a similer bug in Oracle:
ORA-7445 RUNNING PL/SQL DEVELOPER TOOL TO DEBUG PL/SQL WHEN CDC ENABLED

Had anybody experienced such a situation?

THNX
JJ

 

[Marco Kalter]

If a compilation causes such an error and works correctly in SQL*Plus, then I suspect a problem with the "debug information" mode. To verify this, go to Tools > Preferences > Debugger tab page, disable the "Add debug information when compiling" option, and retry the compilation.

If you are using PL/SQL Developer 6.0 or later, you can explicitly exclude specific objects from debug information. On the same debugger tab page you can add a line with the name (or owner.name) of the program unit to the "NEVER add debug info for objects" list.

You can reproduce this issue in SQL*Plus like this:

SQL> alter session set plsql_debug=true;
SQL> @yourpackage.sql

 

[ADie]

This problem occurred in our testing environment, to.

Debugging some bigger packages with PL/SQL leads to ORA-07445. We made a SR (Number 6701975.993) at metalink.oracle.com with following trace information:

Dump file /oasis/trace/sd707g/sd707g_ora_8020.trc
Oracle Database 10g Release 10.2.0.3.0 - Production
ORACLE_HOME = /opt/oracle/product/10.2.0
System name: Linux
Node name: nkk-db07
Release: 2.6.16.21-0.8-bigsmp
Version: #1 SMP Mon Jul 3 18:25:39 UTC 2006
Machine: i686
Instance name: sd707g
Redo thread mounted by this instance: 1
Oracle process number: 28
Unix process pid: 8020, image: oraclesd707g@nkk-db07

*** ACTION NAME) 2008-02-04 16:45:39.617
*** MODULE NAMEapi_deklaration setw_wid_dpg) 2008-02-04 16:45:39.617
*** SERVICE NAMESYS$USERS) 2008-02-04 16:45:39.617
*** SESSION ID187.20434) 2008-02-04 16:45:39.617
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0xab896fff, PC: [0xb18393b, pfrrun()+821]
Registers:
%eax: 0xab896fff %ebx: 0x00002009 %ecx: 0xb70ffbdc
%edx: 0xb70ffc18 %edi: 0xb70ffbdc %esi: 0xab896fff
%esp: 0xbf93241c %ebp: 0xbf9326d4 %eip: 0x0b18393b
%efl: 0x00210206
pfrrun()+800 (0xb183926) mov 0x13c(%ecx),%ebx
pfrrun()+806 (0xb18392c) test $0x2000,%ebx
pfrrun()+812 (0xb183932) jz 0xb184232
pfrrun()+818 (0xb183938) mov 0xffffffd8(%ebp),%esi
> pfrrun()+821 (0xb18393b) movzb (%esi),%eax
pfrrun()+824 (0xb18393e) mov 0x8(%ebp),%edx
pfrrun()+827 (0xb183941) mov 0x18(%edx),%ecx
pfrrun()+830 (0xb183944) movb %al,0xfffffe5c(%ebp)
pfrrun()+836 (0xb18394a) test %ecx,%ecx
*** 2008-02-04 16:45:39.620
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [pfrrun()+821] [SIGSEGV] [Address not
mapped to object] [0xAB896FFF] [] []
Current SQL statement for this session:
BEGIN
:RESULT := oasis.api_deklaration.init_deklaration(i_id_dk => :i_id_dk,
o_wid => :i_wid);
-- Call the function
:result := oasis.api_deklaration.calc_all_dekl_pos(i_wid => :i_wid);
end;
----- PL/SQL Call Stack -----
object line object
handle number name
0x38bda870 18518 package body OASIS.API_DEKLARATION
0x38bda870 1470 package body OASIS.API_DEKLARATION
0x38ac8894 2 anonymous block

>>> Call stack

ksedst # KSE: dump the call stack
ksedmp # KSE: dump the process state
ssexhd # ** DUMP ROUTINE - IGNORE stuff above this on the stack **
pfrrun PSDEVN: PL/SQL Interpreter Main Instruction Loop
plsql_run
peicnt PL/SQL controlled Execution
kkxexe KKX: execute plsql
opiexe opiexe - ORACLE Program Interface EXEcute
kpoal8 kpoal8.c - Kernel Programmatic Oracle ALl Version 8
opiodr OPIODR: ORACLE code request driver - route the current request
ttcpip TTCPIP: Two Task Common PIPe read/write
opitsk opitsk - Two Task Oracle Side Function Dispatcher
opiino opiino - ORACLE Program Interface INitialize Opi
opiodr OPIODR: ORACLE code request driver - route the current request
opidrv # opidrv - ORACLE Program Interface DRiVer (IGNORE)
sou2o # Main Oracle executable entry point
opimai_real
main # Standard executable entry point

ksedst