1 2 Previous Next 15 Replies Latest reply on Apr 11, 2018 1:29 PM by Eric Z-Oracle

    Is it possible to refresh Preprod without using clone?

    Jose Aróstegui

      Hi experts,

       

      We're in R12.1.3 and I was wondering if it's possible to refresh preproduction apps tier by just doing this:

       

      1) Take a backup of current context files of Pre

      2) Overwrite the shared appl top from Prod into Pre

      3) Restore Pre apps context files

      4) Run autoconfig.

       

      My question here is because in this last cloning we're experiencing a lot of problems derived from autoclone. We've already raised a SR severity 1.

       

      Thanks in advance,

      Jose.

        • 1. Re: Is it possible to refresh Preprod without using clone?
          VishnuVinnakota

          Hi,

           

          Firstly, my strong recommendation would be to refresh your apps Tier using the standard process of running adpreclone.pl appsTier on source and copy binaries and then run adcfgclone.pl on target.

           

          Is Database refreshed from PROD already?

           

          By replacing only APPL_TOP though you might succeed, there are several configuration files in APPL_TOP/admin which I am not sure how they might behave.. I would adcfgclone.pl appsTier in this case..

           

          Thanks,

          Vishnu

          • 2. Re: Is it possible to refresh Preprod without using clone?
            Magnanimous

            Hello Jose,

             

            Can you confirm if you are having issue with appl_top ? Still i would recommend to run adcfgclone on db and apps tier.

             

            Regards,

            Prashant

            • 3. Re: Is it possible to refresh Preprod without using clone?
              mdtaylor

              I have been cloning many copies of 12.1.3 as follows without running rapid clone.  I only do that when creating a new instance and there is no oraInventory.

               

              1) Clone Prod DB to Preprod with RMAN or other duplication method

              2) Overwrite the shared appl top from Prod into Pre

              3) Leave $INST_TOP alone where $CONTEXT_FILE lives, except delete from $APPLCSF/log and $APPLCSF/out

              4) Run autoconfig.

              5) Run any post clone cleanup scripts to scrub emails etc.

              1 person found this helpful
              • 4. Re: Is it possible to refresh Preprod without using clone?
                Jose Aróstegui

                Hi,
                Thanks a lot for your help guys.

                 

                To clarify our situation now:

                1) DB is already up and running. I think it's a restore from Prod, and the control file has been recreated to change database name to EBSPRE (can't give more details as it's responsibility of another department. I've run autoconfig fine in both db nodes, so I think db tier is fine by now.

                 

                2) We have a shared NFS directory named /shared_appl_tod/EBPRE, and under it it's located $APPL_TOP, $INST_TOP, $COMMON_TOP, ....

                 

                3) After cloning we're getting FRM-92050: Failed to connect to the server errors, when opening forms, due to processes frmweb die and there's this error in:

                 

                $LOG_HOME/ora/10.1.3/j2ee/forms/forms_default_group_1/application.log:

                 

                18/04/09 15:14:23.917 formsweb: 10.1.3.5.0 Started

                18/04/09 15:15:24.562 formsweb: ListenerServlet init()

                18/04/09 15:15:24.632 formsweb: Servlet error

                java.lang.UnsatisfiedLinkError: no frmjsl in java.library.path

                at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1744)

                at java.lang.Runtime.loadLibrary0(Runtime.java:823)

                at java.lang.System.loadLibrary(System.java:1026)

                at oracle.forms.servlet.RunformProcess.loadLibrary(Unknown Source)

                at oracle.forms.servlet.RunformProcess.<init>(Unknown Source)

                at oracle.forms.servlet.RunformProcess.<init>(Unknown Source)

                at oracle.forms.servlet.RunformSession.<init>(Unknown Source)

                at oracle.forms.servlet.RunformSession.get(Unknown Source)

                at oracle.forms.servlet.ListenerServlet.getRunformSession(Unknown Source)

                at oracle.forms.servlet.ListenerServlet.getInfo(Unknown Source)

                at oracle.forms.servlet.ListenerServlet.doGet(Unknown Source)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

                 

                Regards,

                Jose.

                • 5. Re: Is it possible to refresh Preprod without using clone?
                  VishnuVinnakota

                  Hi,

                   

                   

                  Once have a look at :

                   

                  FRM-92050 java.lang.UnsatisfiedLinkError: no frmjsl in java.library.path (Doc ID 438522.1)

                   

                  Also, once below also..

                   

                  Open new SSH session.

                  • Set ENV
                  • Stop Apps Tier Services
                  • Run Autoconfig on Apps Tier
                  • Start Services

                   

                  Thanks,

                  Vishnu

                  • 6. Re: Is it possible to refresh Preprod without using clone?
                    Jose Aróstegui

                    Thanks for your help Vishnu.

                     

                    Already checked that note "FRM-92050 java.lang.UnsatisfiedLinkError: no frmjsl in java.library.path (Doc ID 438522.1)", but it's not our case, as we don't have lib32 directory.

                     

                    Also, autoconfig ran several times without success.

                     

                    Regards,

                    Jose.

                    • 7. Re: Is it possible to refresh Preprod without using clone?
                      Eric Z-Oracle

                      Hi Jose,

                       

                      Try below steps.

                       

                      1) Backup 'system-jazn-data.xml' file

                      $ cp $INST_TOP/ora/10.1.3/j2ee/forms/config/system-jazn-data.xml $INST_TOP/ora/10.1.3/j2ee/forms/config/system-jazn-data.xml.ori

                      2) Edit File Containing oc4jadmin User Password

                      $ vi $INST_TOP/ora/10.1.3/j2ee/forms/config/system-jazn-data.xml

                      ========= excerpt from original file =============
                      <user>
                      <name>oc4jadmin</name>
                      <display-name>OC4J Administrator</display-name>
                      <name>oc4jadmin</name>
                      <display-name>OC4J Administrator</display-name>
                      <description>OC4J Administrator</description>
                      <credentials>{903}9VrhYTuhd7DyBJf7J/4KwbSEIlETQJOO</credentials>
                      </user>
                      ==================================================

                      ========= excerpt from file with change ==========
                      <user>
                      <name>oc4jadmin</name>
                      <display-name>OC4J Administrator</display-name>
                      <name>oc4jadmin</name>
                      <display-name>OC4J Administrator</display-name>
                      <description>OC4J Administrator</description>
                      <credentials>!welcome123</credentials>
                      </user>
                      ==================================================

                      :wq!
                      $

                      3) Source env files and shutdown all services

                      4) Run Deployment Script

                      $FND_TOP/bin/txkrun.pl -script=CfgOC4JApp
                      *** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
                      *************

                      *************

                      *************

                      Enter Application name for re-deployment ? forms
                      Enter Oc4j Instance password for re-deployment ?
                      Run Autoconfig <Yes/No> ? No


                      *****************************************************
                      Required values for starting OC4J instance "forms":
                      ====================================================
                      s_formsstatus = enabled
                      s_forms_nprocs = 1 (value should be greater than 0)


                      Existing values from the context file:
                      ======================================
                      s_formsstatus = enabled
                      s_forms_nprocs = 1
                      ----------------------------------------------

                      *** Values for context variables are VALID ***

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

                      *****************************************************

                      Stopping all OPMN processes.
                      OPMN stopped.
                      OPMN started.
                      Deplolying Application : "forms" onto OC4J instance: "forms"
                      Application deployed successfully.
                      Stopping and starting OC4J instances.
                      Started OC4J instances.
                      Binding webApp : "forms" with webmodule : "formsweb" for OC4J instance: "forms"
                      Web application bound successfully.
                      Stopping OPMN.
                      OPMN stopped.

                      Program : /*************/txkCfgOC4JApp.pl completed @ Fri Feb 9 02:44:05 2018

                      End of /*************/txkCfgOC4JApp.pl : No Errors encountered


                      5) Run autoconfig.

                      6) Start apps and validate.
                      =================================================

                       

                       

                      Let me know if it works for you.

                       

                       

                      Cheers!

                      Eric

                      • 8. Re: Is it possible to refresh Preprod without using clone?
                        Jose Aróstegui

                        Thanks a lot Eric! :-)

                         

                        Running $FND_TOP/bin/txkrun.pl -script=CfgOC4JApp I'm asked for a password. I get errors:

                        1) Entering it null

                        2) Entering !welcome123

                        3) Entering another random password:

                         

                        [applmgr@ar-pre-ebsa01 admin]$ $FND_TOP/bin/txkrun.pl -script=CfgOC4JApp 
                        *** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS 
                        *** Log File = /shared_appl_top/EBSPRE/inst/apps/EBSPRE_ar-pre-ebsa01/logs/appl/rgf/TXK/txkCfgOC4JApp_Tue_Apr_10_12_24_27_2018.log 
                        Program : /shared_appl_top/EBSPRE/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl started @ Tue Apr 10 12:24:27 2018 
                        
                        *** Log File = /shared_appl_top/EBSPRE/inst/apps/EBSPRE_ar-pre-ebsa01/logs/appl/rgf/TXK/txkCfgOC4JApp_Tue_Apr_10_12_24_27_2018.log 
                        
                        Enter Application name for re-deployment ? forms 
                        Enter Oc4j Instance password for re-deployment ? 
                        ERROR processing <arg> oc4jpass : Argument value cannot be an empty string 
                        Enter Oc4j Instance password for re-deployment ? 
                        Run Autoconfig <Yes/No> ? No 
                        
                        Errors encountered running /shared_appl_top/EBSPRE/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl 
                        
                        *******FATAL ERROR******* 
                        PROGRAM : /shared_appl_top/EBSPRE/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl(/shared_appl_top/EBSPRE/apps/apps_st/appl/fnd/12.0.0/bin/txkrun.pl) 
                        TIME : Tue Apr 10 12:24:47 2018 
                        FUNCTION: (eval) [ Level 1 ] 
                        ERRORMSG: Invalid OC4J password for : forms
                        
                        • 9. Re: Is it possible to refresh Preprod without using clone?
                          Eric Z-Oracle

                          Hi Jose,

                           

                          Sorry for not making it clear, the ! mark is a prefix.

                          You can find reference here at "H.3.1 Resetting the Administrator (oc4jadmin) Password" - https://docs.oracle.com/cd/B25221_04/core.1013/b25209/trouble_asc.htm#BCEDHFEI

                           

                          It states ---> "Be sure to prefix the password with an exclamation point (!)."

                           

                          Try without the ! and let me know if you can proceed.

                           

                          Cheers!

                          Eric

                          • 10. Re: Is it possible to refresh Preprod without using clone?
                            VishnuVinnakota

                            Lets take a different and better path I believe might work..

                             

                            • Run perl adpreclone.pl appsTier
                            • Take backup of 10.1.2 and 10.1.3
                            • Run perl adcfgclone.pl atTechStack

                             

                            This will fix (Clone) any issues only in Tech Stack (10.1.2, 10.1.3). If this is successful without any issues, there is good chance it will work fine. Even if its fails, we will know whats the issue.. Remember run "atTechStack" option only..

                             

                            Waiting for updates.

                             

                            Thanks,

                            Vishnu

                            1 person found this helpful
                            • 11. Re: Is it possible to refresh Preprod without using clone?
                              Jose Aróstegui

                              Eric, your action plan worked!

                               

                              This was provided my MOS too, but they weren't able to explain the ! important detail.

                               

                              Do you have any MOS Document Id that links our library/frmweb issue with the reset of the Administrator (oc4jadmin) in order to have some sort of justify with my customer?

                               

                              Thanks a lot to all of you guys for your help, all of you're amazing....

                              • 12. Re: Is it possible to refresh Preprod without using clone?
                                Jose Aróstegui

                                Next clone I'll bet for your method, mdtaylor for sure!

                                 

                                Thanks!

                                • 13. Re: Is it possible to refresh Preprod without using clone?
                                  Eric Z-Oracle

                                  Hi Jose,

                                   

                                  I wish we had one document for that, but we don't

                                  Maybe I can take some time to create one, but it will definitely need some effort for RCA - root cause anlaysis.

                                  I was going to say that maybe you can continue working on the SR to get a root cause, but considering you are not cloning in an 'Oracle standard way', I'm afraid it will bring some extra trouble for the engineers.

                                   

                                  Back to the steps, it's pretty much like a refresh of configurations, same as what we do for OID re-registration, for example.

                                  When we run out of alternatives, we will considering doing this.

                                   

                                  Anyway, glad that your issue got resolved,

                                   

                                  Cheers!

                                  Eric

                                  • 14. Re: Is it possible to refresh Preprod without using clone?
                                    Jose Aróstegui

                                    OK Eric, thanks a lot.

                                     

                                    Why did you say we're not cloning in a Oracle standard way?

                                    1 2 Previous Next