Hi, i am using version Release 11.2.0.3.0 - 64bit of oracle.
Suddenly seeing below error in OEM, and perhaps its originated from any of the syntactical error in code, but i am wondering how come it leads to the termination of session automatically. can you please help me on this. Below is what i see in the OEM alert history, i will post the alert log when i get it.
When i checked the object id- 201572, i found this id to a global temporary table, in which lots of insert operation happens frequently. Wondering if its due to the insufficient tempspace during the insert activity , because the TSNAME is also showin to be 'TEMP', but then the originating error should not be ORA-00904:invalid identifier? Verified the historical tempspace usage during the error duration from dba_hist_tbspc_space_usage, it looks normal.
OEM Alert History:
---------------
Session Terminated Jul 13, 2015 10:50:12 AM Errors in file /local/dbms/oracle/admin/diag/rdbms/db1/trace/db1_ora_122.trc (incident=735404):
ORA-00603: ORACLE server session terminated by fatal error
ORA-00607: Internal error occurred while making a change to a data block
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [kghalf()+55] [SIGSEGV] [ADDR:0x68] [PC:0x8D401C3] [Address not mapped to object] []
ORA-00904: "CUSTOMERNAME": invalid identifier
Trace File: /local/dbms/oracle/admin/diag/rdbms/db1/trace/db1_ora_122.trc
Jul 13, 2015 10:51:32 AM 249015
Session Terminated Alert Log Error Jul 13, 2015 10:50:12 AM Corrupt Block Found
TSN = 3, TSNAME = TEMP
RFN = 16, BLK = 257924, RDBA = 67366788
OBJN = 201572, OBJD = 67366784, OBJECT = , SUBOBJECT =
SEGMENT OWNER = , SEGMENT TYPE =
Errors in file /local/dbms/oracle/admin/diag/rdbms/db1/trace/db1_ora_122.trc (incident=735404):
ORA-00603: ORACLE server session terminated by fatal error
ORA-00607: Internal error occurred while making a change to a data block
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [kghalf()+55] [SIGSEGV] [ADDR:0x68] [PC:0x8D401C3] [Address not mapped to object] []
ORA-00904: "CUSTOMERNAME": invalid identifier
Incident details in: /local/dbms/oracle/admin/diag/rdbms/db1/incident/incdir_735404/db1_ora_122_i735404.trc Jul 13, 2015