http 500

[latifa]

Hi Erman,

I cloned my appsTier server where I have all EBS Components. I started services --> OK

However I can't access to the URL (<a href="http://server.domain:port/OA_HTML/AppsLogin">http://server.domain:port/OA_HTML/AppsLogin  and I have the following error message:


The website cannot display the page
 HTTP 500
Most likely causes:
•The website is under maintenance.
•The website has a programming error.
   
What you can try:
   
Refresh the page.  
  Go back to the previous page.  
 More information  More information  

This error (HTTP 500 Internal Server Error) means that the website you are visiting had a server problem which prevented the webpage from displaying.




I have tested my connections to the server:

lacaly and from client: telnet server.domain port  --> OK
curl "<a href="http://server.domain:port">http://server.domain:port"  --> it's OK


 Thank you in advance for your help.

Regards,
Latifa

[latifa]

Hi Erman,

I checked the oacore application.log and Ifound the following message:

18/06/26 23:29:56.334 html: Servlet error
java.lang.NoClassDefFoundError: Could not initialize class oracle.apps.fnd.sso.Utils
        at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:225)
        at oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:291)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpApplication.loadServlet(HttpApplication.java:2528)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpApplication.findServlet(HttpApplication.java:5006)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpApplication.findServlet(HttpApplication.java:4930)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpApplication.getRequestDispatcher(HttpApplication.java:3139)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:775)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
        at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
        at java.lang.Thread.run(Thread.java:745)



What could be as error ?

Regards,
Latifa

[latifa]

Hi Erman,

I restarted DB and Application Tiers and I think no more error message as previoulsy said:
in the application.log, we can see:

18/06/26 23:58:32.806 html: 10.1.3.5.0 Stopped
18/06/27 00:02:23.366 10.1.3.5.0 Started
18/06/27 00:02:26.11 html: 10.1.3.5.0 Started


However I still can't connect the the application :(

Thanks in advanec for your advise.

Regards,
Latifa

[latifa]

Hi Erman,

one more thing, apps account is aften locked ? could it the reason.
Our Database changed apps password with alter user and he didn't know that apps password should changed with FNDCPASS.

Could it the reaon of my issue ? How can we correct this if it is the case.

I checked the GUSET password with

select fnd_web_sec.validate_login('GUEST','****') from dual ;

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

but it is correct in context_file !!

Once again, I compile jsp's and the error message I sent perviously is back :(

So I tried to change apps user as following:


SQL> alter user applsys identified by blablabla ;

User altered.

SQL> alter user apps identified by blablabla ;

User altered.


FNDCPASS apps/blablabla 0 Y system/CAux_TDM_08 APPLSYS old_one

but this one gave an error message:

Working...
Oracle error -29548: ORA-29548: Java system class reported: release of classes.bin in the database does not match that of the oracle executable - USER ( APPS ) has been detected in FND_WEB_SEC.GET_OP_VALUE.


So I found this post: https://chefdba.com/2016/09/02/ebs-blank-login-page-after-database-psu/


SQL> select dbms_java.get_jdk_version() from dual;
select dbms_java.get_jdk_version() from dual
*
ERROR at line 1:
ORA-29548: Java system class reported: release of classes.bin in the database
does not match that of the oracle executable

I done it and I have similar error ...

How can I apply it's solution: "Solution is to fix the OJVM issue by running post installation properly or fixing any errors reported while applying the patch and caused OJVM to be invalid".


Thank you in advance for your help.

Latifa


Note:
I posted previously cloning dbTier with : adcfgclone dbTeckStack and I faced RC errors [RC-50204: Error: - Database Port in use: Port Value = 1521]
--> could it be the root cause of this problem ?

[ErmanArslansOracleBlog]

Any errors during your cloning operations?

Firstly, let's recreate the dbc file and retry.

[latifa]

No there was no error during cloning.

How to create dbc file ?



Ok, I have done it with:

cd $INST_TOP/admin/install
sh adgendbc.sh

[latifa]

I stiil have http 500

[ErmanArslansOracleBlog]

Check this note -> After Recent Clone Login Page Not Loading, Received Java Error Message (Doc ID 2189241.1)

