Blank Page when connecting

[big]

Hi,
On R12.2.4 DB 11.2.0.4 on Aix

When connecting , we have a blank page.

====in oacore_server1.log===============================================

####<Aug 4, 2021 5:34:10 PM CEST> <Info> <Deployer> <server> <oacore_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Ke
rnel>> <> <0000NgHn4ocFs1c5xjt1iW1X2fD2000001> <1628091250829> <BEA-149060> <Module /OA_HTML of application oacore [Version=1.0.0] successfully transitioned from STATE_
PREPARED to STATE_ADMIN on server oacore_server1.>
####<Aug 4, 2021 5:34:13 PM CEST> <Info> <ServletContext-/OA_HTML> <server> <oacore_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tun
ing)'> <<anonymous>> <> <0000NgHn4ocFs1c5xjt1iW1X2fD2000001> <1628091253397> <BEA-000000> <oracle.apps.fnd.security.LeakDetectionFilter.initialized:1628091253397>
####<Aug 4, 2021 5:34:13 PM CEST> <Info> <ServletContext-/OA_HTML> <server> <oacore_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tun
ing)'> <<anonymous>> <> <0000NgHn4ocFs1c5xjt1iW1X2fD2000001> <1628091253398> <BEA-000000> <LeakSetting:
        global:true,session:false,aggressive:false,stderr:false,appslog:false,corelog:false
        ignoring:null>


=============in oacore_server1.out============================
<Aug 4, 2021 5:39:08 PM CEST> <Error> <ServletContext-/OA_HTML> <BEA-000000> <chain failed
javax.servlet.ServletException: java.lang.Exception: java.lang.RuntimeException: Guest user/pwd does not exist or match: GUEST/ORACLE
        at weblogic.servlet.jsp.PageContextImpl.handlePageException(PageContextImpl.java:417)

Also I have done:
adopmnctl.sh stopall

adopmnctl.sh: exiting with status 0

cd $FND_TOP/patch/115/bin
perl ojspCompile.pl --compile --flush -p 2
compiling jsps...5954/5954 in 12m53s

Finished!
adopmnctl.sh startall


When run adsrtall.sh, all services are enabled and exit code is zero.

I found this:
EBS R12 Login Page Is Not Coming Up - java.lang.RuntimeException: Guest user/pwd does not exist or match: GUEST/ORACLE (Doc ID 1673030.1) To BottomTo Bottom
Is it also for R12.2?
Should I change GUEST user password in:
DB CONTEXT_FILE
RUN CONTEXT_FILE
PATCH CONTEXT_FILE
And run adconfig on DB, RUN and PATCH?


Thanks for help.

[ErmanArslansOracleBlog]

Do the check documented in that MOS note, if you see the same symptoms then yes that document is correct and you can implement it in your case.

As for your autoconfig related question;

Both in DB and APP;

For 12.2 autoconfig is only intended to be executed for the Run file system.
The patch file system will be updated and configured the next time a patching cycle is run.

[big]

Hi,

Running adautoconfig after editting CONTEXT_FILE did not resolved the problem and we have:
SQL> select fnd_web_sec.validate_login('GUEST','ORACLE') from dual;

FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE')
--------------------------------------------------------------------------------
N

SQL>  select fnd_message.get from dual;

GET
--------------------------------------------------------------------------------
Oracle error -29548: ORA-29548: Java system class reported: release of Java syst
em classes in the database (11.2.0.4.200714) does not match that of the oracle e
xecutable (11.2.0.4.170718) has been detected in FND_WEB_SEC.VALIDATE_LOGIN(u,p)

Is ther any query to vérify release of Java syst
em classes ?
What to do to resolve the release problem?

Thanks and regards.

[ErmanArslansOracleBlog]

Probably you have a ojvm patching problem an inconsistency in the database tier.
Check the ojvm installed and ensure that the postinstallation tasks that are documented in the readme of the relevant ojvm patch are done.. lastly compile the invalids and retry.

[big]

Thank you.

I do not know if collegue before me has installed any ovjm patch incompletely.

If I restore database from a backup done before patching, might the problem be resolved?

Is this inconsistency between java system class and executable a difference between what is registered in database (for java system class) and executable release?

Is ther any query to verify release of Java system classes and executable release ? If not any other way to verify them?

Best regards.

[ErmanArslansOracleBlog]

Probably, your binaries and db layer code are inconsistent in terms of ojvm patch levels. Use opatch to find out. Check the source system as well..

[big]

Hi,
Thank you.

As a solution for ORA-29548, in 12C it is suggeted to run:

@?/javavm/install/update_javavm_db.sql

Can I run this on 11.2.0.4 ?

Regards.

[big]

Hi,
Just for information,

I ran update_javavm_db.sql as sysdba

And no more blank page. We can connecte.

Regards.

[ErmanArslansOracleBlog]

Okay good for you Big.. update_javavm_db.sql script makes changes in the databases to match the binaries.. So this normally is needed to be run, when you still have problems after executing the post install tasks of the relevant OJVM Patch. Probabably, you did a database or db-java upgrade or you applied a combo of  OJVM COMPONENT PSU + DBPSU recently, because we don't expect these types of errors normally...