1 2 Previous Next 16 Replies Latest reply on Aug 15, 2019 5:07 PM by Maaz Khan

    ORA-29541: class APPS.oracle/apps/fnd/security/WebSessionManagerProc

    User348186

      After the clone  and after starting the application-The login screen is just blank.

      I couldn't change the password by FNDCPASS:

      error in j2ee/oacore :

       

      at com.evermind.server.ApplicationServerLauncher.run(ApplicationServerLauncher.java:131)

              at java.lang.Thread.run(Thread.java:619)

      Caused by: java.lang.RuntimeException: Cannot Load Properties from the Databasejava.lang.RuntimeException: Guest user/pwd does not exist or match: GUEST/ORACLE

              at oracle.apps.fnd.common.Guest$GuestDelegate.<init>(Guest.java:353)

              at oracle.apps.fnd.common.Guest$GuestDelegate.getInstance(Guest.java:284)

              at oracle.apps.fnd.common.Guest.getDelegate(Guest.java:210)

              at oracle.apps.fnd.common.Guest.getUserPwd(Guest.java:157)

              at oracle.apps.jtf.base.session.SiteProperty.load0(SiteProperty.java:77)

              at oracle.apps.jtf.base.session.SiteProperty.load(SiteProperty.java:60)

       

       

      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 -29541: ORA-29541: class APPS.oracle/apps/fnd/security/WebSessionMa

      nagerProc could not be resolved has been detected in FND_WEB_SEC.VALIDATE_LOGIN(

      u,p).

       

      As per the document:

      FNDCPASS Troubleshooting Guide For Login and Changing Applications Passwords ( Doc ID 1306938.1  )

      step 19:

      19. ORA-29541 Unable to Change Password Using FNDCPASS Utility

       

      SQL> alter java class '/b3e79110_HTTPData' resolve;

      alter java class '/b3e79110_HTTPData' resolve

        *

      ERROR at line 1:

      ORA-29501: invalid or missing Java source, class, or resource name

       

        • 1. Re: ORA-29541: class APPS.oracle/apps/fnd/security/WebSessionManagerProc
          Maaz Khan

          Hi,

           

          We need more information about your environment -

          EBS version -

          DB version -

          Platform -

           

           

          Can you please share output of below statements that I assume you have already executed -

          Please note below statements are required to be executed on db node -

          1. Unzip RDBMS $ORACE_HOME/rdbms/jlib/servlet.jar to a temporary location.

          2. cd to the <temp location>/javax/servlet

          loadjava -u sys/<syspwd> -v -f -r ServletRequest.class

          3. cd to the <temp location>/javax/servlet/http

          loadjava -u sys/<syspwd> -v -f -r HttpServletRequest.class

           

          Output for loadjava should be something like below -

           

          [oraprod@stage servlet]$ loadjava -u sys/<> -v -f -r ServletRequest.class

          arguments: '-u' 'sys/***' '-v' '-f' '-r' 'ServletRequest.class'

          creating : class javax/servlet/ServletRequest

          loading  : class javax/servlet/ServletRequest

          resolving: class javax/servlet/ServletRequest

          Classes Loaded: 1

          Resources Loaded: 0

          Sources Loaded: 0

          Published Interfaces: 0

          Classes generated: 0

          Classes skipped: 0

          Synonyms Created: 0

          Errors: 0

           

           

           

          Please share below as well -

          select DBMS_JAVA.LONGNAME(OBJECT_NAME) JAVA_NAME

          from dba_objects

          where object_type in ('JAVA CLASS','JAVA RESOURCE','JAVA SOURCE')

          and status='INVALID';

           

           

          As a workaround you can run utlrp and compare invalid objects count before and after utlrp -

          Login as sysdba and execute -

          SQL>  @?/rdbms/admin/utlrp.sql

           

           

          Regards,

          Maaz

           

           

          • 2. Re: ORA-29541: class APPS.oracle/apps/fnd/security/WebSessionManagerProc
            Maaz Khan

            Also, please make sure you are connected as apps user when running below -

             

            As sysdba -

             

            SQL> alter java class "/69cdcac5_URLTools" resolve;

            alter java class "/69cdcac5_URLTools" resolve

                             *

            ERROR at line 1:

            ORA-04043: object /69cdcac5_URLTools does not exist

             

             

            As apps user -

             

            SQL> conn apps

            Enter password:

            Connected.

            SQL> alter java class "/69cdcac5_URLTools" resolve;

             

             

            Java altered.

             

             

            SQL>

             

             

            Regards,

            MAaz

            • 3. Re: ORA-29541: class APPS.oracle/apps/fnd/security/WebSessionManagerProc
              User348186

              thanks for your reply.. we executed the below as apps user"

              alter java class "/69cdcac5_URLTools" resolve;

               

              EBS version - 12.1.2

              DB version - 11.2.0.4

              Platform - DB in Solaris10 :  EBS in Linux 6

               

              SQL> select DBMS_JAVA.LONGNAME(OBJECT_NAME) JAVA_NAME

              from dba_objects
              where object_type in ('JAVA CLASS','JAVA RESOURCE','JAVA SOURCE')
              and status='INVALID';  2    3    4

              JAVA_NAME
              --------------------------------------------------------------------------------
              oracle/apps/fnd/security/AolSecurity
              oracle/apps/fnd/security/DataVerificationException
              oracle/apps/fnd/security/HTTPData$1
              oracle/apps/fnd/security/HTTPData$Base64Decoder
              oracle/apps/fnd/security/HTTPData$Base64Encoder
              oracle/apps/fnd/security/HTTPData$URLDecoder
              oracle/apps/fnd/security/HTTPData$URLEncoder
              oracle/apps/fnd/security/HTTPData
              oracle/apps/fnd/security/Security
              oracle/apps/fnd/security/WebSessionManagerProc
              oracle/apps/fnd/security/crypto/CipherFactory

              JAVA_NAME
              --------------------------------------------------------------------------------
              oracle/apps/fnd/security/crypto/Crypto$Algorithm
              oracle/apps/fnd/security/crypto/Crypto$Checksum
              oracle/apps/fnd/security/crypto/Crypto$Digest
              oracle/apps/fnd/security/crypto/Crypto$Encoding
              oracle/apps/fnd/security/crypto/Crypto$Mode
              oracle/apps/fnd/security/crypto/Crypto$Pad
              oracle/apps/fnd/security/crypto/Crypto$Type
              oracle/apps/fnd/security/crypto/Crypto
              oracle/apps/fnd/security/crypto/CryptoContext
              oracle/apps/fnd/security/crypto/Decrypt
              oracle/apps/fnd/security/crypto/Encrypt

              JAVA_NAME
              --------------------------------------------------------------------------------
              oracle/apps/fnd/security/crypto/Hash
              oracle/apps/fnd/security/crypto/Sign
              oracle/apps/fnd/util/Decoder
              oracle/apps/eam/pm/meter/EqualWeightStrategy
              oracle/apps/eam/pm/meter/Meter
              oracle/apps/eam/pm/meter/UsageRateStrategy
              oracle/apps/eam/pm/scheduling/AssetPM
              oracle/apps/eam/pm/scheduling/EvaluateRulesVistor
              oracle/apps/eam/pm/scheduling/PMEngine
              oracle/apps/eam/pm/scheduling/PMNode
              oracle/apps/eam/pm/scheduling/PMNodeVistor

              JAVA_NAME
              --------------------------------------------------------------------------------
              oracle/apps/eam/pm/scheduling/PMNodesIterator
              oracle/apps/eam/pm/scheduling/PMSchedule
              oracle/apps/eam/pm/scheduling/RescheduleVistor
              oracle/apps/eam/pm/scheduling/RuntimeIntervalRule
              oracle/apps/eam/pm/scheduling/ServiceDateVistor
              oracle/apps/eam/pm/scheduling/SuppressVistor
              oracle/apps/eam/pm/scheduling/WriteTableVistor
              oracle/apps/eam/pm/util/PMLogger
              oracle/apps/eam/pm/util/RunningContext
              oracle/apps/fnd/common/AppsException
              oracle/apps/pay/proc/PayProcess

              JAVA_NAME
              --------------------------------------------------------------------------------
              oracle/apps/pay/proc/PayRunProcessGroup
              oracle/apps/pay/util/PayEnvironment
              oracle/apps/pay/util/PayMessage
              oracle/apps/pay/util/PayMessageStack
              oracle/apps/pay/util/PayMessageToken
              oracle/apps/pay/util/PayStatement
              oracle/apps/per/proxy/client/forms/Client
              oracle/apps/per/proxy/client/forms/TimerThread
              oracle/apps/per/proxy/client/forms/UrlThread
              oracle/apps/wms/cartonization/server/AssignCarton
              oracle/apps/wms/cartonization/server/Carton_line

              JAVA_NAME
              --------------------------------------------------------------------------------
              oracle/apps/wms/cartonization/server/Carton_list
              oracle/apps/wms/cartonization/server/Cartonization
              oracle/apps/wms/cartonization/server/DataClass
              oracle/apps/wms/cartonization/server/Log_utility
              oracle/apps/wms/cartonization/server/MMTT_line
              oracle/apps/wms/cartonization/server/MMTT_lines
              oracle/apps/wms/cartonization/server/wmsjavautil

              62 rows selected.

              • 4. Re: ORA-29541: class APPS.oracle/apps/fnd/security/WebSessionManagerProc
                User348186

                I followed this document too:

                • 5. Re: ORA-29541: class APPS.oracle/apps/fnd/security/WebSessionManagerProc
                  User348186

                  /11.2.0.4/db_crm2/javavm/install/sbs
                  :->perl sbs_installer.pl

                  crm2-bkup/javax/servlet
                  :->loadjava -u sys/*** -v -f -r ServletRequest.class
                  Exception in thread "main" java.lang.UnsupportedClassVersionError: Bad version number in .class file
                          at java.lang.ClassLoader.defineClass1(Native Method)
                          at java.lang.ClassLoader.defineClass(ClassLoader.java:621)
                          at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:124)
                          at java.net.URLClassLoader.defineClass(URLClassLoader.java:260)
                          at java.net.URLClassLoader.access$100(URLClassLoader.java:56)
                          at java.net.URLClassLoader$1.run(URLClassLoader.java:195)
                          at java.security.AccessController.doPrivileged(Native Method)
                          at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
                          at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
                          at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
                          at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
                          at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)

                  • 6. Re: ORA-29541: class APPS.oracle/apps/fnd/security/WebSessionManagerProc
                    Maaz Khan

                    Hi

                     

                    your loadjava did not execute successfully. Did sbs_installer.pl run successfully?

                     

                    Please share output from dB node

                     

                    $ORACLE_HOME/jdk/jre/bin/java -version

                     

                    Also let us know latest psu patch applied in your environment

                     

                     

                    regards,

                    Maaz

                    • 7. Re: ORA-29541: class APPS.oracle/apps/fnd/security/WebSessionManagerProc
                      Kanda-Oracle

                      Hi

                      Can you try to clone afresh and retest

                      Thanks!

                      • 8. Re: ORA-29541: class APPS.oracle/apps/fnd/security/WebSessionManagerProc
                        User348186

                        :->$ORACLE_HOME/jdk/jre/bin/java -version

                        java version "1.5.0_51"

                        Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_51-b10)

                        Java HotSpot(TM) Server VM (build 1.5.0_51-b10, mixed mode)

                        • 9. Re: ORA-29541: class APPS.oracle/apps/fnd/security/WebSessionManagerProc
                          User348186

                          When I ran : perl sbs_installer.pl

                          It didn't throw any error..

                          • 10. Re: ORA-29541: class APPS.oracle/apps/fnd/security/WebSessionManagerProc
                            User348186

                            :->./opatch lsinv|grep -i 'applied on'

                            Patch  29251270     : applied on Sat Jun 01 21:54:33 EDT 2019

                            Patch  29141056     : applied on Sat Jun 01 21:45:16 EDT 2019

                            • 11. Re: ORA-29541: class APPS.oracle/apps/fnd/security/WebSessionManagerProc
                              Maaz Khan

                              Hi,

                               

                              I can see you have applied April 2019 psu on you rdbms home while your jdk version is 1.5.

                               

                              We can try this as workaround, we will use java api to load this .class file-

                               

                              1. Login as sysdba (change path where you have copied and unzipped - $ORACE_HOME/rdbms/jlib/servlet.jar file)

                               

                               

                              SQL> exec dbms_java.loadjava('-user sys/<pwd> -verbose -resolve crm2-bkup/javax/servlet/ServletRequest.class');

                              SQL> commit;

                               

                              Check for invalids -

                              select DBMS_JAVA.LONGNAME(OBJECT_NAME) JAVA_NAME

                              from dba_objects

                              where object_type in ('JAVA CLASS','JAVA RESOURCE','JAVA SOURCE')

                              and status='INVALID';

                               

                              Execute utlrp -

                              @?/rdbms/admin/utlrp.sql

                               

                              Check for invalids again.

                               

                               

                              Let us know if this resolves your issue.

                               

                               

                              Regards,

                              MAaz

                              • 12. Re: ORA-29541: class APPS.oracle/apps/fnd/security/WebSessionManagerProc
                                User348186

                                As apps user::

                                SQL> alter java class "/69cdcac5_URLTools" resolve;
                                alter java class "/69cdcac5_URLTools" resolve
                                                 *
                                ERROR at line 1:
                                ORA-04043: object /69cdcac5_URLTools does not exist

                                 

                                 

                                Is there any way we can export from prod to dev instance ...

                                Don't know why some classes didn't come to Dev after clone..

                                • 13. Re: ORA-29541: class APPS.oracle/apps/fnd/security/WebSessionManagerProc
                                  User348186

                                  Why so many:after running adadmin and compile java:

                                   

                                  JAVA_NAME
                                  --------------------------------------------------------------------------------
                                  oracle/xdb/event/XDBEventDispatcher
                                  oracle/xdb/servlet/XDBServletConfig
                                  oracle/xdb/servlet/XDBServletContext
                                  oracle/xdb/servlet/XDBServletRequest$ParamNames
                                  oracle/xdb/servlet/XDBServletRequest
                                  oracle/xdb/servlet/XDBServletContainer
                                  javax/servlet/GenericServlet
                                  javax/servlet/Servlet
                                  javax/servlet/ServletConfig
                                  javax/servlet/ServletContext
                                  javax/servlet/UnavailableException


                                  javax/servlet/http/HttpServlet
                                  javax/servlet/http/HttpUtils
                                  javax/servlet/http/NoBodyOutputStream
                                  javax/servlet/http/NoBodyResponse
                                  javax/servlet/jsp/HttpJspPage
                                  javax/servlet/jsp/JspFactory
                                  javax/servlet/jsp/JspPage
                                  javax/servlet/jsp/PageContext
                                  javax/servlet/jsp/tagext/BodyTag
                                  javax/servlet/jsp/tagext/BodyTagSupport
                                  javax/servlet/jsp/tagext/Tag


                                  javax/servlet/jsp/tagext/TagSupport
                                  oracle/xdb/event/XDBBasicEventListener
                                  oracle/xdb/event/XDBRepositoryEventListener
                                  oracle/xdb/event/XDBRepositoryEvent
                                  oracle/xquery/servlet/XQServlet
                                  oracle/apps/fnd/security/AolSecurity
                                  oracle/apps/fnd/security/DataVerificationException
                                  oracle/apps/fnd/security/HTTPData$1
                                  oracle/apps/fnd/security/HTTPData$Base64Decoder
                                  oracle/apps/fnd/security/HTTPData$Base64Encoder
                                  oracle/apps/fnd/security/HTTPData$URLDecoder


                                  oracle/apps/fnd/security/HTTPData$URLEncoder
                                  oracle/apps/fnd/security/HTTPData
                                  oracle/apps/fnd/security/Security
                                  oracle/apps/fnd/security/WebSessionManagerProc
                                  oracle/apps/fnd/security/crypto/CipherFactory
                                  oracle/apps/fnd/security/crypto/Crypto$Algorithm
                                  oracle/apps/fnd/security/crypto/Crypto$Checksum
                                  oracle/apps/fnd/security/crypto/Crypto$Digest
                                  oracle/apps/fnd/security/crypto/Crypto$Encoding
                                  oracle/apps/fnd/security/crypto/Crypto$Mode
                                  oracle/apps/fnd/security/crypto/Crypto$Pad


                                  oracle/apps/fnd/security/crypto/Crypto$Type
                                  oracle/apps/fnd/security/crypto/Crypto
                                  oracle/apps/fnd/security/crypto/CryptoContext
                                  oracle/apps/fnd/security/crypto/Decrypt
                                  oracle/apps/fnd/security/crypto/Encrypt
                                  oracle/apps/fnd/security/crypto/Hash
                                  oracle/apps/fnd/security/crypto/Sign
                                  oracle/apps/fnd/util/Decoder
                                  oracle/apps/eam/pm/meter/EqualWeightStrategy
                                  oracle/apps/eam/pm/meter/Meter
                                  oracle/apps/eam/pm/meter/UsageRateStrategy


                                  oracle/apps/eam/pm/scheduling/AssetPM
                                  oracle/apps/eam/pm/scheduling/EvaluateRulesVistor
                                  oracle/apps/eam/pm/scheduling/PMEngine
                                  oracle/apps/eam/pm/scheduling/PMNode
                                  oracle/apps/eam/pm/scheduling/PMNodeVistor
                                  oracle/apps/eam/pm/scheduling/PMNodesIterator
                                  oracle/apps/eam/pm/scheduling/PMSchedule
                                  oracle/apps/eam/pm/scheduling/RescheduleVistor
                                  oracle/apps/eam/pm/scheduling/RuntimeIntervalRule
                                  oracle/apps/eam/pm/scheduling/ServiceDateVistor
                                  oracle/apps/eam/pm/scheduling/SuppressVistor


                                  oracle/apps/eam/pm/scheduling/WriteTableVistor
                                  oracle/apps/eam/pm/util/PMLogger
                                  oracle/apps/eam/pm/util/RunningContext
                                  oracle/apps/fnd/common/AppsException
                                  oracle/apps/pay/proc/PayProcess
                                  oracle/apps/pay/proc/PayRunProcessGroup
                                  oracle/apps/pay/util/PayEnvironment
                                  oracle/apps/pay/util/PayMessage
                                  oracle/apps/pay/util/PayMessageStack
                                  oracle/apps/pay/util/PayMessageToken
                                  oracle/apps/pay/util/PayStatement


                                  oracle/apps/per/proxy/client/forms/Client
                                  oracle/apps/per/proxy/client/forms/TimerThread
                                  oracle/apps/per/proxy/client/forms/UrlThread
                                  oracle/apps/wms/cartonization/server/AssignCarton
                                  oracle/apps/wms/cartonization/server/Carton_line
                                  oracle/apps/wms/cartonization/server/Carton_list
                                  oracle/apps/wms/cartonization/server/Cartonization
                                  oracle/apps/wms/cartonization/server/DataClass
                                  oracle/apps/wms/cartonization/server/Log_utility
                                  oracle/apps/wms/cartonization/server/MMTT_line
                                  oracle/apps/wms/cartonization/server/MMTT_lines


                                  oracle/apps/wms/cartonization/server/wmsjavautil

                                  89 rows selected.

                                  • 14. Re: ORA-29541: class APPS.oracle/apps/fnd/security/WebSessionManagerProc
                                    Maaz Khan

                                    Hi,

                                     

                                    Can you please confirm if you have followed below action plan as stated in my earlier post ?

                                     

                                     

                                    Hi,

                                     

                                    I can see you have applied April 2019 psu on you rdbms home while your jdk version is 1.5.

                                     

                                    We can try this as workaround, we will use java api to load this .class file-

                                    Your invalid objects will be cleared once you load ServletRequest.class correctly into database.

                                    As your jdk version is 1.5 and it is expecting jdk 1.7 to run loadjava command, you can use below workaround and let me know.

                                     

                                     

                                     

                                    1. Login as sysdba (change path where you have copied and unzipped - $ORACE_HOME/rdbms/jlib/servlet.jar file)

                                     

                                     

                                    SQL> exec dbms_java.loadjava('-user sys/<pwd> -verbose -resolve crm2-bkup/javax/servlet/ServletRequest.class');

                                    SQL> commit;

                                     

                                    Check for invalids -

                                    select DBMS_JAVA.LONGNAME(OBJECT_NAME) JAVA_NAME

                                    from dba_objects

                                    where object_type in ('JAVA CLASS','JAVA RESOURCE','JAVA SOURCE')

                                    and status='INVALID';

                                     

                                    Execute utlrp -

                                    @?/rdbms/admin/utlrp.sql

                                     

                                    Check for invalids again.

                                    1 2 Previous Next