"ERRORMSG: Unable to evaluate DB host and domain." in 19c Upgrade

Hi,

You may encounter the below error while upgrading your database to 19c. This error occur if your hostname command does not return FQDN (Fully Qualified Domain Name) in the DB server. 

You can apply the below workaround for time being and proceed with the upgrade. 

ora19c@oracleebs:~$cd /u02/oracle/TEST/db/tech_st/product/12.1.0/dbhome_1/appsutil

$./txkSetCfgCDB.env dboraclehome=/u02/oracle/TEST/db/tech_st/product/12.1.0/dbhome_1

Oracle Home being passed: /u02/oracle/TEST/db/tech_st/product/12.1.0/dbhome_1

ora19c@oracleebs:~$ export ORACLE_SID=TEST

 

*******FATAL ERROR*******

PROGRAM : (txkOnPremPrePDBCreationTasks.pl)

TIME    : Thu Mar 11 22:22:09 2021

FUNCTION: main::getDBHostDetails [ Level 1 ]

ERRORMSG: Unable to evaluate DB host and domain.

If  Script txkOnPremPrePDBCreationTasks.pl returns the above error perform the fix below :

ora19c@oracleebs:~$ vi txkOnPremPrePDBCreationTasks.pl

Search for word ‘nslookup’ (Approximately at line 1459 )

Comment the line below :                 

#$temp_hostname = `nslookup \`hostname\` | awk \'BEGIN {rv=1;} /^Name:/ {print \$2; exit rv=0;} END {exit rv;}\'`;

Hardcode the below in txkOnPremPrePDBCreationTasks.pl script.

$temp_hostname = "hostname.domainname";

EX : $temp_hostname = "oracleebs.ebs.com";

Note : Use Double Quote for Solaris and Single Quote for Linux while hard coded Hostname in the Script. 

Now, Re-run the script and it should work without any issue. 

$perl txkOnPremPrePDBCreationTasks.pl -dboraclehome=/u02/oracle/TEST/db/tech_st/product/12.1.0/dbhome_1     -outdir=/u02/oracle/TEST/db/tech_st/product/12.1.0/dbhome_1/appsutil/log -appsuser=apps -dbsid=TEST -skipdbshutdown=yes

You may have to apply this workaround for all the scripts in 19c upgrade and Multitenant DB Conversion.