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

[shahzad53]

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

[shahzad53]

Dear Erman,

Waiting for your above query.

Regards,
shahzad

[ErmanArslansOracleBlog]

*I think you failed while executing the $ORACLE_HOME/appsutil/bin/txkPostPDBCreationTasks.pl

*Seems that your LD_LIBRARAY is ok, but still did you set your environment correctly? ->

$ cd $ORACLE_HOME/appsutil
$ . ./txkSetCfgCDB.env dboraclehome=<full path of ORACLE_HOME>

*Did you install JRE 8?

To install JRE 8 on the appsutil directory, copy the $ORACLE_HOME/jdk/jre directory to $ORACLE_HOME/appsutil/jre. Run the following commands:

$ cd $ORACLE_HOME/appsutil
$ cp -r $ORACLE_HOME/jdk/jre .
$ cp $ORACLE_HOME/jlib/orai18n.jar $ORACLE_HOME/appsutil/jre/lib/ext

[palaneandavar]

whether it had been resolved ,, if yes what was the solution

[ErmanArslansOracleBlog]

We didn't get any response from person asking the question.
But I revisited this thread and current what I'm thinking is, it may be related with the environment..
especially environment variable named ADJVAPRG..
ADJVAPRG should be set the JDK executable.
You should set your environment with;

 cd $ORACLE_HOME/appsutil
 . ./txkSetCfgCDB.env dboraclehome=<full path of ORACLE_HOME>

And then your $ADJVAPRG should be set to jdk/bin/java..

[oracle@ebsclone appsutil]$ echo $ADJVAPRG
/u01/dbebs/product/19.0.0/jdk/bin/java

This move should fix the issue. It is already documented in "Interoperability Notes: Oracle E-Business Suite Release 12.2 with Oracle Database 19c (Doc ID 2552181.1)" - "Step 6 Run the post PDB script."

Please check your environment with this in mind and retry.