Issue when Clone EBS Database After Upgrade To19c or connecting as Apps

Error:


Getting Issue to Clone EBS Database after upgrade to19c or connect as apps user

Command Running :

perl <ORACLE_HOME>/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=<DB Context File> \
-oraclehome=<ORACLE_HOME> -outdir=<ORACLE_HOME>/appsutil/log -mode=getUtlFileDir


Set the Target UTL_FILE_DIR Values in Oracle Database, getting below Error

ERROR DESCRIPTION:
(*******FATAL ERROR*******
PROGRAM : (<ORACLE_HOME>/appsutil/bin/txkCfgUtlfileDir.pl)
TIME : Mon Jan 24 00:07:53 2022
FUNCTION: main::validateAppsSchemaCredentials [ Level 1 ]
ERRORMSG: Invalid APPS database user credentials.
)
ERRORCODE = 1 ERRORCODE_END



ERROR
-----------------------
:validateAppsSchemaCredentials [ Level 1 ]


CAUSE
 Service for for the PDB is not getting registered in the listener:

 

$ lsnrctl status BEECDB

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 03-APR-2022 18:11:03

Copyright (c) 1991, 2021, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=funebs122.lab)(PORT=1551)))
STATUS of the LISTENER
------------------------
Alias BEECDB
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 01-FEB-2022 23:31:39
Uptime 1 days 18 hr. 39 min. 23 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File <ORACLE_HOME>/network/admin/listener.ora
Listener Log File <ORACLE_HOME>/log/diag/tnslsnr/testhost/testcdb/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=funebs122.lab)(PORT=1551)))
Services Summary...
Service "BEECDB" has 1 instance(s).
Instance "BEECDB", status READY, has 1 handler(s) for this service...
Service "BEECDBXDB" has 1 instance(s).
Instance "BEECDB", status READY, has 1 handler(s) for this service...

<<<<<<< ------------------------ no PDB here
The command completed successfully

 

Also when PDB environment is sourced connect as apps user doesn't work

$ sqlplus apps/<apps_password>@BEE

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Feb 3 20:21:59 2022
Version 19.12.0.0.0

Copyright (c) 1982, 2021, Oracle. All rights reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

 

Solution:

Connect to CDB and check value for parameter local_listener;

SQL> show parameter local_listener;

 

Value should be as bellow:

NAME                                       TYPE          VALUE
------------------------------------ ----------- ------------------------------
local_listener                             string      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=funebs122.lab)(PORT=1551)))

 

 If values are not as expected run bellow command :

Replace funebs122.lab with your Database hostname and 1551 with value from your system

 

SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=funebs122.lab)(PORT=1551)))'=both;

System altered.

SQL> alter system register;

System altered.

SQL>

 

Check also values from PDB

SQL> show pdbs;

CON_ID   CON_NAME                       OPEN MODE    RESTRICTED
---------- ------------------------------ --------------  ----------
2            PDB$SEED                        READ ONLY    NO
3            BEE                               READ WRITE  NO


SQL> alter session set container=BEE;

Session altered.

SQL> show parameter local_listener;

If any value then reset it

SQL> alter system set local_listener='';

System altered.

SQL> alter system register;

System altered.

SQL>

 
$ lsnrctl status BEECDB

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 03-APR-2022 21:59:24

Copyright (c) 1991, 2021, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=funebs122.lab)(PORT=1551)))
STATUS of the LISTENER
------------------------
Alias BEECDB
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 03-APR-2022 23:31:39
Uptime 1 days 22 hr. 27 min. 44 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File <ORACLE_HOME>/network/admin/listener.ora
Listener Log File <ORACLE_HOME>/log/diag/tnslsnr/testhost/testcdb/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=funebs122.lab.com)(PORT=1551)))
Services Summary...
Service "BEECDB" has 1 instance(s).
Instance "BEECDB", status READY, has 1 handler(s) for this service...
Service "BEECDBXDB" has 1 instance(s).
Instance "BEECDB", status READY, has 1 handler(s) for this service...
Service "xxxxxxxxxxxxxxx" has 1 instance(s).
Instance "BEECDB", status READY, has 2 handler(s) for this service...
Service "ebs_BEE" has 1 instance(s).                                                           <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
Instance "BEECDB", status READY, has 2 handler(s) for this service...
Service "bee" has 1 instance(s).                                                                   <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
Instance "BEECDB", status READY, has 2 handler(s) for this service...
The command completed successfully

 

Also connection as apps should work:
 

$ sqlplus apps/<apps_password>@BEE

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Apr 4 15:42:55 2022
Version 19.12.0.0.0

Copyright (c) 1982, 2021, Oracle. All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0

SQL>





If you like please follow and comment