Not connected to ORACLE - ORA-03114

[davis]

Working fine yesterday (06/09/11). Today, cannot compile (or browse objects). On all my machines with PL/SQL developer installed - including remote VMware, gets same message. Has not ever done this before (>5 years). Would seem to be some sort of a 'date' issue?

 

[davis]

I think maybe that the error is because the object being compiled is owned by a different user (giving the 03114 error). It gave me this new error (owned by a different user - which I did not capture) when I logged into Oracle as a different user and tried to compile the same object.

May not be an error at all ... just hard to track the problem.

 

[davis]

Have verified owner, etc. Still an issue. Causing Linux database dump each time I try to compile:

*** 2011-06-10 08:33:07.356
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [ptmak()+106] [SIGSEGV] [Address not mapped to object] [0x8] [] []
Current SQL statement for this session:
BEGIN
/* NOP UNLESS A TABLE OBJECT */
IF dictionary_obj_type = 'TABLE' AND sys.dbms_cdc_publish.active > 0
THEN
sys.dbms_cdc_publish.change_table_trigger(dictionary_obj_owner,dictionary_obj_name,'LOCK');
END IF;
END;
----- Call Stack Trace -----

 

[Marco Kalter]

Looking at the dump file this seems to be caused by a DDL trigger. Perhaps you have recently added or modified such a trigger?

 

[davis]

I have asked the database admins about this trigger and have had no response yet.

 

[davis]

Caused by my network connection going down during a compile. Some internal Oracle table was hung. Object was still valid as of last good compile. Solution was to restart the database and was found on various OTN discussions for the ORA-07445 error. Situation back to normal. Thanks.