11 Replies Latest reply on Jun 21, 2016 10:28 AM by Beauty_and_dBest

    4 Apps Tier & 1 Db Tier

    Beauty_and_dBest

      Hi ALL,

       

      EBS R12.1.3

      OL5.3

       

       

      We have been using EBS instance with the standard configuration of 1 AppsTeir partner with 1 Database Tier.

      But lately, when I entered in this new company, I encountered their different "unusual" setup . They have Four (4) Apps Tier partner with One(1) Db Tier.

       

      The four(4) apps tier correspond to different sister conpanies,

      Apps Tier1 - for CompanyA,

      Apps Tier2 - for CompanyB,

      Apps Tier3 - for CompanyC,

      Apps Tier4 - for CompanyD

       

      They are all accessing 1 database tier.

      Is this a good design? or Have anyone of you experience this kind of setup?

      Normally adding new company is just adding it to a new Organization Unit inside EBS setup.

      How Do I clone this kind of setup? or How do I add new Apps Tier 5?

       

       

      Kind regards,

      jc

        • 1. Re: 4 Apps Tier & 1 Db Tier
          2794067

          Hi Jenna,

           

          Its an very typical setup. Not all the companies ask to refresh in one go. We suspect the instance you are using might be an multitenant setup.

           

          The four(4) apps tier correspond to different sister conpanies,

          Apps Tier1 - for CompanyA,

          Apps Tier2 - for CompanyB,

          Apps Tier3 - for CompanyC,

          Apps Tier4 - for CompanyD

           

          General refresh document -

           

          Regards,

          Balaji

          1 person found this helpful
          • 2. Re: 4 Apps Tier & 1 Db Tier
            Beauty_and_dBest

            Thanks balaji

             

            We are in Ebs R12.1 and 11gR1 Database. Afaik, there is no multi-tenant yet in this version?

            I think multi-tenant is available in 12c datanase.

             

             

            Kind regards,

            • 3. Re: 4 Apps Tier & 1 Db Tier
              Bashar.

              Oracle EBS is not yet certified in multi-tenant setup introduced in 12c.

              I read somewhere that you can run an EBS database in a CDB database with only one PDB.

               

              In the below document, refer to section 4.2 for cloning a multi node setup.

              In addition, refer to section 4.3 for adding a new node.

               

              Cloning Oracle Applications Release 12 with Rapid Clone (Doc ID 406982.1)

               

              Maybe this customer enforces some level of security that allows each company to access its own application server. Not a usual setup though.

               

              Regards,

              Bashar

              1 person found this helpful
              • 4. Re: 4 Apps Tier & 1 Db Tier
                Beauty_and_dBest

                Thanks bashar,

                 

                I really do not know this kind of setup too .

                What do you call this kind of setup? Is this really advisable?

                How do I check using query at the back-end or at the apps-tier to confirm that this kind of setup?

                 

                 

                Kind regards,

                • 5. Re: 4 Apps Tier & 1 Db Tier
                  Bashar.

                  This setup is dictated by the business requirements. Usually a multi-node setup is performed to enable load balancing or adding a node in the DMZ.

                  Just query FND_NODES and it will show all nodes with the enabled services.

                   

                  Regards,

                  Bashar

                  1 person found this helpful
                  • 6. Re: 4 Apps Tier & 1 Db Tier
                    Beauty_and_dBest

                    Thanks Bashar and ALL,

                     

                    How do I know if they use load balancing?

                    Is there fnd table I can query or file/parameter I can check?

                    Is load balancing mandatory for multi-node setup?

                    Maybe multi-node can be the cause of their performance issues right now?

                     

                    Is there RDA I can run which gathers all info in and EBS instance tells what kind of setup it is?

                    Just like a comprehensive diagnostics.

                     

                     

                    Kind regards,

                    • 7. Re: 4 Apps Tier & 1 Db Tier
                      Thiagarajan -Oracle

                      Hi Jeena,

                       

                      Can you provide the output of the EBS FND_NODES table:

                       

                      select * from fnd_nodes;

                       

                      Also, Is there any external DMZ node configured on your instance? Provide the output of the below query

                       

                      select

                        p.user_profile_option_name "Profile Name",

                        decode(v.profile_option_value,

                          1, 'Admin',

                          2, 'Normal',

                          3, 'External',

                          'Unknown') Value,

                        decode(v.level_id,

                          10001,'SITE',

                          10002, (select 'App:'||a.application_short_name from fnd_application a

                                  where a.application_id = v.level_value),

                          10003, (select 'Resp:'||f.RESPONSIBILITY_name||' ('||responsibility_key||')' from fnd_responsibility_vl f

                                  where f.responsibility_id = v.level_value),

                          10004, (select 'User:'||u.user_name from fnd_user u

                                  where u.user_id = v.level_value),

                          10005, (select 'Server:'||n.node_name from fnd_nodes n

                                  where n.node_id = v.level_value),

                          10006, (select 'Org:'||org.name from hr_operating_units org

                                  where org.name = v.level_value),

                          'NOT SET') "Level Where Option Is Set"

                      from

                        fnd_profile_options_vl p,

                        fnd_profile_option_values v

                      where

                        p.profile_option_id = v.profile_option_id

                        and p.application_id = v.application_id

                        and p.profile_option_name like upper('%TRUST%')

                      order by 1,2,3 desc;

                       

                      Regards,

                      Thiagarajan.

                      1 person found this helpful
                      • 8. Re: 4 Apps Tier & 1 Db Tier
                        Beauty_and_dBest

                        Thanks thiaga,

                         

                         

                        I will ask first permission or request  the PROD security admin to run it,

                        because we are off limits to production servers.

                         

                         

                        Kind regards,

                        • 9. Re: 4 Apps Tier & 1 Db Tier
                          Beauty_and_dBest

                          Hi thiagarajan,bashar,balagi

                           

                           

                          I want to test multi-node setup on our ebs TEST instance.

                          I will add a new node on it.

                          Can I do it without a load balancer installed?

                           

                           

                          Kind regards,

                          • 10. Re: 4 Apps Tier & 1 Db Tier
                            Bashar.

                            I will add a new node on it.

                            Can I do it without a load balancer installed?

                            Yes.

                            You can add application nodes regardless of having load balancing or not.

                            However, if load balancing is used then you won't be able to access the application from the new node.

                             

                            Regards,

                            Bashar

                            1 person found this helpful
                            • 11. Re: 4 Apps Tier & 1 Db Tier
                              Beauty_and_dBest

                              Thanks ALL