Tuesday, 12 June 2012

FNDCPASS and sec_case_sensitive_logon | APPS Account is getting Locked Frequently


FNDCPASS and sec_case_sensitive_logon | APPS Account is getting Locked Frequently

Database password case sensitivity is a new feature available with 11g database. But as Applications tier do not support case sensitive database passwords, till then this feature cannot be used by default and set to FALSE.

As a workaround, please modify the init.ora manually and add this line:
sec_case_sensitive_logon = FALSE

If by mistake you set this to yes, your APPS Account will be locked frequently.

Cheers !!!!!!!!!!!!!!!!!!

No comments:

Post a Comment