Search This Blog

Thursday, July 1, 2021

"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. 

No comments:

Post a Comment

You cannot complete this task because one of the following events caused a loss of page data: A system failure has occurred "Front end is locked after 12.2 upgrade"

  If you have upgraded to Oracle E-Business Suite 12.2.10 Release Update Pack from Oracle E-Business Suite 12.2.6 Release Update Pack (or ea...