EBS / RDBMS -- 19C Upgrade -- Post Upgrade fails "Unable to determine whether the database is pluggable (PDB) or not."

Here I 'am here writing after a long investigation. A long investigation on an error encountered txkPostPDBCreationTasks.pl. I hear you saying -> txkPostPDBCreationTasks again! :) 

Yes. It is a little buggy I think :)

Actually, this time (again!:) the problem was super clear.  I checked the java code and here is what was happening;

The txkPostsPDBCreationTasks.pl was trying to run adbldxml and adbldxml was trying to run the java "GenerateContext" in turn and, GenerateContext was calling getPDBCDB method and that getPDBCDB method was just trying to execute a simple query to check the container configuration -> "select name from v$pdbs" ! just a query to v$pdbs.. No sophisticated check was there! That was it and that v$pdbs was already populated correctly in the database.. No problems with the connection of sqlplus, listeners (both scan and local) were  registered, v$pdbs was correct, no related invalids in the db, the documents followed line by line! .. So the java code was failing somehow.. 

Note that, adbldxml.pl was also failing..

I must admit that, we tried lots of things even though we believed that it was a pure java problem..

As for the solution, we created an Oracle SR and Oracle Support sent us a new adbldxml.pl. We replaced the original adbldxml.pl with the original one and the problem dissapeared!

A quick check showed the difference in getJava_Cmd method.

It seemed the new adbldxml had hard coded $ORACLE_HOME/appsutil/jre , which is set to jre_top.

Earlier, (probably) it was set to $ORACLE_HOME/jdk/jre.

The problem was associated with the following bug : 

Bug 31222688 - ADBLDXML.PL SCRIPT FAILS IN TXKPOSTPDBCREATIONTASKS.PL

I will revisit this blog post and give you the patch number (Ofcourse if we will have one...)