While upgrading catupgrade.sql
, we are getting below error.
Due to errors found during the upgrade process, the post
upgrade actions in catuppst.sql have not been automatically run.* THEREFORE THE DATABASE UPGRADE IS NOT YET COMPLETE *
- Evaluate the errors found in the upgrade logs
and determine the proper action.
- Execute the post upgrade script as described in Chapter 3
of the Database Upgrade Guide.REASON:
catuppst.sql unable to run in Database: EluxTest Id: 0ERRORS FOUND: during upgrade CATCTL ERROR COUNT=6
Identifier CATALOG 20-01-27 02:20:04 Script = c1102000.sql
ERROR = [ORA-12801: error signaled in parallel query server P000 ORA-01115: IO error reading block from file (block # )ORA-01115: IO error reading block from file 2 (block # 215616)
ORA-27072: File I/O error
Additional information: 4
Additional information: 215616
Additional information: 212992
ORA-06512: at line 8
]
STATEMENT = [BEGIN
EXECUTE IMMEDIATE
'create unique index WRH$_EVENT_HISTOGRAM_PK on WRH$_EVENT_HISTOGRAM
(dbid, snap_id, instance_number, event_id, wait_time_milli, con_dbid)
local nologging parallel
tablespace sysaux';
EXCEPTION
WHEN OTHERS THEN IF (SQLCODE = -942) THEN NULL; ELSE RAISE; END IF;
END;]
Tried various solutions mentioned below posted online in various forums, but nothing worked.
- Increased SGA to 6GB
- Altered Data file
sysaux01
to AUTOEXTEND OFF - Altered datafile to
ONLINE
Best Answer
The real error is:
The "solutions" you tried make no sense when you get something like this.
Fix the storage/filesystem first.