ORA-07445: core dump [ACCESS_VIOLATION] [ptmak+420]

Tuesday, 07.10.2008 – Dejan

Problemi sa patchom 10.2.0.4 se nastavljaju…

Jedna aplikacija nije mogla da funkcioni┼íe, jer se konekcija sa bazom uvijek prekidala nakon pokretanja odre─Ĺene procedure. Dobijali smo gre┼íku:

ORA-3113: end of file on communication channel

ili na njema─Źkom

ORA-03113: Unerwartetes ├ťbertragungsende in Kommunikation

Po┼íto mi ta gre┼íka nije jasno davala do znanja u ─Źemu je problem, morao sam┬átra┼żiti dalje u ─Źemu je problem.┬áProna┼íao sam u alert logu ovu gre┼íku:

Errors in file c:\oracle\product\10.2.0\admin\esirac\udump\livedb_ora_5104.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [ptmak+420] [PC:0x5F9EBF4] [ADDR:0x10] [UNABLE_TO_READ] []

U navedenoj trace datoteci (livedb_ora_5104.trc) se nalazi više informacija, kao npr.:

 
*** ACTION NAME:() 2008-10-06 18:04:08.483
*** MODULE NAME:(PlSqlDev.exe) 2008-10-06 18:04:08.483
*** SERVICE NAME:(livedb) 2008-10-06 18:04:08.483
*** SESSION ID:(289.12198) 2008-10-06 18:04:08.483
*** 2008-10-06 18:04:08.483
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [ptmak+420] [PC:0x5F9EBF4] [ADDR:0x10] [UNABLE_TO_READ] []
Current SQL statement for this session:
select dummy from dual where  ora_dict_obj_type = 'SYNONYM' AND ora_dict_obj_owner = 'PUBLIC'
  

Po┼íto mi ta gre┼íka nije bila poznata, odmah sam pomislio:”Oh ne! Jo┼í jedan bug!?“…

Rutinski sam pogledao na MetaLinku o ─Źemu se radi i na┼íao obja┼ínjenje i rje┼íenje za ovaj problem.
Radi se o “Bugu 6951953: ORA-7445 [PTMAK] IMPORTING PACKAGE COMPILED DEBUG“.

Konkretno, gre┼íka je uzrokovana kompiliranjem PL/SQL paketa i procedura koriste─çi PL/SQL Developer uz uklju─Źenu “Compile with DEBUG” opciju. Upravo takvo obja┼ínjenje se nalazi i na MetaLinku:

This may be triggered by an upgrade or an import. There may be other potential triggers.
This problem has been seen when using pl/sql developer v7.1.5.1397 with “Debug Preferences->Add Debug on Compiling* set.

Još jedna od greški, koja se spominje na MetaLinku je:

ORA-07445: exception encountered: core dump [ptmak()+372] [SIGSEGV] [Address not mapped to object] [0x000000010] [] []

Nakon što sam ponovo kompilirao pakete i to bez DEBUG opcije, aplikacija je proradila normalno.

Post a Comment