ORA-07445: core dump [ACCESS_VIOLATION] [ptmak+420]
Tuesday, 07.10.2008 – DejanProblemi 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.