TxkPostPDBCreationTasks.pl Failing with Invalid Apps Username
(Doc ID 2862677.1)
Last updated on APRIL 04, 2024
Applies to:
Oracle E-Business Suite Technology Stack - Version 12.2.9 to 12.2.11 [Release 12.2]Information in this document applies to any platform.
Symptoms
On : 12.2.9 version, Database for Application Technology
While Performing Post 19c Upgrade Steps TxkPostPDBCreationTasks.pl Fails with Invalid Apps Username Error as shown below
ERROR
-----------------------
Invalid APPS database user credentials.
LOG FILE: /oracle/app/product/19.14/appsutil/log/TXK_POST_PDB_Mon_Apr_11_09_15_23_2022/validate_apps_password.log.
*******FATAL ERROR*******
PROGRAM : (/oracle/app/product/19.14/appsutil/bin/txkPostPDBCreationTasks.pl)
TIME : Mon Apr 11 09:18:58 2022
FUNCTION: main::validateAppsSchemaCredentials [ Level 1 ]
ERRORMSG: Invalid APPS database user credentials.
*******FATAL ERROR*******
PROGRAM : (/oracle/app/product/19.14/appsutil/bin/txkPostPDBCreationTasks.pl)
TIME : Mon Apr 11 09:18:58 2022
FUNCTION: main::validateAppsSchemaCredentials [ Level 1 ]
ERRORMSG: Invalid APPS database user credentials.
validate_apps_password.log shows below error
------------------------
ORA-12541 TNS: No Listener
1. $ cd $ORACLE_HOME/appsutil
$ . ./txkSetCfgCDB.env dboraclehome=<full path of ORACLE_HOME>
2. $ perl $ORACLE_HOME/appsutil/bin/txkPostPDBCreationTasks.pl -dboraclehome=<ORACLE_HOME> \
-outdir=<ORACLE_HOME>/appsutil/log -cdbsid=<CDB SID> -pdbsid=<PDB SID> \
-appsuser=apps -dbport=<TNS port number> -servicetype=onpremise
Changes
Upgrading From Non Multi-Tenant Database 12c to Multitenant Database 19c
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 |
| Changes |
| Cause |
| Solution |