Thursday, April 23, 2015

The upgrade to Oracle 12.1.0.2 hangs and fails with ORA-00600:[KGHFRE3]

Problem:
The  upgrade to Oracle 12.1.0.2  hangs and then eventyally fails with
ORA-00600: internal error code, arguments: [KGHFRE3], [0x7F5098FC6F48]



Solution:
  1. vi $ORACLE_HOME/rdbms/admin/catuppst.sql script

  2. Comment line #301 "--sys.dbms_stats.gather_fixed_objects_stats;"

  3. Re-run the upgrade manually or using DBUA

  4. After the upgrade is done collect fixed stats manually


I hope this helps.

Please feel free to leave your questions or suggest improvements to this section.
Posted by at
Labels:

2 comments:

  1. UnknownJune 16, 2016 at 9:02 AM

    it also works if you shutdown the database, then clean out the files from every subdirectory under $ORACLE_BASE/diag/rdbms/// the restart the database and run dbua as normal..

    Once it's cleaned out, gather_fixed_object_stats runs quickly and successfully..

    Hope this helps someone..

    ReplyDelete
    Replies
    1. UnknownJune 16, 2016 at 9:03 AM

      that should read $ORACLE_BASE/diag/rdbms/(instance_name)/(db_name)/

      Delete

Subscribe to: Post Comments (Atom)