Here’s how to solve: Error on perl txkCfgUtlfileDir.pl on getUtlFileDir afer restoraion of 19c Database

ERROR on perl txkCfgUtlfileDir.pl on getUtlFileDir when 19c EBS Database backup has been restored

[orauat@ebsdbuat dbs]$ su – orauat
Password:
[orauat@ebsdbuat ~]$ cat envPRECDB.env
. /do2/8010_uat_db/db/19.0.0/PRECDB_ebsdbuat.env
[orauat@ebsdbuat ~]$ . /do2/8010_uat_db/db/19.0.0/PREUPG_ebsdbuat.env
[orauat@ebsdbuat ~]$ cd /do2/8010_uat_db/db/19.0.0/appsutil/bin
[orauat@ebsdbuat bin]$

[orauat@ebsdbuat bin]$ perl txkCfgUtlfileDir.pl -contextfile=/do2/8010_uat_db/db/19.0.0/appsutil/PREUPG_ebsdbuat.xml -oraclehome=/do2/8010_uat_db/db/19.0.0 -outdir=/do2/8010_uat_db/db/19.0.0/appsutil/log -mode=getUtlFileDir
Enter the APPS Password:
Script Name : txkCfgUtlfileDir.pl
Script Version : 120.0.12020000.15
Started : Wed Feb 7 07:47:03 +03 2024
Log File : /do2/8010_uat_db/db/19.0.0/appsutil/log/TXK_UTIL_DIR_Wed_Feb_7_07_46_58_2024/txkCfgUtlfileDir.log
Context file: /do2/8010_uat_db/db/19.0.0/appsutil/PREUPG_ebsdbuat.xml exists.
Completed : Wed Feb 7 07:47:05 +03 2024
ERROR DESCRIPTION:
(FATAL ERROR
PROGRAM : (txkCfgUtlfileDir.pl)
TIME : Wed Feb 7 07:47:04 2024
FUNCTION: main::validateAppsSchemaCredentials [ Level 1 ]
ERRORMSG: Invalid APPS database user credentials.
)
ERRORCODE = 1 ERRORCODE_END

[orauat@ebsdbuat bin]$ exit
logout
[orauat@ebsdbuat dbs]$
[orauat@ebsdbuat dbs]$ lsnrctl status PRECDB
LSNRCTL for Linux: Version 19.0.0.0.0 – Production on 07-FEB-2024 07:47:30
Copyright (c) 1991, 2022, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ebsdbuat.srrco.org.sa)(PORT=1526)))

STATUS of the LISTENER

Alias PRECDB
Version TNSLSNR for Linux: Version 19.0.0.0.0 – Production
Start Date 06-FEB-2024 21:36:41
Uptime 0 days 10 hr. 10 min. 48 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /do2/8010_uat_db/db/19.0.0/network/admin/listener.ora
Listener Log File /do2/8010_uat_db/db/19.0.0/log/diag/tnslsnr/ebsdbuat/precdb/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebsdbuat.srrco.org.sa)(PORT=1526)))
The listener supports no services
The command completed successfully

[orauat@ebsdbuat dbs]$ ps -ef | grep tns
root 68 2 0 Feb06 ? 00:00:00 [netns]
orauat 96275 1 0 Feb06 ? 00:00:00 /do2/8010_uat_db/db/19.0.0/bin/tnslsnr PRECDB -inherit
orauat 116407 115254 0 07:49 pts/1 00:00:00 grep –color=auto tns
[orauat@ebsdbuat dbs]$
[orauat@ebsdbuat dbs]$
[orauat@ebsdbuat dbs]$ cd /do2/8010_uat_db/db/19.0.0/appsutil/scripts/PREUPG_ebsdbuat/
[orauat@ebsdbuat PREUPG_ebsdbuat]$ ./adcdblnctl.sh start PRECDB
Logfile: /do2/8010_uat_db/db/19.0.0/appsutil/log/PREUPG_ebsdbuat/adcdblnctl.txt
You are running adcdblnctl.sh version 120.0.12020000.4
Starting listener process PRECDB …
Listener PRECDB has already been started.
Waiting for service PREUPG to be available…
Waiting for service PREUPG to be available…
Waiting for service PREUPG to be available…

CAUSE:
local_listener was not correct

SOLUTION:
alter system set local_listener=’hostname.domain:dbport’ scope=both;