9 Replies Latest reply on Feb 15, 2015 11:58 AM by Kumar Vellaisamy

    FNDPASS sysadmin password change facing error.

    Naseer CV

      Hi ,

       

             I am facing error in changing sysadmin password. Please see the command in detail below.

      note : FNDCPASS APPS/p@ssword 0 Y SYSTEM/Sys4test123 SYSTEM APPLSYS apps is working fine.

                but ''FNDCPASS APPS/apps 0 Y system/sys4test123 USER SYSADMIN admin4test123' having error.

      database version: 11.2.0.4

      EBS version  :  R12.1.3

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

      [appltest@erptestapp ~]$
      [appltest@erptestapp ~]$ FNDCPASS APPS/p@ssword 0 Y SYSTEM/Sys4test123 SYSTEM APPLSYS apps
      Log filename : L5552340.log


      Report filename : O5552340.out
      [appltest@erptestapp ~]$ FNDCPASS APPS/apps 0 Y system/sys4test123 USER SYSADMIN admin4test123
      APP-FND-01564: ORACLE error 1017 in AFPCOA

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

      The SQL statement being executed at the time of the error was:  and was executed from the file .
      [appltest@erptestapp ~]$

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

       

      Please help to resolve ?

       

      Thanks in Advance

      Naseer

        • 1. Re: FNDPASS sysadmin password change facing error.
          Kumar Vellaisamy

          Hi,

           

          After changing apps pwd you need to run autconfig on db tier as well as application tier.

           

          Then only it will take changes effect.

           

          Regards

          Kumar

          1 person found this helpful
          • 2. Re: FNDPASS sysadmin password change facing error.
            Kumar Vellaisamy

            Hi,

             

            Down the appliaction services.

            Change the apps pwd using FNDCPASS command

            Run autoconfig with apps new pwd in DB tier.

            Run autoconfig with apps new pwd in Appl tier.

             

            Connect the apps user with with apps new pwd and check the connection.

            It will helps u.

             

            Regards

            Kumar

            1 person found this helpful
            • 3. Re: FNDPASS sysadmin password change facing error.
              Naseer CV

              hi,

                 When i put this command

              -------------------command------------------------

               

              FNDCPASS APPS/p@ssword 0 Y SYSTEM/Sys4test123 SYSTEM APPLSYS apps

              ==============================================================================


              [appltest@erptestapp ~]$ FNDCPASS APPS/p@ssword 0 Y SYSTEM/Sys4test123 SYSTEM APPLSYS apps
              Log filename : L5552516.log


              Report filename : O5552516.out
              [[appltest@erptestapp ~]$ more L5552516.log
              +---------------------------------------------------------------------------+
              Application Object Library: Version : 12.0.0

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

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

              Current system time is 15-FEB-2015 10:56:47

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

              Working...
              SECURITY-UNABLE TO CONNECT TO SYSTEM

              +---------------------------------------------------------------------------+
              Concurrent request completed
              Current system time is 15-FEB-2015 10:56:58

              +---------------------------------------------------------------------------+
              [appltest@erptestapp ~]$
              ========================================================================================

              2. and ran auto config with new password(apps)

              ---------------------commands and outputs----------------------

              sh adautocfg.sh
              Enter the APPS user password:
              The log file for this session is located at: /oracle/app/product/11.1.0/db_1/appsutil/log/TEST_erptestdb1/02151100/adconfig.log

              AutoConfig is configuring the Database environment...

              AutoConfig will consider the custom templates if present.
                      Using ORACLE_HOME location : /oracle/app/product/11.1.0/db_1
                      Classpath                   : :/oracle/app/product/11.1.0/db_1/jdbc/lib/ojdbc5.jar:/oracle/app/product/11.1.0/db_1/appsutil/java/xmlparserv2.jar:/oracle/app/product/11.1.0/db_1/appsutil/java:/oracle/app/product/11.1.0/db_1/jlib/netcfg.jar:/oracle/app/product/11.1.0/db_1/jlib/ldapjclnt11.jar

                      Using Context file          : /oracle/app/product/11.1.0/db_1/appsutil/TEST_erptestdb1.xml

              Context Value Management will now update the Context file

                      Updating Context file...COMPLETED

                      Attempting upload of Context file and templates to database...COMPLETED

              Updating rdbms version in Context file to db112
              Updating rdbms type in Context file to 64 bits
              Configuring templates from ORACLE_HOME ...

               

              AutoConfig completed with errors.

              [oratest@erptestdb1 TEST_erptestdb1]$

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

              3. Agian rna auto config with old password itself please see

              =====================================================

              [oratest@erptestdb1 TEST_erptestdb1]$ sh adautocfg.sh
              Enter the APPS user password:
              The log file for this session is located at: /oracle/app/product/11.1.0/db_1/appsutil/log/TEST_erptestdb1/02151101/adconfig.log

              AutoConfig is configuring the Database environment...

              AutoConfig will consider the custom templates if present.
                      Using ORACLE_HOME location : /oracle/app/product/11.1.0/db_1
                      Classpath                   : :/oracle/app/product/11.1.0/db_1/jdbc/lib/ojdbc5.jar:/oracle/app/product/11.1.0/db_1/appsutil/java/xmlparserv2.jar:/oracle/app/product/11.1.0/db_1/appsutil/java:/oracle/app/product/11.1.0/db_1/jlib/netcfg.jar:/oracle/app/product/11.1.0/db_1/jlib/ldapjclnt11.jar

                      Using Context file          : /oracle/app/product/11.1.0/db_1/appsutil/TEST_erptestdb1.xml

              Context Value Management will now update the Context file

                      Updating Context file...COMPLETED

                      Attempting upload of Context file and templates to database...ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;: 1; Oracle error -1187: ORA-01187: cannot read from file  because it failed verification tests
              ORA-01110: data file 1005: '/testdata/R12/TEST/datafile/temp05.dbf' has been detected in FND_GSM_UTIL.APPEND_CTX_FRAGMENT.
              oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Error executng BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;: 1; Oracle error -1187: ORA-01187: cannot read from file  because it failed verification tests
              ORA-01110: data file 1005: '/testdata/R12/TEST/datafile/temp05.dbf' has been detected in FND_GSM_UTIL.APPEND_CTX_FRAGMENT.
                      at oracle.apps.ad.autoconfig.oam.InDbCtxFile.uploadCtx(InDbCtxFile.java:249)
                      at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.uploadToDb(CtxSynchronizer.java:328)
                      at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBCtx(FileSysDBCtxMerge.java:721)
                      at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBFiles(FileSysDBCtxMerge.java:226)
                      at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1690)
                      at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:763)
              FAILED
              COMPLETED

              Updating rdbms version in Context file to db112
              Updating rdbms type in Context file to 64 bits
              Configuring templates from ORACLE_HOME ...

              AutoConfig completed successfully.
              [oratest@erptestdb1 TEST_erptestdb1]$

              ==============================================================

               

              So this is the situation. when i ran autoconfig by  puting changed apps password autoconfig completed with error.

              when ran it with old password AutoConfig completed successfully.

              please see the above commands and output.

              so wher is the problem?

               

              with Thanks

              Naseer

              • 4. Re: FNDPASS sysadmin password change facing error.
                Kumar Vellaisamy

                Hi,

                 

                Please confirm the system user password.

                And follow the below steps for changing apps password.

                 

                Down the application services.

                Change the apps pwd using FNDCPASS command

                Run autoconfig with apps new pwd in DB tier.

                Run autoconfig with apps new pwd in Appl tier

                 

                After changing new password dont run autoconfig with old password please run with new password.

                 

                And if you are getting error while running autoconfig, please post the error

                 

                Regards

                Kumar

                1 person found this helpful
                • 5. Re: FNDPASS sysadmin password change facing error.
                  Naseer CV

                  Hi ,

                   

                         After changing the apps password , run autoconfig an dbTier.

                  Now it is working.

                  • 6. Re: FNDPASS sysadmin password change facing error.
                    Naseer CV

                    hi,

                      But after running autoconfig giving following Error

                    please see the command and output.

                    =============================================

                    [oratest@erptestdb1 TEST_erptestdb1]$ sh adautocfg.sh
                    Enter the APPS user password:
                    The log file for this session is located at: /oracle/app/product/11.1.0/db_1/appsutil/log/TEST_erptestdb1/02151154/adconfig.log

                    AutoConfig is configuring the Database environment...

                    AutoConfig will consider the custom templates if present.
                            Using ORACLE_HOME location : /oracle/app/product/11.1.0/db_1
                            Classpath                   : :/oracle/app/product/11.1.0/db_1/jdbc/lib/ojdbc5.jar:/oracle/app/product/11.1.0/db_1/appsutil/java/xmlparserv2.jar:/oracle/app/product/11.1.0/db_1/appsutil/java:/oracle/app/product/11.1.0/db_1/jlib/netcfg.jar:/oracle/app/product/11.1.0/db_1/jlib/ldapjclnt11.jar

                            Using Context file          : /oracle/app/product/11.1.0/db_1/appsutil/TEST_erptestdb1.xml

                    Context Value Management will now update the Context file

                            Updating Context file...COMPLETED

                            Attempting upload of Context file and templates to database...ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;: 1; Oracle error -1187: ORA-01187: cannot read from file  because it failed verification tests
                    ORA-01110: data file 1004: '/testdata/R12/TEST/datafile/temp04.dbf' has been detected in FND_GSM_UTIL.APPEND_CTX_FRAGMENT.
                    oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Error executng BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;: 1; Oracle error -1187: ORA-01187: cannot read from file  because it failed verification tests
                    ORA-01110: data file 1004: '/testdata/R12/TEST/datafile/temp04.dbf' has been detected in FND_GSM_UTIL.APPEND_CTX_FRAGMENT.
                            at oracle.apps.ad.autoconfig.oam.InDbCtxFile.uploadCtx(InDbCtxFile.java:249)
                            at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.uploadToDb(CtxSynchronizer.java:328)
                            at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBCtx(FileSysDBCtxMerge.java:721)
                            at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBFiles(FileSysDBCtxMerge.java:226)
                            at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1690)
                            at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:763)
                    FAILED
                    COMPLETED

                    Updating rdbms version in Context file to db112
                    Updating rdbms type in Context file to 64 bits
                    Configuring templates from ORACLE_HOME ...

                    AutoConfig completed successfully.
                    [oratest@erptestdb1 TEST_erptestdb1]$

                    =============================================

                     

                    with Thanks

                    Naseer

                    1 person found this helpful
                    • 7. Re: FNDPASS sysadmin password change facing error.
                      Kumar Vellaisamy

                      Hi,

                       

                      Check the temp tablespace and temp file.

                       

                      Create one new temp file and assign this could be a default temp tablespace and drop old one.

                       

                      It may be helps you.

                       

                      Regards

                      Kumar

                      • 8. Re: FNDPASS sysadmin password change facing error.
                        Naseer CV

                        Hi Dear Kumar ,

                         

                                             Now it is working  fine on DB tier and apps tier . ie AutoConfig completed successfully.

                         

                         

                        With Lot of thanks

                        Naseer

                        • 9. Re: FNDPASS sysadmin password change facing error.
                          Kumar Vellaisamy

                          Hi,

                           

                          Nice to hear the issue resolved.

                           

                          Regards

                          Kumar