EBS 12.2 login page not coming

[raja]

Hi Erman. Our EBS 12.2 login page is not coming up. Getting the error message in managed server oacore server 1:-^8_qIyIoYBSR1VebuL000003,0] [APP: oacore#1.0.0] Failed to configure EBSLoggerHandler[[
java.lang.ClassNotFoundException: oracle.apps.fnd.common.EBSLoggerHandler
        at weblogic.utils.classloaders.GenericClassLoader.findLocalClass(GenericClassLoader.java:297)
        at weblogic.utils.classloaders.GenericClassLoader.findClass(GenericClassLoader.java:270)
        at weblogic.utils.classloaders.ChangeAwareClassLoader.findClass(ChangeAwareClassLoader.java:64)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
        at weblogic.utils.classloaders.GenericClassLoader.loadClass(GenericClassLoader.java:179)
        at weblogic.utils.classloaders.ChangeAwareClassLoader.loadClass(ChangeAwareClassLoader.java:43)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:195)
        at oracle.apps.fnd.common.ConsoleLogger.initialize(ConsoleLogger.java:149)
        at oracle.apps.fnd.common.ConsoleLogger.<clinit>(ConsoleLogger.java:217)
        at oracle.apps.fnd.security.csrf.GuardFilter.<clinit>(GuardFilter.java:61)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

[ErmanArslansOracleBlog]

Did you apply a patch recently?

Check this note -> Oacore Logs Shows ClassNotFoundException: Oracle.apps.fnd.common.EBSLoggerHandler (Doc ID 2634796.1)

30675109 1OFF:29699652:REMOVE REFERENCE TO EBSLOGGERHANDLER (Patch)

[raja]

No, no patch were applied

thanks

[ErmanArslansOracleBlog]

Did you check the note?

