APP-FND-01516L Invalid application username, password, or database

Error:

APP-FND-01516L Invalid application username, password, or database

Username: APPLSYSPUB
Database: VIS




Solution:

Check the alter log file of the database for below error:

ORA-00020: maximum number of processes 0 exceeded
ORA-20 errors will not be written to the alert log for
 the next minute. Please look at trace files to see all
 the ORA-20 errors.

Shutdown the application and database

edit the init parameter file by increasing the parameter processes and sessions, then start the database with the edited init prameter file and start the application

E-Business Autoconfig Issues/Autoconfig Issues seen after a Patch, Clone, Migration or Installation

While doing the cloning of Oracle Application and after that  run auto config, then getting the  following error occurs. 

ERROR ----------------------- ERROR at line 1: ORA-04091: table APPLSYS.FND_PROFILE_OPTION_VALUES is mutating, trigger/function may not see it ORA-06512: at "APPS.FND_CORE_LOG", line 45 ORA-06512: at "APPS.FND_CORE_LOG", line 456 ORA-06512: at "APPS.FND_PROFILE", line 110 ORA-06512: at "APPS.ALR_FND_PROFILE_OPTIO_0_84_UAR", line 2 ORA-04088: error during execution of trigger 'APPS.ALR_FND_PROFILE_OPTIO_0_84_UAR' ORA-06512: at line 43 ORA-06512: at line 123  Error Codes --------------------------------------------------- ORA-04091,ORA-06512,ORA-04088 Solution: Run the below query and check triggers status: SELECT * FROM DBA_TRIGGERS WHERE TABLE_NAME = 'FND_PROFILE_OPTION_VALUES' AND TABLE_OWNER = 'APPLSYS'; If below trigger status enable then I suggested to disable the triggers and retest the issue. ALR_FND_PROFILE_OPTIO_0_84_UAR ALR_FND_PROFILE_OPTIO_0_84_IAR -----------------------