10 Replies Latest reply on Jun 29, 2009 2:45 PM by 405415

    FNDCPASS failed to change apps password.

    405415
      Hi,
      I have freshly installed my ebs r12 system(R 12.0.6) and i am trying to change the defailt apps password using FNDCPASS utility as below. But after changing the password. When i try to login with modified password, sqlplus is says invalid username or password.

      FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS apps001

      How can i recover my password now?

      Thanks,
      Prasad
        • 1. Re: FNDCPASS failed to change apps password.
          Hussein Sawwan-Oracle
          Prasad,

          Can you find any errors in the FNDCPASS log file?

          Did you run AutoConfig after changing the password?

          Are you able to run the same command again with the new password?

          Did you take a backup of the application/database or any tables before changing the password? If yes, restore it and check then.

          Regards,
          Hussein
          • 2. Re: FNDCPASS failed to change apps password.
            405415
            Hi Hussein,
            There is no error in FNDCPASS log file. It says,

            "Concurrent request completed successfully"

            I have not run autoconfig after changing the apps password. I just tried to connect to sqlplus as apps user after changing apps password.

            I am not able to run same command again,It gives me below error,
            APP-FND-01564: ORACLE error 1017 in AFPCOA

            Cause: AFPCOA failed due to ORA-01017: invalid username/password; logon denied


            I have taken cold backup of the database before changing the backup. I restored it and again tried but it failed again. It seems there is somthing wrong with my FNDCPASS utility.

            Thanks,
            Prasad
            • 3. Re: FNDCPASS failed to change apps password.
              Hussein Sawwan-Oracle
              Hi Prasad,
              There is no error in FNDCPASS log file. It says,

              "Concurrent request completed successfully"
              Could you please post the log file here?
              I have not run autoconfig after changing the apps password. I just tried to connect to sqlplus as apps user after changing apps password.

              I am not able to run same command again,It gives me below error,
              APP-FND-01564: ORACLE error 1017 in AFPCOA

              Cause: AFPCOA failed due to ORA-01017: invalid username/password; logon denied
              Did you try to run AutoConfig and see if it runs successfully?
              I have taken cold backup of the database before changing the backup. I restored it and again tried but it failed again. It seems there is somthing wrong with my FNDCPASS utility.
              Were you able to login using the old APPS password after restoring the database?

              Do you get the same error when trying to run FNDCPASS again?

              Regards,
              Hussein
              • 4. Re: FNDCPASS failed to change apps password.
                405415
                Hi Hussein,
                Find below the log,
                ***************************************************************************
                ---------------------------------------------------------------------------
                Application Object Library: Version : 12.0.0

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

                module:
                ---------------------------------------------------------------------------

                Current system time is 25-JUN-2009 15:02:07

                ---------------------------------------------------------------------------

                Working...


                ---------------------------------------------------------------------------
                Concurrent request completed successfully
                Current system time is 25-JUN-2009
                15:02:09

                ---------------------------------------------------------------------------
                *****************************************************************************


                I tried running autoconfig and it failed for all sql scripts.

                I was able to login using my old apps password after restoring the database and i am getting same error after running FNDCPASS.
                It seems there is something missing in my FNDCPASS. I can see FNDCPASS file size on my new setup is 6 bytes less than the file on other environment.

                Thanks,
                Prasd
                • 5. Re: FNDCPASS failed to change apps password.
                  Hussein Sawwan-Oracle
                  Hi Prasad,
                  It seems there is something missing in my FNDCPASS. I can see FNDCPASS file size on my new setup is 6 bytes less than the file on other environment.
                  Restore the database again, and relink FNDCPASS via adadmin before trying to use this tool again and changing the password.

                  Regards,
                  Hussein
                  • 6. Re: FNDCPASS failed to change apps password.
                    405415
                    Hi Hussein,
                    I tried relinking the FNDCPASS but it still not working

                    Thanks,
                    Prasad
                    • 7. Re: FNDCPASS failed to change apps password.
                      Srini Chavali-Oracle
                      Are you able to login using old APPS password ? What is your EBS version ?

                      HTH
                      Srini
                      • 8. Re: FNDCPASS failed to change apps password.
                        Hussein Sawwan-Oracle
                        Hi Prasad,
                        I tried relinking the FNDCPASS but it still not working
                        Were you able to relink the file successfully?

                        Are you able to reproduce the issue on some other instance?

                        You are running on 12.0.6, what about the database? If you are on 11g, then please review (Note: 751868.1 - FNDCPASS Fails to Change Password with 11G Database) and see if it helps.

                        Regards,
                        Hussein
                        • 9. Re: FNDCPASS failed to change apps password.
                          630481
                          Hello,

                          We faced a similar kind of situation.

                          However in Oracle 11g DB passwords are case sensitive (seems by default). So entering password in proper case helped us to resolve it.

                          Thanks,
                          • 10. Re: FNDCPASS failed to change apps password.
                            405415
                            Thank you so much Hussein your help! I we solve the issue with our enviornment. It was due to sec_case_sensitive_logon parameter set to true in our enviornment.

                            Thanks,
                            Prasad