2 Replies Latest reply on Aug 2, 2011 10:35 AM by user11120796

    Unable to Login R1213 URL - Error - Login failed. Please verify your login

    user11120796
      Hi,

      Recently we upgraded from 11i to R1213 on Linux 64bit,

      Due to some issue we regularly receving 500 Internal Server Error, raised SR with Oracle, they thought it may be issue with GUEST user password and provided below mentioned acionpla

      =========
      1. Reset GUEST password:

      SQL> exec fnd_vault.del('FND');
      SQL> commit;
      SQL> select FND_WEB_SEC.CHANGE_GUEST_PASSWORD ('APPLMGR12','<applsyspassword>') from dual;
      SQL> commit;

      2. Test if Profile Updated or not?

      DECLARE
      stat boolean;
      BEGIN
      dbms_output.disable;
      dbms_output.enable(100000);
      stat := FND_PROFILE.SAVE('GUEST_USER_PWD','GUEST/APPLMGR12','SITE');
      IF stat THEN
      dbms_output.put_line( 'Stat = TRUE - profile updated' );
      ELSE
      dbms_output.put_line( 'Stat = FALSE - profile NOT updated' );
      END IF;
      end;
      /

      3. Change GUEST user password, FNDCPASS should not be used. It will result in error

      "FNDCPASS was not able to decrypt password for user 'GUEST' during applsys"

      Use following API:
      java oracle.apps.fnd.security.AdminAppServer APPS/<APPS Password> UPDATE
      GUEST_USER_PWD=GUEST/<Guest User Password> DB_HOST= <Host_Name> DB_PORT=<PortNumber>
      DB_NAME=<SID>

      4. Check the log of FNDCPASS for any error for GUEST user if there is no error for GUEST user then do the next step
      5. > cd $FND_TOP/patch/115/bin
      ojspCompile.pl compile flush
      6. Set GUEST_USER_PWD password in $FND_SECURE/<sid>.dbc to GUEST/APPLMGR12

      7. Correct End_Date of GUEST user & its responsibilities by direct launch of FORMS as explained in Note 552301 1 How To Prevent Users From Accessing Forms Directly In Oracle Applications R12

      8. Correct the Roles by Workflow Directory Services User/Role Validation" with Parameters:
      Fix Dangling User/Roles=Yes
      Add Missing User/Role Assignments=Yes

      9. Bounce Middle Tier Services
      10. Retest the issue.
      ===============

      reverted the password backto ORACLE,ran autoconfig, all tests related to GUEST user shows OK.

      When trying login URL using SYSADMIN, it throws below error, nothing is working now, and Oracle still unable to find what is cause
      ===============
      Error
      Login failed. Please verify your login information or contact the system administrator.
      ===============

      Regards,
      Bhargava
        • 1. Re: Unable to Login R1213 URL - Error - Login failed. Please verify your login
          Hussein Sawwan-Oracle
          Recently we upgraded from 11i to R1213 on Linux 64bit,
          I assume that the upgrade was completed successfully with no errors.
          Due to some issue we regularly receving 500 Internal Server Error, raised SR with Oracle, they thought it may be issue with GUEST user password and provided below mentioned acionpla
          Please check Apache log file for details about the error.
          When trying login URL using SYSADMIN, it throws below error, nothing is working now, and Oracle still unable to find what is cause
          ===============
          Error
          Login failed. Please verify your login information or contact the system administrator.
          ===============
          Did AutoConfig complete successfully?

          Can you reproduce the issue with other application users?

          Can you find any errors in the database log file?

          What is the status of the SYSADMIN user? Please make sure that the user is active (not end-dated) and the password is correct.

          Please review these docs.

          The Existing User Login failed error After Assign Any Responsiblity [ID 1127799.1]
          Unable to Login to Application After Cloning to A New Node [ID 1102253.1]
          Http 500 : Internal Server Error When Login To A New Cloned Environment [ID 781413.1]
          R12: Troubleshooting 500 Internal Server Error in Oracle E-Business suite [ID 813523.1]
          500 Internal Server Error - java.lang.NoClassDefFoundError on Login [ID 761869.1]
          Login Fails After Changing The 'GUEST' Password To Either Mixed / Lowercase In R12 [ID 602425.1]
          Blank Page Accessing R12 - Application.log shows "html: chain failed", "Could not initialize class oracle.apps.fnd.common.Guest" [ID 1197917.1]

          Thanks,
          Hussein
          • 2. Re: Unable to Login R1213 URL - Error - Login failed. Please verify your login
            user11120796
            Hi,

            Thnaks for help,

            issue resolved after regeneration jar files from adadmin with force

            Regards,
            Bhargava