Application server boot up error - GenMessageBox(0, 0, M): Database Signon: Could not sign on to database XXXX with user PS

If you get following set of error then follow these steps to fix the issue



PSADMIN.3628 (0) [2016-11-15T14:07:00.998](0) Begin boot attempt on domain xxxxx
PSAPPSRV.4888 (0) [2016-11-15T14:07:12.167](0) PeopleTools Release 8.54.X (Windows) starting. Tuxedo server is APPSRV(99)/2
PSAPPSRV.4888 (0) [2016-11-15T14:07:12.167](3) Detected time zone is Eastern Standard Time
PSAPPSRV.4888 (0) [2016-11-15T14:07:12.277](0) Cache Directory being used: d:\xxxx\appserv\xxxx\CACHE\PSAPPSRV_2\
PSAPPSRV.4888 (0) [2016-11-15T14:07:12.370](3) File: SQL Access ManagerSQL error. Stmt #: 1  Error Position: 0  Return: -1 -
PSAPPSRV.4888 (0) [2016-11-15T14:07:12.370](1) GenMessageBox(200, 0, M): SQL Access Manager: File: SQL Access ManagerSQL error. Stmt #: 1  Error Position: 0  Return: -1 -
PSAPPSRV.4888 (0) [2016-11-15T14:07:12.370](0) Database Options: override_connection_reset: 0
PSAPPSRV.4888 (0) [2016-11-15T14:07:12.370](1) GenMessageBox(0, 0, M): Database Signon: Could not sign on to database XXXX with user PS.
PSAPPSRV.4888 (0) [2016-11-15T14:07:12.386](0) Server failed to start
PSADMIN.3628 (0) [2016-11-15T14:07:19.765](0) End boot attempt on domain xxxxx


Solution :


This is very common error and solution for basic checks is available on support and you can easily find in internet.
I am posting this because the regular way to fix this did not work and later I found Oracle doc Id 1621660.1 which has similar details to fix the issue. So this is known issue and is caused by using the same database for different tools patch version. Basically after applying patch on PSHOME the encryption algorithm of passwords gets changed and so the new tools patch unable to use the existing encrypted passwords. Solution is to reset and encrypt access id and password. After that encrypt all application ids. Let me know if it helps you too.