5 Replies Latest reply: Jun 14, 2012 10:36 AM by Hussein Sawwan-Oracle RSS

    Error when running adpatch

    934200
      Hi,
      I am doing upgradation from 11i to 12.1.1. Database is upgraded to 11.1.0.7. Now when applying a patch on application side. I am getting error as below:

      AD Administration is verifying your username/password.
      The status of various features in this run of AD Administration is:

      <-Feature version in->
      Feature Active? APPLTOP Data model Flags
      ------------------------------ ------- -------- ----------- -----------
      CHECKFILE Yes 1 1 Y N N Y N Y
      PREREQ Yes 6 6 Y N N Y N Y
      CONCURRENT_SESSIONS No 2 2 Y Y N Y Y N
      PATCH_TIMING Yes 2 2 Y N N Y N Y
      PATCH_HIST_IN_DB Yes 6 6 Y N N Y N Y
      SCHEMA_SWAP Yes 1 1 Y N N Y Y Y
      JAVA_WORKER No 1 -1 Y N N Y N N
      CODELEVEL No 1 -1 Y N N Y N N



      Identifier for the current session is 26939

      Reading product information from file...

      Reading language and territory information from file...

      Reading language information from applUS.txt ...

      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/eaaprod.txt
      does not exist for product "eaa".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/abmprod.txt
      does not exist for product "abm".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/evmprod.txt
      does not exist for product "evm".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/ipdprod.txt
      does not exist for product "ipd".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/zfaprod.txt
      does not exist for product "zfa".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/zsaprod.txt
      does not exist for product "zsa".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/cssprod.txt
      does not exist for product "css".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/meprod.txt
      does not exist for product "me".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/xnmprod.txt
      does not exist for product "xnm".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/xncprod.txt
      does not exist for product "xnc".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/xnsprod.txt
      does not exist for product "xns".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/fptprod.txt
      does not exist for product "fpt".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/okrprod.txt
      does not exist for product "okr".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/cueprod.txt
      does not exist for product "cue".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/ibaprod.txt
      does not exist for product "iba".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/ozpprod.txt
      does not exist for product "ozp".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/ozsprod.txt
      does not exist for product "ozs".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/rhxprod.txt
      does not exist for product "rhx".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/rlaprod.txt
      does not exist for product "rla".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/vehprod.txt
      does not exist for product "veh".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/imtprod.txt
      does not exist for product "imt".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/ahmprod.txt
      does not exist for product "ahm".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/okbprod.txt
      does not exist for product "okb".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/okoprod.txt
      does not exist for product "oko".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/xniprod.txt
      does not exist for product "xni".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/jtsprod.txt
      does not exist for product "jts".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/amfprod.txt
      does not exist for product "amf".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      AD Administration warning:
      Product Data File
      /d01/prod32/apps/apps_st/appl/admin/cunprod.txt
      does not exist for product "cun".
      This product is registered in the database but the
      above file does not exist in APPL_TOP. The product
      will be ignored without error.


      Reading database to see what industry is currently installed.

      Reading FND_LANGUAGES to see what is currently installed.
      Currently, the following language is installed:

      Code Language Status
      ---- --------------------------------------- ---------
      US American English Base

      Your base language will be AMERICAN.

      Setting up module information.
      Reading database for information about the modules.
      Saving module information.
      Reading database for information about the products.
      Reading database for information about how products depend on each other.
      Reading topfile.txt ...

      Saving product information.

      The Applications System names per the APPL_TOP and the database
      are different.
      Applications System name per the APPL_TOP: PROD
      Applications System name per the database: prod

      If you continue, the Applications System name per the APPL_TOP will
      be ignored.


      Do you wish to continue [No] ?

      You should check the file
      /d01/prod32/apps/apps_st/appl/admin/PROD/log/adadmin.log

      for errors.
        • 1. Re: Error when running adpatch
          934200
          Now I am going to implement autoconfig on the db side. I was about to apply the latest Autoconfig template patch. Before that i was running adadmin to enable the maintenance mode. I am getting the above error.
          • 2. Re: Error when running adpatch
            Hussein Sawwan-Oracle
            AD Administration warning:
            Product Data File
            /d01/prod32/apps/apps_st/appl/admin/eaaprod.txt
            does not exist for product "eaa".
            This product is registered in the database but the
            above file does not exist in APPL_TOP. The product
            will be ignored without error.
            Oracle Applications DBA Minipack R12.AD.A [ID 401424.1]
            Product Data File Error Applying Patch 4440000 [ID 421136.1]
            The Applications System names per the APPL_TOP and the database
            are different.
            Applications System name per the APPL_TOP: PROD
            Applications System name per the database: prod

            If you continue, the Applications System name per the APPL_TOP will
            be ignored.


            Do you wish to continue [No] ?

            You should check the file
            /d01/prod32/apps/apps_st/appl/admin/PROD/log/adadmin.log

            for errors.
            Adpatch Fails : 'The Applications System names per the APPL_TOP and the database are different.' [ID 213339.1]
            Unable to Patch a Cloned Environment Because of Wrong Applications System Names [ID 202483.1]

            Thanks,
            Hussein
            • 3. Re: Error when running adpatch
              934200
              Hi,
              Thnx for help. solved the above problem by updating the APPLICATIONS_SYSTEM_NAME in FND_PRODUCT_GROUPS table to the SID name. but I one thing i didn't understand I am upgrading from 11.5.10.2 to 12.1.1.
              The process which I followed is
              source: 11.5.10.2
              destination 12.1.1(installed with upgrade option)
              1)I have dbf files installed with 11.5.10.2, the same db 9.2.0.6 was upgraded to 10.2.0.4
              then 11.1.0.7.
              2) Now completed the database upgrade, autoconfig has yet to be implemented.
              3) When I installed the Apps 12.1.1 with upgrade option. It doesn't create dbf files ie.
              apps_st directory.
              4). Now I have started 11.1.0.7 db and was applying the latest autoconfig patch with the application user that owned 12.1.1 apps with upgrade option. but current release it is showing as 11.5.10.2 instead of 12.1.1
              and when I ran adpatch it gives different versions in APPL_TOP and DATA model and the following error

              The status of various features in this run of AutoPatch is:

              <-Feature version in->
              Feature Active? APPLTOP Data model Flags
              ------------------------------ ------- -------- ----------- -----------
              CHECKFILE Yes 1 1 Y N N Y N Y
              PREREQ Yes 6 6 Y N N Y N Y
              CONCURRENT_SESSIONS No 2 2 Y Y N Y Y N
              PATCH_TIMING Yes 2 2 Y N N Y N Y
              PATCH_HIST_IN_DB Yes 6 6 Y N N Y N Y
              SCHEMA_SWAP Yes 1 1 Y N N Y Y Y
              JAVA_WORKER                      No         1          -1            Y N N Y N N
              CODELEVEL                           No         1          -1            Y N N Y N N




              STRT_TASK: [Other driver and release-related logic] [] [Thu Jun 14 2012 13:05:20]


              AutoPatch error:
              adprdf(): At line 3 in file u8919489.drv:

              This patch cannot be applied to your current release.


              Patch's intended release is "12.0.0"
              Your current release is "11.5.10.2"

              Freeing includes hash table
              Freeing fixes hash table
              Freeing basedons hash table
              Freeing entities hash table

              You should check the file
              /d01/prod32/apps/apps_st/appl/admin/PROD/log/8919489_test.log

              for errors.

              Edited by: Abbu on Jun 14, 2012 8:50 PM
              • 4. Re: Error when running adpatch
                943609
                The Applications System names per the APPL_TOP and the database
                are different.
                Applications System name per the APPL_TOP: PROD
                Applications System name per the database: prod


                One option is the use the Create/update snapshot in adadmin by giving the value yes when you run adadmin.
                Else you could try to installl the Upgrade filesystem once again with the same sid and "prod". All i see is just a CASE difference.
                • 5. Re: Error when running adpatch
                  Hussein Sawwan-Oracle
                  This patch cannot be applied to your current release
                  Please see (Why Do Some Patches Error Reporting 11i Environment During R12 Upgrade? [ID 1276074.1]).

                  Thanks,
                  Hussein