19c database upgrade fails with error:'ORA-04023' ,'catconInit2 - unexpected error in validate_credentials when trying to validate user credentials'
(Doc ID 2712551.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Database Upgrade to 19c fails with error as below, when executed 'dbupgrade':
2020-08-23 15:51:03 DEBUG> $ORACLE_HOME/rdbms/admin/catcon.pm:1186 catcon::exec_DB_script - line does not match marker: ERROR:
2020-08-23 15:51:03 DEBUG> $ORACLE_HOME/rdbms/admin/catcon.pm:1186 catcon::exec_DB_script - line does not match marker: ORA-04023: Object SYS.STANDARD could not be validated or authorized
2020-08-23 15:51:03 DEBUG> $ORACLE_HOME/rdbms/admin/catcon.pm:1186 catcon::exec_DB_script - line does not match marker:
2020-08-23 15:51:03 DEBUG> $ORACLE_HOME/rdbms/admin/catcon.pm:1186 catcon::exec_DB_script - line does not match marker:
..
..
.
2020-08-23 15:51:42 DEBUG> $ORACLE_HOME/rdbms/admin/catcon.pm:1313 catcon::print_exec_DB_script_output - 15:51:41 DBNAME:SYS SQL> 15:51:41 DBNAME:SYS SQL>
2020-08-23 15:51:42 DEBUG> $ORACLE_HOME/rdbms/admin/catcon.pm:1313 catcon::print_exec_DB_script_output -
2020-08-23 15:51:42 DEBUG> $ORACLE_HOME/rdbms/admin/catcon.pm:1313 catcon::print_exec_DB_script_output - 15:51:41 DBNAME:SYS SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
2020-08-23 15:51:42 DEBUG> $ORACLE_HOME/rdbms/admin/catcon.pm:1313 catcon::print_exec_DB_script_output -
2020-08-23 15:51:42 DEBUG> $ORACLE_HOME/rdbms/admin/catcon.pm:1313 catcon::print_exec_DB_script_output - Version 19.3.0.0.0
2020-08-23 15:51:42 DEBUG> $ORACLE_HOME/rdbms/admin/catcon.pm:1313 catcon::print_exec_DB_script_output -
}
End of diagnostic output
2020-08-23 15:51:42 ERROR> $ORACLE_HOME/rdbms/admin/catcon.pm:1317 catcon::print_exec_DB_script_output - ] end of output produced in exec_DB_script
2020-08-23 15:51:42 ERROR> $ORACLE_HOME/rdbms/admin/catcon.pm:13083 catcon::catconInit2 - unexpected error in validate_credentials when trying to validate user credentials
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 |