Autoupgrade fails with error "SP2-1519: Unable to write to the error log table SYS.REGISTRY$ERROR"
(Doc ID 2813571.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
During DB upgrade to 19c using autoupgrade, following error is faced -
2021-08-14 01:41:56.678 ERROR
DATABASE NAME: dev1-CDB$ROOT
CAUSE: ERROR at Line 854951 in [/u01/app/19c/autoupgrade/dev1/100/dbupgrade/catupgrd20210814010437cdbroot0.log]
REASON: ORA-03113: end-of-file on communication channel
ACTION: [MANUAL]
DETAILS: 03113, 00000, "end-of-file on communication channel"
// *Cause: The connection between Client and Server process was broken.
// *Action: There was a communication error that requires further investigation.
// First, check for network problems and review the SQL*Net setup.
// Also, look in the alert.log file for any errors. Finally, test to
// see whether the server process is dead and whether a trace file
// was generated at failure time.
..
..
..
2021-08-14 01:41:58.547 ERROR UPGRADE FAILED [dev1-CDB$ROOT]
2021-08-14 01:41:58.548 ERROR Exception Error in Database Upgrade [UPG-1400#UPGRADE FAILED [dev1-CDB$ROOT]]
2021-08-14 01:41:58.548 INFO End Upgrade on Database [dev1-CDB$ROOT]
2021-08-14 01:41:59.531 ERROR UPGRADE FAILED [dev1]
2021-08-14 01:41:59.532 ERROR Exception Error in Database Upgrade [dev1]
2021-08-14 01:41:59.640 ERROR dev1Return status is ERROR
2021-08-14 01:41:59.672 ERROR Dispatcher failed: AutoUpgException [UPG-1400#UPGRADE FAILED [dev1]]
2021-08-14 01:41:59.678 INFO Starting error management routine
2021-08-14 01:41:59.680 INFO Ended error management routine
2021-08-14 01:41:59.681 ERROR Error running dispatcher for job 100
Cause: Database upgrade failed with errors
DATABASE NAME: dev1-CDB$ROOT
CAUSE: ERROR at Line 854951 in [/u01/app/19c/autoupgrade/dev1/100/dbupgrade/catupgrd20210814010437cdbroot0.log]
REASON: ORA-03113: end-of-file on communication channel
ACTION: [MANUAL]
DETAILS: 03113, 00000, "end-of-file on communication channel"
// *Cause: The connection between Client and Server process was broken.
// *Action: There was a communication error that requires further investigation.
// First, check for network problems and review the SQL*Net setup.
// Also, look in the alert.log file for any errors. Finally, test to
// see whether the server process is dead and whether a trace file
// was generated at failure time.
..
..
..
2021-08-14 01:41:58.547 ERROR UPGRADE FAILED [dev1-CDB$ROOT]
2021-08-14 01:41:58.548 ERROR Exception Error in Database Upgrade [UPG-1400#UPGRADE FAILED [dev1-CDB$ROOT]]
2021-08-14 01:41:58.548 INFO End Upgrade on Database [dev1-CDB$ROOT]
2021-08-14 01:41:59.531 ERROR UPGRADE FAILED [dev1]
2021-08-14 01:41:59.532 ERROR Exception Error in Database Upgrade [dev1]
2021-08-14 01:41:59.640 ERROR dev1Return status is ERROR
2021-08-14 01:41:59.672 ERROR Dispatcher failed: AutoUpgException [UPG-1400#UPGRADE FAILED [dev1]]
2021-08-14 01:41:59.678 INFO Starting error management routine
2021-08-14 01:41:59.680 INFO Ended error management routine
2021-08-14 01:41:59.681 ERROR Error running dispatcher for job 100
Cause: Database upgrade failed with errors
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |