Re: 19c upgrade with EBS 12.1.3 environment

Posted by raiq1 on Feb 14, 2022; 11:04pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/19c-upgrade-with-EBS-12-1-3-environment-tp10619p10656.html

Dear sir,

I am the last stage of 19c upgrade, ran post pdb creation script

perl $ORACLE_HOME/appsutil/bin/txkPostPDBCreationTasks.pl -
dboraclehome=/d01/oracle/TEST/19.0.0 -outdir=/d01/oracle/TEST/19.0.0/appsutil/log -cdbsid=TESTCDB -pdbsid=TEST -appsuser=apps -dbport=1542 -servicetype=onpremise

It has created 2 environment files.

-rw-r--r--. 1 oracle oinstall  3217 Feb 14 23:41 TESTCDB_ebs12.env
-rw-r--r--. 1 oracle oinstall  5821 Feb 14 23:41 TEST_ebs12.env

once we tried to connect apps user in PDB environment file, apps are not connected.

[oracle@ebs12 ~]$ . ./TEST_ebs12.env
[oracle@ebs12 ~]$ sqlplus apps/apps@TEST

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Feb 15 01:57:03 2022
Version 19.12.0.0.0

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

ERROR:
ORA-01017: invalid username/password; logon denied


Why it has not connected to pdb database, kindly solve this issue  and we stuck here . because of this issue, we are not move forward with UTL_FILE_CREATION step bcoz there also it has prompt apps password and it is not working.

please advice.

Regards,
Raiq