7 Replies Latest reply on Apr 10, 2013 6:46 AM by Hussein Sawwan-Oracle

    EBS 12.1.3: a few questions about cloning

    user593399
      Hi,

      We have EBS 12.1.3 on AIX 7.1.

      A few questions about cloning from shared application tier environment to non-shared application tier environment. We have been following "Cloning Oracle Applications Release 12 with Rapid Clone [ID 406982.1]"

      Source environment (shared app tier):
      - Two active application nodes and LB
      - One active database and one passive database setup with Oracle Data Guard.
      - SSL termination at the load balancer
      - PCP implemented

      Target environment (non-shared app tier):
      - One active application node
      - One active database node
      - No SSL
      - No PCP

      After the cloning was completed we noticed the following problems in the target system:

      1) Home page cannot be accessed as application tier $CONTEXT_FILE still contains "https" and ssl termination settings.

      Workaround:

      Modify (with text editor) Application Tier $CONTEXT_FILE as follows.
      <webentryurlprotocol oa_var="s_webentryurlprotocol" customized="yes">http</webentryurlprotocol>
      <sslterminator oa_var="s_enable_sslterminator">#</sslterminator>
      <login_page oa_var="s_login_page" customized="yes">http://myhost.mydomain.com:8000/OA_HTML/AppsLogin</login_page>
      <externURL oa_var="s_external_url" customized="yes">http://myhost.mydomain.com:8000</externURL>

      Run AutoConfig and start application tier.

      Is there a better and supported solution for this?

      2) Concurrent managers do not work correctly as they have still old node names (used in PCP in the source system). Workaround used:

      1. Logon to EBS web GUI and remove all nodes from all concurrent managers.
      2. Shutdown application tier. Verify that all concurrent managers have been shutdown. If not, kill the processes manually
      3. As apps user run cmclean.sql
      4. Restart application tier

      Is there a better solution for this?

      3) Database changes from ARCHIVELOG mode to nonarchivelog mode in the target system. Is there anyway to prevent this?

      4) Also, we would like to perform a full clone (app + db tiers) from production without shutting down the application. Is this possible? What would be the best documents to describe this? In Production, we have Oracle Data Guard setup with physical standby as per "Oracle Tech Note: Business Continuity for Oracle E-Business Release 12 Using Oracle 11g Physical Standby Database [ID 1070033.1]". This can be used when performing a hot clone for the database, right? What about the application tier? Steps described in 406982.1 include running AutoConfig in which application tier should be down. Does the application need to be down when running "Maintain Snapshot Information"?

      5) One final question (not related to cloning). Oracle Enterprise Manager console webUI has recently stopped working in IE8. E.g. https://myhost.mydomain.com:5501/em gives "Page cannot be displayed". This was working correctly last week. In Firefox, the same link is working fine. Any ideas how to fix this?

      Thanks for your answers in advance.

      BR,
      TH
        • 1. Re: EBS 12.1.3: a few questions about cloning
          Hussein Sawwan-Oracle
          1) Home page cannot be accessed as application tier $CONTEXT_FILE still contains "https" and ssl termination settings.

          Workaround:

          Modify (with text editor) Application Tier $CONTEXT_FILE as follows.
          <webentryurlprotocol oa_var="s_webentryurlprotocol" customized="yes">http</webentryurlprotocol>
          <sslterminator oa_var="s_enable_sslterminator">#</sslterminator>
          <login_page oa_var="s_login_page" customized="yes">http://myhost.mydomain.com:8000/OA_HTML/AppsLogin</login_page>
          <externURL oa_var="s_external_url" customized="yes">http://myhost.mydomain.com:8000</externURL>

          Run AutoConfig and start application tier.

          Is there a better and supported solution for this?
          No, you need to edit the context file manually and run AutoConfig.
          2) Concurrent managers do not work correctly as they have still old node names (used in PCP in the source system). Workaround used:

          1. Logon to EBS web GUI and remove all nodes from all concurrent managers.
          2. Shutdown application tier. Verify that all concurrent managers have been shutdown. If not, kill the processes manually
          3. As apps user run cmclean.sql
          4. Restart application tier

          Is there a better solution for this?
          You are following the best approach. You could update the node details from the backend if you want.
          3) Database changes from ARCHIVELOG mode to nonarchivelog mode in the target system. Is there anyway to prevent this?
          By default, Rapid Clone will create the target database in noarchivelog mode.
          4) Also, we would like to perform a full clone (app + db tiers) from production without shutting down the application. Is this possible? What would be the best documents to describe this? In Production, we have Oracle Data Guard setup with physical standby as per "Oracle Tech Note: Business Continuity for Oracle E-Business Release 12 Using Oracle 11g Physical Standby Database [ID 1070033.1]". This can be used when performing a hot clone for the database, right?
          Correct.
          What about the application tier? Steps described in 406982.1 include running AutoConfig in which application tier should be down. Does the application need to be down when running "Maintain Snapshot Information"?
          You can copy the application tier node files while the application is up. And, you do not need to shutdown the application to run "Maintain Snapshot Information".
          5) One final question (not related to cloning). Oracle Enterprise Manager console webUI has recently stopped working in IE8. E.g. https://myhost.mydomain.com:5501/em gives "Page cannot be displayed". This was working correctly last week. In Firefox, the same link is working fine. Any ideas how to fix this?
          If it is working from one browser, then it should not be an EM issue. Have you tried from a different client and see if this works? Have you changed any setting in your IE browser? Please make sure you add the EM URL to the trusted sites list.

          Thanks,
          Hussein
          • 2. Re: EBS 12.1.3: a few questions about cloning
            user593399
            Hi Hussein,

            thanks a lot. Could you clarify a few things more?
            Hussein Sawwan wrote:
            2) Concurrent managers do not work correctly as they have still old node names (used in PCP in the source system). Workaround used:

            1. Logon to EBS web GUI and remove all nodes from all concurrent managers.
            2. Shutdown application tier. Verify that all concurrent managers have been shutdown. If not, kill the processes manually
            3. As apps user run cmclean.sql
            4. Restart application tier

            Is there a better solution for this?
            You are following the best approach. You could update the node details from the backend if you want.
            I would be interested to update the node details from the backend. Which document I should follow?

            >
            4) Also, we would like to perform a full clone (app + db tiers) from production without shutting down the application. Is this possible? What would be the best documents to describe this? In Production, we have Oracle Data Guard setup with physical standby as per "Oracle Tech Note: Business Continuity for Oracle E-Business Release 12 Using Oracle 11g Physical Standby Database [ID 1070033.1]". This can be used when performing a hot clone for the database, right?
            Correct.
            What about the application tier? Steps described in 406982.1 include running AutoConfig in which application tier should be down. Does the application need to be down when running "Maintain Snapshot Information"?
            You can copy the application tier node files while the application is up. And, you do not need to shutdown the application to run "Maintain Snapshot Information".
            In our scenario (two active application nodes, shared application tier), is it possible to execute the following cloning steps without downtime? I.e. shutdown one app node and run AutoConfig there.
            1. Run AutoConfig on Application Server
            2. Synchronize appsutil on the database tier nodes
            3. Run AutoConfig on Database Server

            >
            5) One final question (not related to cloning). Oracle Enterprise Manager console webUI has recently stopped working in IE8. E.g. https://myhost.mydomain.com:5501/em gives "Page cannot be displayed". This was working correctly last week. In Firefox, the same link is working fine. Any ideas how to fix this?
            If it is working from one browser, then it should not be an EM issue. Have you tried from a different client and see if this works? Have you changed any setting in your IE browser? Please make sure you add the EM URL to the trusted sites list.
            The solution described in the following note solved the problem:
            "Log In To Grid Control Console 10g or DB Control 10g and 11g within Internet Explorer 7, 8 or 9 fails with "Internet Explorer cannot display this page" or with Security Certificate Error [ID 1498203.1]”


            BR,
            TH
            • 3. Re: EBS 12.1.3: a few questions about cloning
              Hussein Sawwan-Oracle
              I would be interested to update the node details from the backend. Which document I should follow?
              FND_CONCURRENT_QUEUES
              http://etrm.oracle.com/pls/et1211d9/etrm_pnav.show_object?c_name=FND_CONCURRENT_QUEUES&c_owner=APPLSYS&c_type=TABLE
              In our scenario (two active application nodes, shared application tier), is it possible to execute the following cloning steps without downtime? I.e. shutdown one app node and run AutoConfig there.
              1. Run AutoConfig on Application Server
              2. Synchronize appsutil on the database tier nodes
              3. Run AutoConfig on Database Server
              Yes, however you need to bounce the application services once AutoConfig complete successfully.
              The solution described in the following note solved the problem:
              "Log In To Grid Control Console 10g or DB Control 10g and 11g within Internet Explorer 7, 8 or 9 fails with "Internet Explorer cannot display this page" or with Security Certificate Error [ID 1498203.1]”
              Thanks for the update!

              Thanks,
              Hussein
              • 4. Re: EBS 12.1.3: a few questions about cloning
                user593399
                Hi Hussein,

                many thanks for your reply. One more question:

                When running "perl adcfgclone.pl dbTier" I enter:
                Target System utl_file_dir Directory List : /usr/tmp2

                The end result is still that the first value of utl_file_dir is /usr/tmp (/usr/tmp2 becomes the second value). I've understood that this causes some temporary files still to be generated into /usr/tmp. As we have multiple EBS environments on the same server this has caused some problems as these temporary files in /usr/tmp have conflicted between environments (e.g. environment 1 user tries to create a temporary file that has already been created previously by environment 2 user). Could this be avoided some way?

                Many thanks for your help.

                BR,
                TH
                • 5. Re: EBS 12.1.3: a few questions about cloning
                  Hussein Sawwan-Oracle
                  Edit the value of utl_file_dir in your pfile to make it starts with "/usr/tmp2" or from SQL*Plus if you use an spfile (see the syntax in [ID 261693.1]).

                  Thanks,
                  Hussein
                  • 6. Re: EBS 12.1.3: a few questions about cloning
                    user593399
                    Hi,

                    Thanks for your reply Hussein. Recently, I noticed one more issue with cloning.

                    As part of the cloning also the scheduled concurrent requests and their delivery options (e.g. email output) are cloned. Consequently, users were receiving emails from multiple environments.

                    When searching for more information, I came up with the following links:
                    http://allappsdba.blogspot.fi/2012/05/script-to-disable-all-scheduled.html
                    http://raghuook.blogspot.fi/2010/08/apps-dba-trobleshoot-scripts.html

                    I.e. the problem could be avoided by running an SQL update query on fnd_concurrent_requests table. Is this type of method supported by Oracle?

                    In general, I would be interested to know which Apps DBA tasks can be automated with similar direct database updates without losing Oracle's support.

                    Thanks in advance.

                    BR,
                    TH
                    • 7. Re: EBS 12.1.3: a few questions about cloning
                      Hussein Sawwan-Oracle
                      user593399 wrote:
                      Hi,

                      Thanks for your reply Hussein. Recently, I noticed one more issue with cloning.

                      As part of the cloning also the scheduled concurrent requests and their delivery options (e.g. email output) are cloned. Consequently, users were receiving emails from multiple environments.

                      When searching for more information, I came up with the following links:
                      http://allappsdba.blogspot.fi/2012/05/script-to-disable-all-scheduled.html
                      http://raghuook.blogspot.fi/2010/08/apps-dba-trobleshoot-scripts.html

                      I.e. the problem could be avoided by running an SQL update query on fnd_concurrent_requests table. Is this type of method supported by Oracle?
                      Yes.
                      In general, I would be interested to know which Apps DBA tasks can be automated with similar direct database updates without losing Oracle's support.
                      There is no such a list -- Usually, direct update is not supported except for some cases (like if it is mentioned in MOS docs or are instructed by Oracle support).

                      Concurrent Processing - CMCLEAN.SQL - Non Destructive Script to Clean Concurrent Manager Tables [ID 134007.1]

                      Thanks,
                      Hussein