14 Replies Latest reply on Feb 22, 2016 7:13 PM by 3028718

    De-register a custom schema in 12.2.4

    user10088255

      Hi all,

       

      DB: 11.2.0.4 upgraded from 11.2.0.3

      EBS: 12.2.4 upgraded from 12.1.3

      O/S: RHEL x86x64 v6

       

      Could anyone please let me know if the following steps are applicable to -De-register a custom schema in 12.2.4? Is this a Tested Approach?

       

      • Log on the Alert Manager responsibility and go to menu System/Installations , then delete the line related to your custom schema.

      • Log on the System Administrator responsibility , menu Security/Oracle/Register then delete the line related to your custom schema.

      • Remove the relevant entry from the FND_OAM_CONTEXT_CUSTOM table and run AutoConfig on all nodes ( DB + Applications nodes).

      Please let me know your inputs/comments as we need to de-register a CUSTOM schema ' XXXN' in 12.2.4.

       

      Thanks for your time and help!

       

      Regards,

        • 1. Re: De-register a custom schema in 12.2.4
          Narsi M-Oracle

          Hello,

           

          Please review below:

          Oracle E-Business Suite Applications DBA and Technology Stack Release Notes for R12.AD.C.Delta.6 and R12.TXK.C.Delta.6 (Doc ID 1983782.1)

          4.6 Ability to de-register a custom application

           

          Please mark the discussion as Helpful/Answered, so it would be helpful to others in communities.

           

           

          Regards,

          Narsi

          • 2. Re: De-register a custom schema in 12.2.4
            3028718

            Hi Narsi,

             

            Thanks for your time on sharing the information. You reply is helpful.

             

            Have reviewed Oracle E-Business Suite Applications DBA and Technology Stack Release Notes for R12.AD.C.Delta.6 and R12.TXK.C.Delta.6 (Doc ID 1983782.1)
            4.6 Ability to de-register a custom application

             

            I have few below questions and would appreciate if you could please help reply.

             

            QUESTIONS

             

            STEP 1 ) To remove CUSTOM schema, as per Oracle's recommendation, run this script $AD_TOP/bin/adDeregisterCustomProd.pl as per Doc ID 2085355.1 & 1983782.1
            STEP 2 ) Next, do we need to drop the custom schema XXXN manually again by executing the below command after the step 1 above has been performed? ( YES/NO )?

                     DROP USER 'XXXT';

            Any additional step that needs to be performed apart from the above steps or does the above steps removes CUSTOM schema clean from the system?

             

            Please reply to our above questions so that we can analyze and form an Action Plan to proceed.

             

            Thanks,

            • 3. Re: De-register a custom schema in 12.2.4
              3028718

              Hi Narsi,

               

              Thanks for your time on sharing the information. You reply is helpful.

               

              Have reviewed Oracle E-Business Suite Applications DBA and Technology Stack Release Notes for R12.AD.C.Delta.6 and R12.TXK.C.Delta.6 (Doc ID 1983782.1)
              4.6 Ability to de-register a custom application

               

              I have few below questions and would appreciate if you could please help reply.

               

              QUESTIONS

               

              STEP 1 ) To remove CUSTOM schema, as per Oracle's recommendation, run this script $AD_TOP/bin/adDeregisterCustomProd.pl as per Doc ID 2085355.1
                        NOTES:
              # |  - The script adDeregisterCustomProd.pl will be run on run edition.
              # |  - Tables fnd_application, fnd_application_tl, fnd_oracle_userid,
              # |    fnd_product_installations,fnd_oam_context_custom are updated.


              STEP 2 ) Do we need to run Autoconfig on DB and Applications Nodes after STEP 1 is performed? ( YES/NO )?

              Any additional step that needs to be performed apart from the above steps or does the above steps removes CUSTOM schema clean from the system?

               

              Please reply to our above questions so that we can analyze and form an Action Plan to proceed.

               

              Thanks, 

              • 4. Re: De-register a custom schema in 12.2.4
                Narsi M-Oracle

                Hello,

                 

                I don't remember if the custom schema will also be deleted.

                If the script doesn't delete the custom schema, then you can remove it as per your need.

                 

                1) AutoConfig will be automatically run as a part of the deregister command

                 

                Below is an example:

                 

                [applmgr@narsi admin]$ cd $AD_TOP/bin

                [applmgr@narsi bin]$ ls -l *register*

                -rwxr-xr-x 1 applmgr dba 3193 Nov 12 11:51 adDeregisterCustomProd.pl

                [applmgr@narsi bin]$ perl adDeregisterCustomProd.pl

                Enter the APPS username: apps

                Enter the APPS Password:

                Enter the Custom Application to De-Register: NARSI

                Enter the Application Id to De-Register: 50301

                Script adjava oracle.apps.ad.splice.adCustProdSplicer mode=uninstall

                options=inputpair logfile=customderegister.log

                Copyright (c) 2002, 2012 Oracle Corporation

                Redwood Shores, California, USA

                AD Java

                Version 12.2.0

                NOTE: You may not use this utility for custom development

                unless you have written permission from Oracle Corporation.

                Reading product information from file...

                Reading language and territory information from file...

                Reading language information from applUS.txt ...

                Temporarily resetting CLASSPATH to:

                "/u01/apps/fs2/EBSapps/appl/ad/12.0.0/java/adjava.zip:/u01/apps/fs2/EBSapps/comn/

                util/jdk32/lib/dt.jar:/u01/apps/fs2/EBSapps/comn/util/jdk32/lib/tools.jar:/u01/apps/fs2/

                EBSapps/comn/util/jdk32/jre/lib/rt.jar:/u01/apps/fs2/EBSapps/comn/shared-libs/

                ebs-3rdparty/WEB-INF/lib/ebs3rdpartyManifest.jar:/u01/apps/fs2/FMW_Home/

                Oracle_EBS-app1/shared-libs/ebs-fmw/WEB-INF/lib/ebsFMWManifest.jar:/u01/apps/

                fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/

                ebsAppsborgManifest.jar:/u01/apps/fs2/FMW_Home/oracle_common/modules/

                oracle.uix_11.1.1/uix2.jar:/u01/apps/fs2/EBSapps/comn/java/classes:/u01/apps/fs2/

                EBSapps/10.1.2/forms/java:/u01/apps/fs2/EBSapps/10.1.2/forms/java/frmall.jar:/u01/

                apps/fs2/EBSapps/10.1.2/jlib/ewt3.jar:/u01/apps/fs2/EBSapps/10.1.2/j2ee/

                OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar"

                Calling /u01/apps/fs2/EBSapps/comn/util/jdk32/jre/bin/java ...

                Copyright (c) 2002,2014 Oracle Corporation

                Redwood Shores, California, USA

                Oracle Applications AD Custom Product Splicer

                Version 12.0.0

                Database connect string : (DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)

                (FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=narsi.apps.com)

                (PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=TEST)))

                APPS schema name : apps

                Password for APPS schema : *********

                Short abbreviation of the product (Max. 8 chars) : NARSI

                Application ID of the product : 50301

                Performing Validations for De-Register

                Validation for Edition Successful..

                All Validations Successfull ..

                ApplicationID 50301 deleted from FND_APPLICATION

                ApplicationID 50301 deleted from FND_APPLICATION_TL

                Status and DB_Status columns updated in FND_PRODUCT_INSTALLATIONS Table

                Status column updated in FND_ORACLE_USERID Table

                Entry for NARSI is removed from FND_OAM_CONTEXT_CUSTOM

                Entry for NARSI is removed from AD_ADOP_SESSION_PATCHES

                Directory 'NARSI' doesnot exist

                <oa_customized> block is removed succesfully ..!

                NARSI entry in topfile.txt is removed succesfully ..!

                Command : perl /u01/apps/fs2/EBSapps/appl/ad/12.0.0/bin/adconfig.pl contextfile=/u01/

                apps/fs2/inst/apps/TEST_narsi/appl/admin/TEST_narsi.xml log=/u01/apps/fs2/

                EBSapps/appl/admin/TEST/log/autoconfig_1.log promptmsg=hide -noprompt -

                noversionchecks

                The log file for this session is located at: /u01/apps/fs2/EBSapps/appl/admin/TEST/log/

                autoconfig_1.log

                AutoConfig is configuring the Applications environment...

                AutoConfig will consider the custom templates if present.

                Using CONFIG_HOME location : /u01/apps/fs2/inst/apps/TEST_narsi

                Classpath : /u01/apps/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/

                ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/apps/fs2/EBSapps/comn/

                java/classes

                Using Context file : /u01/apps/fs2/inst/apps/TEST_narsi/appl/admin/

                TEST_narsi.xml

                Context Value Management will now update the Context file

                Updating Context file...COMPLETED

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

                Configuring templates from all of the product tops...

                Configuring AD_TOP........COMPLETED

                Configuring FND_TOP.......COMPLETED

                Configuring ICX_TOP.......COMPLETED

                Configuring MSC_TOP.......COMPLETED

                Configuring IEO_TOP.......COMPLETED

                Configuring BIS_TOP.......COMPLETED

                Configuring CZ_TOP........COMPLETED

                Configuring AMS_TOP.......COMPLETED

                Configuring CCT_TOP.......COMPLETED

                Configuring WSH_TOP.......COMPLETED

                Configuring CLN_TOP.......COMPLETED

                Configuring OKE_TOP.......COMPLETED

                Configuring OKL_TOP.......COMPLETED

                Configuring OKS_TOP.......COMPLETED

                Configuring CSF_TOP.......COMPLETED

                Configuring IBY_TOP.......COMPLETED

                Configuring JTF_TOP.......COMPLETED

                Configuring MWA_TOP.......COMPLETED

                Configuring CN_TOP........COMPLETED

                Configuring CSI_TOP.......COMPLETED

                Configuring WIP_TOP.......COMPLETED

                Configuring CSE_TOP.......COMPLETED

                Configuring EAM_TOP.......COMPLETED

                Configuring GMF_TOP.......COMPLETED

                Configuring PON_TOP.......COMPLETED

                Configuring FTE_TOP.......COMPLETED

                Configuring ONT_TOP.......COMPLETED

                Configuring AR_TOP........COMPLETED

                Configuring AHL_TOP.......COMPLETED

                Configuring IES_TOP.......COMPLETED

                Configuring OZF_TOP.......COMPLETED

                Configuring CSD_TOP.......COMPLETED

                Configuring IGC_TOP.......COMPLETED

                AutoConfig completed successfully.

                AD Custom Product Splicer is returning successfully.

                Please see the below logfile for more details.

                The logfile is :

                /u01/apps/fs2/EBSapps/appl/admin/TEST/log/customderegister.log

                Custom product NARSI is De-Registed Successfully ..

                [applmgr@narsi bin]$

                 

                 

                Regards,

                Narsi

                • 5. Re: De-register a custom schema in 12.2.4
                  3028718

                  Thanks Narsi for the working example and it's helpful.

                   

                  Recently, we had executed the script 'adDeregisterCustomProd.pl' and dropped the Custom schema XXXN, thereafter, we ran adop phase=prepare to apply patches and  we ran into below errors:

                   

                  Errror:

                   

                  AutoPatch - aidafoGetFileDbVersion: INFO: ORA-01403: no data found

                  AutoPatch error:

                   

                  Unable to get APPS_DDL package version from db <XXXN> <APPS_DDL> <PACKAGE>

                  AutoPatch error:
                  adpmrp: Error while installing apps_ddl packages.

                   

                  We are not able to apply apply any patches into the system.

                   

                  Please advise.

                   

                  Thanks,

                  • 6. Re: De-register a custom schema in 12.2.4
                    Bashar.

                    Make sure that the custom user no longer exists in fnd_oracle_userid table after you drop the schema.

                     

                    Regards,

                    Bashar

                    • 7. Re: De-register a custom schema in 12.2.4
                      3028718

                      Thanks Bashar.

                       

                      Please also review and let me know why we can't  execute the previous steps as mentioned in this post.

                       

                      • Log on the Alert Manager responsibility and go to menu System/Installations , then delete the line related to your custom schema.

                      • Log on the System Administrator responsibility , menu Security/Oracle/Register then delete the line related to your custom schema.

                      • Remove the relevant entry from the FND_OAM_CONTEXT_CUSTOM table and run AutoConfig on all nodes ( DB + Applications nodes).

                       

                      Thanks,

                      • 8. Re: De-register a custom schema in 12.2.4
                        Bashar.

                        What do you mean by "we can't"?

                        Are you able to do the navigations?

                        Do you encounter any errors?

                         

                        Regards,

                        Bashar

                        • 9. Re: De-register a custom schema in 12.2.4
                          3028718

                          Hi Bhaskar/Narsi,

                           

                          Yes. We are able to Navigate.Please let me rephrase my question.

                           

                          Can we execute the following steps to remove Custom schema in 12.2.4.

                           

                          • Log on the Alert Manager responsibility and go to menu System/Installations , then delete the line related to your custom schema.

                          • Log on the System Administrator responsibility , menu Security/Oracle/Register then delete the line related to your custom schema.

                          • Remove the relevant entry from the FND_OAM_CONTEXT_CUSTOM table and run AutoConfig on all nodes ( DB + Applications nodes).

                           

                          Thanks,

                          • 10. Re: De-register a custom schema in 12.2.4
                            Bashar.

                            If you got these steps from an MOS document then you can perform them after running the deregister script mentioned earlier.

                             

                            Regards,

                            Bashar

                            • 11. Re: De-register a custom schema in 12.2.4
                              Narsi M-Oracle

                              Hello,

                               

                              Additional to Bashar's update, as per the error you've received in adop phase=prepare,

                               

                              Errror:

                              AutoPatch - aidafoGetFileDbVersion: INFO: ORA-01403: no data found

                              AutoPatch error:

                               

                              Unable to get APPS_DDL package version from db <XXXN> <APPS_DDL> <PACKAGE>

                              AutoPatch error:
                              adpmrp: Error while installing apps_ddl packages.

                               

                               

                              Looks like some objects in XXXN Schema might be the culprit causing the adop phase=prepare to fail.

                               

                               

                              Regards,

                              Narsi

                              • 12. Re: De-register a custom schema in 12.2.4
                                3028718

                                Thanks Bashar.

                                 

                                You are right Narsi. So, do we drop these objects and restart adop phase=prepare.

                                 

                                Thanks,

                                • 13. Re: De-register a custom schema in 12.2.4
                                  Narsi M-Oracle

                                  Hello,

                                   

                                  Please confirm if the issue is resolved.

                                  Are you able to run adop phase=prepare successfully now ?

                                   

                                  Regards,

                                  Narsi

                                  • 14. Re: De-register a custom schema in 12.2.4
                                    3028718

                                    Hi Narsi,

                                     

                                    Thanks for checking. I need to retry and drop the objects from Custom schema XXXN and let you know if adop prepare  phase goes through.

                                     

                                    Thanks,