FNCCPASS报错

7. FNDCPASS Fails With 'ORA-01017: invalidusername/password; logon denied

 

Upgraded to Applications release 12.0 anddatabase from 10.2.0.2 to 11.1.0.6

The database SEC_CASE_SENSITIVE_LOGON parameter defaults to TRUE.When this occurs the password sensitivity conversion does notoccur. Passwords that are input as lower case are automaticallyupdated as upper case.

To implement the solution, execute the followingsteps:

1. For Applications 11i with database 11g, Patch 6372396 is needed which is included in11i.ATG_PF.H.RUP.7 (Patch 6241631).

WORKAROUND

1. Set the database SEC_CASE_SENSITIVE_LOGON parameter to FALSE inthe init.ora.

2. Run autoconfig on the application tiers and bounce thedatabase.