10 Kas 2020 Sal 15:37 tarihinde raja [via Erman Arslan's Oracle Forum] <[hidden email]> şunu yazdı:

No, no patch were applied

thanks

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/EBS-12-2-login-page-not-coming-tp8976p8978.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

[raja]

Hi Erman

it is asking to apply the patch. And in our instance, it was working fine until we bounced the oacore services for OAF development work

Thanks

[ErmanArslansOracleBlog]

Is your env correct?

10 Kas 2020 Sal 17:12 tarihinde raja [via Erman Arslan's Oracle Forum] <[hidden email]> şunu yazdı:

Hi Erman

it is asking to apply the patch. And in our instance, it was working fine until we bounced the oacore services for OAF development work

Thanks

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/EBS-12-2-login-page-not-coming-tp8976p8980.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

[raja]

yes

[ErmanArslansOracleBlog]

What is the version of the ConsoleLogger.class?

Use the following command to check ->

adident Header $JAVA_TOP/oracle/apps/fnd/common/ConsoleLogger.class

[raja]

Hi Erman

$Header ConsoleLogger.java 120.0.12020000.2 2017/12/14 14:11:11 rsantis noship $

Infact, this was working before until we bounce the oacore services. We have the same file version in other instances and it is working fine

thanks

[ErmanArslansOracleBlog]

It should be 120.0.12020000.3..
That patch will upgrade the version of the class to 120.0.12020000.3 and your problem will be dissapeared.

Currently my only recommendation for you is to apply Patch 30675109.. (first apply it to your TEST env , then PROD) .. This patch is a small one, it is only 14.7KB. I didn't check its contents but probably it only changes the ConsoleLogger.java

[raja]

Hi Erman

Applied the patch but issue is not fixed


==============

Setting WLS POOL.....
WLS Pool Configured through JNDI...

<Nov 12, 2020 9:11:43 PM CST> <Error> <ServletContext-/OA_HTML> <BEA-000000> <AppsFilter initialization failed ::
java.lang.ExceptionInInitializerError
        at oracle.apps.fnd.sso.Utils.<clinit>(Utils.java:647)
        at oracle.apps.fnd.security.AppsServletFilter.init(AppsServletFilter.java:174)
        at oracle.apps.fnd.security.LeakDetectionFilter.init(LeakDetectionFilter.java:69)
        at weblogic.servlet.internal.FilterManager$FilterInitAction.run(FilterManager.java:343)
        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
        Truncated. see log file for complete stacktrace
Caused By: java.lang.RuntimeException: Unknown exception. Please contact your System Administrator.
        at oracle.apps.fnd.sso.SessionMgr.loadInstalledLanguages(SessionMgr.java:4206)
        at oracle.apps.fnd.sso.SessionMgr.getInstalledLanguages(SessionMgr.java:3902)
        at oracle.apps.fnd.sso.Utils.getBaseInstalledLangCode(Utils.java:1463)
        at oracle.apps.fnd.sso.Authenticator.<clinit>(Authenticator.java:45)
        at oracle.apps.fnd.sso.Utils.<clinit>(Utils.java:647)
        Truncated. see log file for complete stacktrace
>
=======================
Event postStart received
System.getProperty weblogic.ext.dirs = /u01/install/APPS/fs2/FMW_Home/patch_wls1036/profiles/default/sysext_manifest_classpath
System.getProperty JTFDBCFILE = /u01/install/APPS/fs2/inst/apps/DRIGSI_rigsebsdevapp01/appl/fnd/12.0.0/secure/DRIGSI.dbc
=======================
<Nov 12, 2020 9:11:44 PM CST> <Notice> <Log Management> <BEA-170027> <The Server has established connection with the Domain level Diagnostic Service successfully.>
<Nov 12, 2020 9:11:44 PM CST> <Notice> <Cluster> <BEA-000197> <Listening for announcements from cluster using unicast cluster messaging>
<Nov 12, 2020 9:11:44 PM CST> <Notice> <Cluster> <BEA-000133> <Waiting to synchronize with other running members of oacore_cluster1.>
<Nov 12, 2020 9:12:14 PM CST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to ADMIN>
<Nov 12, 2020 9:12:14 PM CST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RESUMING>
<Nov 12, 2020 9:12:14 PM CST> <Notice> <Cluster> <BEA-000162> <Starting "async" replication service with remote cluster address "null">
<Nov 12, 2020 9:12:14 PM CST> <Notice> <Server> <BEA-002613> <Channel "Default" is now listening on 132.240.247.47:7202 for protocols iiop, t3, CLUSTER-BROADCAST, ldap, snmp, http.>
<Nov 12, 2020 9:12:14 PM CST> <Notice> <WebLogicServer> <BEA-000330> <Started WebLogic Managed Server "oacore_server1" for domain "EBS_domain" running in Production Mode>
<Nov 12, 2020 9:12:15 PM CST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RUNNING>
<Nov 12, 2020 9:12:15 PM CST> <Notice> <WebLogicServer> <BEA-000360> <Server started in RUNNING mode>
<Nov 12, 2020 9:24:37 PM CST> <Alert> <WebLogicServer> <BEA-000396> <Server shutdown has been requested by weblogic>
<Nov 12, 2020 9:24:37 PM CST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FORCE_SUSPENDING>
<Nov 12, 2020 9:24:37 PM CST> <Notice> <Cluster> <BEA-000163> <Stopping "async" replication service>
<Nov 12, 2020 9:24:37 PM CST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to ADMIN>
<Nov 12, 2020 9:24:37 PM CST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FORCE_SHUTTING_DOWN>
<Nov 12, 2020 9:24:37 PM CST> <Notice> <Server> <BEA-002607> <Channel "Default" listening on 132.240.247.47:7202 was shutdown.>
<Nov 12, 2020 9:24:38 PM CST> <Warning> <Common> <BEA-000632> <Resource Pool "EBSDataSource" shutting down, ignoring 1 resources still in use by applications..>
<Nov 12, 2020 9:24:39 PM> <FINEST> <NodeManager> <Waiting for the process to die: 5782>
<Nov 12, 2020 9:24:39 PM> <INFO> <NodeManager> <Server was shut down normally>
<Nov 12, 2020 9:24:39 PM> <FINEST> <NodeManager> <runMonitor returned, setting finished=true and notifying waiters>


=================

[ErmanArslansOracleBlog]

This seems like a different issue.
What is your 3 digit EBS version?

The problem seems to be caused by -> oracle.apps.fnd.sso.SessionMgr.loadInstalledLanguages(SessionMgr.java:4206)

Did you check this MOS Note -> The System Has Encountered An Error When Servicing The Request errors when logging in to 12.2.3,12.2.4 in Multi Word Language environments. (Doc ID 1924639.1)

[raja]

our EBS is 12.2.6. Yeah i have checked and it is asking to apply a patch. But my doubt it this environment was working before

Thanks

[ErmanArslansOracleBlog]

Lets check if APPLSYSPUB is locked or not..

Check for APPLSYSPUB account password in the $CONTEXT_FILE
Try to login into sqlplus using APPLSYSPUB user and password
If the APPLSYSPUB is locked use sqlplus and login as sysdba and unlock the account.
Bounce EBS services and retest the issue.

If this doesn't solve your problem, update me.

[raja]

It is open

Thanks

[ErmanArslansOracleBlog]

1)Where do you see these errors? in oacore out or oacore log? If they are seen in oacore out, please check the oacore log as well.. Tell me what do you see..

2) What is the output of the following query?

select min(NLS_LANGUAGE)
where LANGUAGE_CODE=(select min(LANGUAGE) from FND_LANGUAGES_TL)

Ref: The System Has Encountered An Error When Servicing The Request errors when logging in to 12.2.3,12.2.4 in Multi Word Language environments. (Doc ID 1924639.1)

If the query above returns a multi word, you may still be hitting the bug given in the document above..


3) We also need to check your SessionMgr.java, .. We need to decompile it and check the line 4206...
We need to see the action that is trying to be done in that line and try to find a solution then..

4) We need to enable debug for oacore, reproduce the issue and check the log ->

- Source the run file system environment file

- Backup file:

$INST_TOP/appl/admin/oacore_wls.properties

- Edit $INST_TOP/appl/admin/oacore_wls.properties and add the following lines. (adjust the variables accordingly)

AFLOG_ENABLED=true
AFLOG_LEVEL=statement
AFLOG_MODULE=%
AFLOG_FILENAME=/tmp/aflog.txt

- Re-start Middle tier services

- Reproduce the issue

- Collect the aflog.txt log file

- Disable logging by removing the lines which were added to oacore_wls.properties and re-start services