Error during upgrade : Oracle 11g to 12c
0
votes
1
answer
549
views
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 ***
> 1. Evaluate the errors found in the upgrade logs
and determine the proper action.
2. 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: 0
ERRORS 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
Asked by Omega
(1 rep)
Jan 27, 2020, 12:20 PM
Last activity: Jan 27, 2020, 12:29 PM
Last activity: Jan 27, 2020, 12:29 PM