autoupgrade fails with Error: "ORA-12547: TNS:lost contact"
(Doc ID 2802660.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 using autoupgrade fails with: ORA-12547: TNS:lost contact
catupgrd<timestamp><dbname>.log.log shows:
2021-08-18 17:26:38 DEBUG> <19c_ORACLE_HOME>/rdbms/admin/catcon.pm:1335 catcon::print_exec_DB_script_output - connect / AS sysdba#LF#
2021-08-18 17:26:38 DEBUG> <19c_ORACLE_HOME>/rdbms/admin/catcon.pm:1335 catcon::print_exec_DB_script_output -
2021-08-18 17:26:38 DEBUG> <19c_ORACLE_HOME>/rdbms/admin/catcon.pm:1335 catcon::print_exec_DB_script_output - ORA-12547: TNS:lost contact
2021-08-18 17:26:38 DEBUG> <19c_ORACLE_HOME>/rdbms/admin/catcon.pm:1335 catcon::print_exec_DB_script_output -
2021-08-18 17:26:38 ERROR> <19c_ORACLE_HOME>/rdbms/admin/catcon.pm:13187 catcon::catconInit2 - unexpected error in validate_credentials when trying to validate user credentials
Unexpected error encountered in catctlMain; Error Stack Below; exiting
Died at <19c_ORACLE_HOME>/rdbms/admin/catctl.pl line 9193.
at <19c_ORACLE_HOME>/rdbms/admin/catctl.pl line 9193.
main::catctlDie("\x{a}Unexpected error encountered in catconInit; exiting\x{a} No chil"...) called at <19c_ORACLE_HOME>/rdbms/admin/catctl.pl line 3732
main::catctlDBLogon("<19c_ORACLE_HOME>/rdbms/admin", "< ORACLE_BASE>/autoupgrade/logs/dbname/100/dbupgrade", "catupgrd<timestamp>dbname", 0, 0, 8) called at
2021-08-18 17:26:38 DEBUG> <19c_ORACLE_HOME>/rdbms/admin/catcon.pm:1335 catcon::print_exec_DB_script_output -
2021-08-18 17:26:38 DEBUG> <19c_ORACLE_HOME>/rdbms/admin/catcon.pm:1335 catcon::print_exec_DB_script_output - ORA-12547: TNS:lost contact
2021-08-18 17:26:38 DEBUG> <19c_ORACLE_HOME>/rdbms/admin/catcon.pm:1335 catcon::print_exec_DB_script_output -
2021-08-18 17:26:38 ERROR> <19c_ORACLE_HOME>/rdbms/admin/catcon.pm:13187 catcon::catconInit2 - unexpected error in validate_credentials when trying to validate user credentials
Unexpected error encountered in catctlMain; Error Stack Below; exiting
Died at <19c_ORACLE_HOME>/rdbms/admin/catctl.pl line 9193.
at <19c_ORACLE_HOME>/rdbms/admin/catctl.pl line 9193.
main::catctlDie("\x{a}Unexpected error encountered in catconInit; exiting\x{a} No chil"...) called at <19c_ORACLE_HOME>/rdbms/admin/catctl.pl line 3732
main::catctlDBLogon("<19c_ORACLE_HOME>/rdbms/admin", "< ORACLE_BASE>/autoupgrade/logs/dbname/100/dbupgrade", "catupgrd<timestamp>dbname", 0, 0, 8) called at
autoupgrade<timestamp><dbname>.log shows:
2021-08-18 17:26:38 DEBUG> <19c_ORACLE_HOME>/rdbms/admin/catcon.pm:1335 catcon::print_exec_DB_script_output - connect / AS sysdba#LF#
2021-08-18 17:26:38 DEBUG> <19c_ORACLE_HOME>/rdbms/admin/catcon.pm:1335 catcon::print_exec_DB_script_output - ORA-12547: TNS:lost contact
2021-08-18 17:26:38 ERROR> <19c_ORACLE_HOME>/rdbms/admin/catcon.pm:13187 catcon::catconInit2 - unexpected error in validate_credentials when trying to validate user credentials
2021-08-18 17:26:38 DEBUG> <19c_ORACLE_HOME>/rdbms/admin/catcon.pm:1335 catcon::print_exec_DB_script_output - ORA-12547: TNS:lost contact
2021-08-18 17:26:38 ERROR> <19c_ORACLE_HOME>/rdbms/admin/catcon.pm:13187 catcon::catconInit2 - unexpected error in validate_credentials when trying to validate user credentials
Note: When directly connecting the source database from Target 19c ORACLE_HOME , there are no 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 |