12c to 19c postpdbcreation failed , ebs 12.2.9 environement.

Posted by shahzad53 on Apr 16, 2020; 4:26pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/12c-to-19c-postpdbcreation-failed-ebs-12-2-9-environement-tp8244.html

Dear Erman,

I have a 12.2.9 ebs with 12.1.0.2 database, for test environemnet we are upgrading our database.

Following a metalink document 2552181.1

We found a error in postpdbcreation steps.

First i wll show you my CDB environement file and then postpdbcreation error.

cdb.env file are below...


export ORACLE_HOME=/d01/oracle/PROD/19.3.0
export ORACLE_SID=CDB
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin
export ORACLE_BASE=/d01/oracle/PROD
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export PERL5LIB=$ORACLE_HOME/perl/lib/5.28.1:$ORACLE_HOME/perl/lib/site_perl/5.28.1
export ORA_NLS10=/d01/oracle/PROD/19.3.0/nls/data/9idata
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ADJVAPRG=/d01/oracle/PROD/19.3.0/appsutil/jre/bin/java


Now postpdbcreation error.....

==========================
Inside setADBldXMLEnv()...
==========================
Environment set
ORACLE_HOME     : /d01/oracle/PROD/19.3.0
TNS_ADMIN       : /d01/oracle/PROD/19.3.0/network/admin/PROD_ebs19c
ORACLE_SID      : PROD
PATH            : /d01/oracle/PROD/19.3.0/perl/bin:/d01/oracle/PROD/19.3.0/bin:/usr/bin:/usr/sbin:/d01/oracle/PROD/19.3.0/appsutil/jre/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/oracle/.local/bin:/home/oracle/bin:/d01/oracle/PROD/19.3.0/bin:/d01/oracle/PROD/19.3.0/OPatch:/d01/oracle/PROD/19.3.0/perl/bin:/d01/oracle/PROD/19.3.0/bin:/d01/oracle/PROD/19.3.0/OPatch:/d01/oracle/PROD/19.3.0/perl/bin
LD_LIBRARY_PATH : /d01/oracle/PROD/19.3.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/usr/dt/lib:/d01/oracle/PROD/19.3.0/ctx/lib
DB_LISTENER     : CDB
DISPLAY         : localhost:10.0
Executing SYSTEM command: perl /d01/oracle/PROD/19.3.0/appsutil/bin/adbldxml.pl appsuser=apps servername=ebs19c.appsdba.info


Starting context file generation for db tier..
ERROR: Unable to set CLASSPATH
     JDBC Driver jars and zips are missing in /d01/oracle/PROD/19.3.0/jdbc/lib directory.
 *******FATAL ERROR*******
PROGRAM : (/d01/oracle/PROD/19.3.0/appsutil/bin/txkPostPDBCreationTasks.pl)
TIME    : Thu Apr 16 12:10:29 2020
FUNCTION: main::generateDBCtxFile [ Level 1 ]
ERRORMSG: Failed to execute /d01/oracle/PROD/19.3.0/appsutil/bin/adbldxml.pl.
*******FATAL ERROR*******
PROGRAM : (/d01/oracle/PROD/19.3.0/appsutil/bin/txkPostPDBCreationTasks.pl)
TIME    : Thu Apr 16 12:10:29 2020
FUNCTION: main::generateDBCtxFile [ Level 1 ]
ERRORMSG: Failed to compile /d01/oracle/PROD/19.3.0/appsutil/bin/adbldxml.pl.


Kindly guide me to solve the issue.

Regards,
shahzad