10 Replies Latest reply: Feb 1, 2013 3:57 AM by 880697 RSS

    Two Node Architechture

    880697
      Hi DBAs,

      We are having two node environment, In Node A Batch Processing service, Root Service, DB & In Node B forms & Web server. Our DB size is 1.3 TB, Apps Version is 12.1.1 DB version is 11.1.0.7.

      Our previous up-gradation partner did not go OATM migration after 11i to R12.1.1 Upgrade. So now planning to go OATM. After that planning to upgrade EBS to 12.1.3 with 11.2.0.3 or latest release.

      Further we would also like to change current environment to

      Shared Application Tier
      PCP Configuration
      Best Load balancer for this (Shared Application Tier) environment.

      Please suggest Hardware & space requirements for the activities.

      I am reading the below docs to implement successfully.
      Sharing The Application Tier File System in Oracle E-Business Suite Release 12 [ID 384248.1]
      Using Load-Balancers with Oracle E-Business Suite Release 12 [ID 380489.1]

      OATM
      Note IDs
      404954.1
      248857.1

      Thanks
      DBA
        • 1. Re: Two Node Architechture
          Hussein Sawwan-Oracle
          We are having two node environment, In Node A Batch Processing service, Root Service, DB & In Node B forms & Web server. Our DB size is 1.3 TB, Apps Version is 12.1.1 DB version is 11.1.0.7.

          Our previous up-gradation partner did not go OATM migration after 11i to R12.1.1 Upgrade. So now planning to go OATM. After that planning to upgrade EBS to 12.1.3 with 11.2.0.3 or latest release.

          Further we would also like to change current environment to

          Shared Application Tier
          PCP Configuration
          Best Load balancer for this (Shared Application Tier) environment.

          Please suggest Hardware & space requirements for the activities.

          I am reading the below docs to implement successfully.
          Sharing The Application Tier File System in Oracle E-Business Suite Release 12 [ID 384248.1]
          Using Load-Balancers with Oracle E-Business Suite Release 12 [ID 380489.1]

          OATM
          Note IDs
          404954.1
          248857.1
          You already have the necessary docs you need to refer to.

          In addition to those docs, please refer to old threads for similar topic and discussion.

          https://forums.oracle.com/forums/search.jspa?threadID=&q=Hardware+AND+Requirements&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001
          https://forums.oracle.com/forums/search.jspa?threadID=&q=OATM&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001
          https://forums.oracle.com/forums/search.jspa?threadID=&q=Shared+AND+Application+AND+File+AND+System+AND+R12&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001
          https://forums.oracle.com/forums/search.jspa?threadID=&q=Load+AND+Balancer+AND+R12&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001

          Thanks,
          Hussein
          • 2. Re: Two Node Architechture
            880697
            Hi Hussein,

            I checked the below link.

            In OATM link

            I found that we are already in OATM.

            I have checked below tables it is showing some data in all tables

            FND_TABLESPACES

            FND_OBJECT_TABLESPACES

            FND_TS_SIZING

            FND_TS_MIG_CMDS
            Not showing any data

            FND_TS_MIG_RULES

            FND_TS_PROD_INSTS

            Thanks
            DBA
            • 3. Re: Two Node Architechture
              Hussein Sawwan-Oracle
              What is your question?

              Thanks,
              Hussein
              • 4. Re: Two Node Architechture
                880697
                Hi Hussein,

                Sorry, Now my question is we want to know whether our previous implementation partner migrated OATM or not.

                I have checked v$tablespace Now it is showing 424 tablespaces. So it seems we are not done OATM migration Right? Correct me if i am wrong.

                Thanks
                DBA
                • 5. Re: Two Node Architechture
                  EBSDBA
                  Hi,
                  I have checked v$tablespace Now it is showing 424 tablespaces. So it seems we are not done OATM migration Right? Correct me if i am wrong.
                  Looks like it is not migrated to OATM.

                  Check if you have tablespaces like

                  'APPS_TS_TX_DATA',
                  'APPS_TS_TX_IDX',
                  'APPS_TS_SUMMARY',
                  'APPS_TS_INTERFACE',
                  'APPS_TS_NOLOGGING',
                  'APPS_TS_ARCHIVE'

                  Thanks
                  • 6. Re: Two Node Architechture
                    880697
                    Hi Hussein,

                    No tables like

                    'APPS_TS_TX_DATA',
                    'APPS_TS_TX_IDX',
                    'APPS_TS_SUMMARY',
                    'APPS_TS_INTERFACE',
                    'APPS_TS_NOLOGGING',
                    'APPS_TS_ARCHIVE'

                    Thanks
                    DBA
                    • 7. Re: Two Node Architechture
                      EBSDBA
                      Hi,
                      Not tables, please see if there are any tablespaces like that

                      Thanks
                      • 8. Re: Two Node Architechture
                        880697
                        Hi DBA,

                        Sorry, I was in little confusion. so i queried. I am having this below tables.


                        Thanks
                        DBA
                        • 9. Re: Two Node Architechture
                          880697
                          Hi

                          Not tables. Tablespace
                          • 10. Re: Two Node Architechture
                            880697
                            Hi

                            Not tables. Tablespace