ORA-00449 background process ‘MMON’ unexpectedly terminated with error 448

ORA-00449: background process ‘MMON’ unexpectedly terminated with error 448

Now we came to know that there is some problem with Guest user. So validate the Guest user.

Connect sqlplus with apps user and run below query.

SQL> select FND_WEB_SEC.VALIDATE_LOGIN(‘GUEST’,’ORACLE’) from dual;

FND_WEB_SEC.VALIDATE_LOGIN(‘GUEST’,’ORACLE’)
——————————————————————————–
N

Note:- The above Query should show Y but it shows N. So we need to check for the reason

SQL> select fnd_message.get from dual;

GET
——————————————————————————–
Oracle error -449: ORA-00449: background process ‘MMON’ unexpectedly terminated
with error 448 has been detected in FND_WEB_SEC.VALIDATE_LOGIN(u,p).
SQL>

Solution:-

Restart DB and Listener and apps and check for the Validation of Guest user

SQL> select FND_WEB_SEC.VALIDATE_LOGIN(‘GUEST’,’ORACLE’) from dual;
FND_WEB_SEC.VALIDATE_LOGIN(‘GUEST’,’ORACLE’)
——————————————————————————–
Y