Monday, February 3, 2020

FNDCPASS Error in password verification for APPS in R12

Issue:

[applmgr@dev ~]$ FNDCPASS apps/****** 0 Y system/******SYSTEM APPLSYS apps
Log filename : L5179008.log


Report filename : O5179008.out
[applmgr@dev ~]$ cat L5179008.log
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

 module:
+---------------------------------------------------------------------------+

Current system time is 31-JAN-2020 15:00:00

+---------------------------------------------------------------------------+

Arguments

   FNDCPASS system/***** SYSTEM APPLSYS *****
+----------------------------------------------------------------------------+
Working...
Error in password verification for APPS.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 31-JAN-2020 15:00:00

+---------------------------------------------------------------------------+

Cause:

[oracle@dev ~]$ sqlplus '/as sysdba'

SQL> show parameter case

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon             boolean     TRUE

Solution:

[oracle@dev ~]$ sqlplus '/as sysdba'

SQL> alter system set sec_case_sensitive_logon=FALSE;

System altered.

SQL> show parameter case

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon             boolean     FALSE

[applmgr@dev ~]$ FNDCPASS apps/******0 Y system/***** SYSTEM APPLSYS apps
Log filename : L5179012.log


Report filename : O5179012.out

[applmgr@dev ~]$ cat L5179012.log
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

 module:
+---------------------------------------------------------------------------+

Current system time is 31-JAN-2020 15:04:26

+---------------------------------------------------------------------------+

Arguments

   FNDCPASS system/***** SYSTEM APPLSYS *****
+----------------------------------------------------------------------------+
Working...

FNDCPASS completed successfully.

+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 31-JAN-2020 15:04:28

+---------------------------------------------------------------------------+


No comments:

Post a Comment