My Oracle Support Banner

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 later
Information 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

 

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

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.