Tuesday, March 27, 2012

Cannot Complete Applications Logon, You May Have Entered an Invalid Applications Password

Problem :
On RAC env,

Login as System Administrator then trying to launch any forms, the following error message is shown :

"Cannot complete applications logon, you may have entered an invalid applications password, or there may have been a database connect error". Then clicking on OK button, the new error appears :

"APP-FND-01931: Your session is no longer valid or your logon information could not be reestablished from your session."

Solution :

Check the time given by "database server" for the two Database nodes . This can be obtained by sql

SQL> select to_char(sysdate,'dd/mm/yyyy hh24:mi:ss') from dual;If needed, synchronize them at OS level


Check the DB time and OS time are same. If not change the OS time to the correct value and restart the database.

I have changed TZ='UTC' to TZ='America/New_York' in .bash_profile file. After that relogin and restarted the Database on 3 nodes.

1 comment:

  1. Error:
    "Cannot complete applications logon, you may have entered an invalid applications password, or there may have been a database connect error"

    Solution:
    Sometimes some tablespaces can be full. check APPLSYSD or APPS_TS_TX_DATA.
    Extend the tablespaces.

    :)livier

    ReplyDelete