ORA-07445 exception encountered: core dump ACCESS_VIOLATION

While upgrading an Oracle database from 9i to 10g, I got the  following error message. This was completed after having just restored the 9i  database from an RMAN backup.

The database was started using the STARTUP UPGRADE option.  This error was seen when running the catupgrd.sql script and taken from the  alert log.

ORA-07445: exception encountered: core dump  [ACCESS_VIOLATION] [.kgghash+1216] [PC:0xBEF9F40] [ADDR:0x1] [UNABLE_TO_READ]  []

The reason for this error message was because there were no  TEMP files in the database, and this is required to run the catupgrd.sql  script. Check if you have TEMP files using:

SELECT file_name
FROM dba_temp_files;

If there aren’t any, use:

ALTER TABLESPACE TEMP ADD TEMPFILE '<file_name>' SIZE  100M;

Read more about how to drop Oracle TEMP files and TEMP space monitoring.

Like it, share it...

Category: Upgrades