[ErmanArslansOracleBlog]

Bythway, your apps user must not be locked.
So in addition to the action plan above,

unlock apps user.
change its password using FNDCPASS in the proper way .. (R12.2: Steps to Change the APPS, APPLSYS, and APPS_NE Password Using FNDCPASS or AFPASSWD (Doc ID 1674462.1)).
Retry.

[latifa]

I agree with you.

I tried this previously and it doesn't work giving the following error message:

FNDCPASS apps/blablabla 0 Y system/manager APPLSYS old_one

but this one gave an error message:

Working...
Oracle error -29548: ORA-29548: Java system class reported: release of classes.bin in the database does not match that of the oracle executable - USER ( APPS ) has been detected in FND_WEB_SEC.GET_OP_VALUE.


I am sorry, Actually I can't do an other test to modify apps password because it is in use by other persons.


Is the error "ORA-29548" have a signification ?


Thank you Erman for your help.

Latifa

[ErmanArslansOracleBlog]

First consider things documented in "After Recent Clone Login Page Not Loading, Received Java Error Message (Doc ID 2189241.1) "
Then consider unlocking the apps account and changing apps password.

[latifa]

Hi Erman,

In Doc ID 2189241.1, the given solution is to run ;

1. Verify the Java Version on Database by running the command:

select dbms_java.get_jdk_version() from dual;

--> error message as following:
ERROR at line 1:
ORA-29548: Java system class reported: release of classes.bin in the database
does not match that of the oracle executable
 

2. Execute the following on Database node:

 SQL> @?/javavm/install/update_javavm_db.sql


--> What is the risk for the database because it's in use (I don't want our DBA complain about this :) )

Thank you in advance for your help.


Regards,
Latifa

[ErmanArslansOracleBlog]

It is ofcourse risky, but your in-db java is not working anyways...

What about the alert log?

Do you see something like the following in alert log?

joxcsys: release mismatch xxxxx in database (classes.bin) vs xxxxxxx in executable

[latifa]

Yes I saw this error message

[latifa]

Hi Erman,

Our DBA executed : @?/javavm/install/update_javavm_db.sql

the version is following:
DBMS_JAVA.GET_JDK_VERSION()
--------------------------------------------------------------------------------
1.6.0_171

However he applied some patchs just before :

opatch lspatches
26392192;OCW Patch Set Update : 12.1.0.2.171017 (26392192)
21923026;
20641666;
27471186;
26635845;Database PSU 12.1.0.2.171017, Oracle JavaVM Component (OCT2017)
22731026;
26717470;Database Bundle Patch : 12.1.0.2.171017 (26717470)

this one is missing: 19934141.

Do you think we can ignore it ?


What is the comming step on dbTier and AppsTier ? (Autoconf, something else ...)

I think restore fnd_user table and modify paswword with FNDCPASS ?

Thanks in advance for your help

Latifa

[ErmanArslansOracleBlog]

Yeah.. If you see those messages in Alert log , you should run that.
Good.

So your java related problem should be fixed !

your apps user was locked right?

if so;
unlock apps user.  (alter user... unlock)
change its password using FNDCPASS in the proper way .. (R12.2: Steps to Change the APPS, APPLSYS, and APPS_NE Password Using FNDCPASS or AFPASSWD (Doc ID 1674462.1)).
Retry.

Actually, this patch related question is related to a different subject? missing patch? From where? What reference?

This is a seperate issue and you have to create a seperate issue for this.

[latifa]

Hi Erman,

I restored tables FND_USER and FND_ORACLE_USERID. However I can connect with the apps password that is modified with alter user !!! I thought I'll be able to connect to old one

Should I run FNDCPASS to modify them I mean applsys and apps.

By the way you gave me is about r12.2 and my system is 12.1.3

Regards,

Latifa

[latifa]

I understand now, the password is still the same in the database dba_users.

So I modified the password in the database first with alter user to have the same password as source and then applied FNDCPASS tu modify apps password.

[latifa]

Hi Erman,

Every thing is OK and I can access to the application.

Thank you very much for your precious help.

Regards,
Latifa DRIF

[ErmanArslansOracleBlog]

Perfect! :)