11 Replies Latest reply on Jan 15, 2019 6:52 AM by Beauty_and_dBest

    EBS 12.1.3 - How to tell which clone belongs to which?

    Beauty_and_dBest

      EBS 12.1.3

      11g

      OL6

       

      Hi ALL,

       

      We have two PROD EBS 12.1.3 with different setup.

      I have cloned one of them, but I forgot which source did I get.

      How do I compare the source  and the clone to check that they match?

      Is there a table that I can select and complare?

       

       

      Please help....

       

      Kind regards,

      jc

        • 1. Re: EBS 12.1.3 - How to tell which clone belongs to which?
          mdtaylor

          If you navigate to the $APPL_TOP, or database home, you should still see the source instance env files.

           

          Regards,

          Michael

          • 2. Re: EBS 12.1.3 - How to tell which clone belongs to which?
            lmu

            SQL> select instance_name,host_name from v$instance;

             

            Look at your $CONTEXT_FILE, see which matches the source. You didn't say which changes you made, but all the configuration should be in the $CONTEXT_FILE.

            • 3. Re: EBS 12.1.3 - How to tell which clone belongs to which?
              Beauty_and_dBest

              Thanks Michael, Imu,

               

              But the cloning I made is generic, and all three instances reside on the same server with different portpool.

               

              For example the two source instances have the following homes.

               

              Instance1 (portpool 0)

              ================

              appsTier

              /u01/approd/PROD

              dbTier:

              /u01/oraprod/PROD

               

              Instance2 (portpool 10)

              ==================

              appsTier

              /u02/approd2/PROD2

              dbTier:

              /u02/oraprod2/PROD2

               

               

              Target clone (portpool 20)

              ====================

              appsTier

              /u03/appuat/UAT

              dbTier:

              /u02/orauat/UAT

               

               

              I am thinking there should be FND tables that matches? maybe the FND_USERS and Responsibilities?

               

              Please help....

               

              Kind regards,

              • 4. Re: EBS 12.1.3 - How to tell which clone belongs to which?
                Kanda-Oracle

                Hi

                 

                All the profile would be set.  So pick up any table (or) Sequence and may compare the values.

                 

                SQL> select max(request_ID) from fnd_concurrent_requests

                 

                SQL> select fnd_concurrent_requests_s.currval from dual;  -- compare with the both the source.

                 

                Hope you should be able to make out.

                 

                Thanks

                 

                N Kandasamy

                • 5. Re: EBS 12.1.3 - How to tell which clone belongs to which?
                  lmu

                  We have two PROD EBS 12.1.3 with different setup. - What is different about the setup? Check for that in your clone.

                  • 6. Re: EBS 12.1.3 - How to tell which clone belongs to which?
                    Beauty_and_dBest

                    Hi Imu

                     

                    I am not functional admin so I do not know what setup wast made

                    All I know that it belongs to two different company org.

                     

                    Maybe the setup of users can be checked? I mean the username login created.

                     

                     

                    Kind regards,

                    • 7. Re: EBS 12.1.3 - How to tell which clone belongs to which?
                      Kanda-Oracle

                      you may pick up any table (or) Sequence and may compare the values. pls check the example given above.

                      • 8. Re: EBS 12.1.3 - How to tell which clone belongs to which?
                        Beauty_and_dBest

                        Hi Kanda,

                         

                        The clone was taken from backup 2 months ago. So the sequence maybe long time exceeded values.

                        • 9. Re: EBS 12.1.3 - How to tell which clone belongs to which?
                          mdtaylor

                          Hi jc,

                           

                          Try select * from fnd_sids;

                           

                          This shows all of the sids associated with our EBS instances.

                           

                          Regards,

                          Michael

                          • 10. Re: EBS 12.1.3 - How to tell which clone belongs to which?
                            Beauty_and_dBest

                            Thanks Michael, and ALL,

                             

                            I  will try that...brb

                            • 11. Re: EBS 12.1.3 - How to tell which clone belongs to which?
                              Beauty_and_dBest

                              Thanks Michael and ALL,

                               

                              I got it

                               

                              SID_GUID||','||SID||','||CREATION_DATE

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

                              10242039D0C648E0E0401490C8C46FE7,PRD10202,29-MAR-06

                              292ED8B00EBC9137E04023820C104EDE,FINPRD19,10-FEB-07

                              668E8F81DECF7318E04023824E113BAF,PRODPACK,02-APR-09

                              7671F8A0F32535CEE050120AC6C04480,PROD,22-SEP-18

                              0740EF34C09B3DC5E0401490C8C45C28,PRD11510,06-DEC-05

                              6111A3B0BA64C2A8E0402382C813631B,PRODPACK,22-JAN-09

                              F86380C65FAE3768E040A8C0EA006873,PROD,02-MAY-14

                              571CFC7D031FF206E0506A0ACE9D6E43,PROD,19-AUG-17

                              3D2F091A9F0DBE84E04023824F117336,RUP4BLP,23-OCT-07

                              447D2379296C90D3E04023824F11120D,PRODPACK,24-JAN-08

                              7D73257DD1C9B611E040578CE2DD353B,BF2601,18-JAN-10

                              26526A396375831FE0401490C9C45C75,PRB19,05-JAN-07

                              296438A8746D819FE04023820C100EE7,FINPRD19,13-FEB-07

                              6A674E7B6677EE76E040578CDEDD4509,BF2202,21-MAY-09

                              709101FEDBDF8394E040578CDEDD0351,BF2206,07-AUG-09

                              8EB54FE40C2141A4E040B10A4A2A379F,OA6901,26-AUG-10

                              25CE74C37022BD64E0401490C9C43C30,PRB19,29-DEC-06

                              4469A903349637CDE04023824F110E41,PRODPACK,23-JAN-08

                              5C817C38E2E0E276E0402382C91351A8,R1211BLN,25-NOV-08

                              B8CA1F84AA53CAECE040690A420C0ADF,PROD,13-FEB-12

                              FD49A4A08A1B7118E04010ACEAFE0852,PROD,03-JUL-14

                              26BAE12CDFDF0CBCE0501FAC760E1A04,PROD,12-DEC-15

                              0726E78ADE20FCC0E0401490C8C41D57,PRD11510,04-DEC-05

                              7E68E6D20D44339CE050130AA2211155,MOLI2,02-JAN-19

                              66A623CE71739697E04023824E117E3D,PRODPACK,03-APR-09

                              FAF05887385F280BE04010ACEAFE2D9A,PROD,03-JUN-14

                              E763CBDA55701DBDE0301490CBC455B3,PRD34,26-OCT-04

                              5CC26FC3E818F390E0402382C9135747,R1211BLN,28-NOV-08

                              62BB2564E164AE94E0506A0A32941E8A,PROD,14-JAN-18

                              7F04D5CFC9232897E050130AA22142A2,MOLI2,09-JAN-19

                               

                              30 rows selected.

                               

                               

                              SID_GUID||','||SID||','||CREATION_DATE

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

                              10242039D0C648E0E0401490C8C46FE7,PRD10202,29-MAR-06

                              292ED8B00EBC9137E04023820C104EDE,FINPRD19,10-FEB-07

                              668E8F81DECF7318E04023824E113BAF,PRODPACK,02-APR-09

                              7671F8A0F32535CEE050120AC6C04480,PROD,22-SEP-18

                              0740EF34C09B3DC5E0401490C8C45C28,PRD11510,06-DEC-05

                              6111A3B0BA64C2A8E0402382C813631B,PRODPACK,22-JAN-09

                              F86380C65FAE3768E040A8C0EA006873,PROD,02-MAY-14

                              571CFC7D031FF206E0506A0ACE9D6E43,PROD,19-AUG-17

                              3D2F091A9F0DBE84E04023824F117336,RUP4BLP,23-OCT-07

                              447D2379296C90D3E04023824F11120D,PRODPACK,24-JAN-08

                              7D73257DD1C9B611E040578CE2DD353B,BF2601,18-JAN-10

                              26526A396375831FE0401490C9C45C75,PRB19,05-JAN-07

                              296438A8746D819FE04023820C100EE7,FINPRD19,13-FEB-07

                              6A674E7B6677EE76E040578CDEDD4509,BF2202,21-MAY-09

                              709101FEDBDF8394E040578CDEDD0351,BF2206,07-AUG-09

                              8EB54FE40C2141A4E040B10A4A2A379F,OA6901,26-AUG-10

                              25CE74C37022BD64E0401490C9C43C30,PRB19,29-DEC-06

                              4469A903349637CDE04023824F110E41,PRODPACK,23-JAN-08

                              5C817C38E2E0E276E0402382C91351A8,R1211BLN,25-NOV-08

                              B8CA1F84AA53CAECE040690A420C0ADF,PROD,13-FEB-12

                              FD49A4A08A1B7118E04010ACEAFE0852,PROD,03-JUL-14

                              26BAE12CDFDF0CBCE0501FAC760E1A04,PROD,12-DEC-15

                              787A0BEFAD587789E050120AC6C026C6,PROD,18-OCT-18

                              0726E78ADE20FCC0E0401490C8C41D57,PRD11510,04-DEC-05

                              66A623CE71739697E04023824E117E3D,PRODPACK,03-APR-09

                              FAF05887385F280BE04010ACEAFE2D9A,PROD,03-JUN-14

                              7F285B4228929B05E050120AC6C005B4,PROD,11-JAN-19

                              E763CBDA55701DBDE0301490CBC455B3,PRD34,26-OCT-04

                              5CC26FC3E818F390E0402382C9135747,R1211BLN,28-NOV-08

                              62BB2564E164AE94E0506A0A32941E8A,PROD,14-JAN-18

                               

                              30 rows selected.

                               

                              ==================

                               

                              SID_GUID||','||SID||','||CREATION_DATE

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

                              095A4BBA146EF411E040928D8C1414A4,LA4001,01-JAN-06

                              177BD2F33E9EAB0FE040928D8C147AC4,LA4001,30-JUN-06

                              17A7BE6B18885810E040928D8C14786A,LA4001,03-JUL-06

                              01A69F15859FAA6BE040928D8C141453,LA4001,26-SEP-05

                              04169CEFC75E6598E040928D8C145CDE,LA4001,27-OCT-05

                              02D39F30CBEBFFF2E040928D8C1431A7,LA4001,11-OCT-05

                              0E787A7C0421B4B6E040928D8C1405F4,LA4001,08-MAR-06

                              03115E51972305CCE040928D8C145654,LA4001,14-OCT-05

                              07533F026C539705E040928D8C142514,LA4001,07-DEC-05

                              087DD0459BD52CADE040928D8C142489,LA4001,22-DEC-05

                              0F7AEAC2BAEB7366E040928D8C140759,LA4001,20-MAR-06

                              0374A3A11C9F5655E040928D8C14676A,LA4001,19-OCT-05

                              0B06D9FEFC0EADE6E040928D8C142A6F,LA4001,23-JAN-06

                              0B2843753828CDADE040928D8C1411BF,LA4001,24-JAN-06

                              05D541B605AD67CEE040928D8C1403EF,LA4001,18-NOV-05

                              09FBF1D37B618748E040928D8C1452CE,LA4001,10-JAN-06

                              E9FFD63AF10DB4BBE030928D051576A2,LE4001,28-NOV-04

                              141104B1CAC3A466E040928D8C143B3C,LA4001,18-MAY-06

                              07E24CE3C76330D5E040928D8C1424EF,LA4001,14-DEC-05

                              112243EF089F8C1AE040928D8C143FFB,LA4001,11-APR-06

                              1573BDF5D870F6CDE040928D8C144BE1,LA4001,05-JUN-06

                              E8B6D32F42827097E030928D051565E4,LA0005,12-NOV-04

                              074FDF88D2A6CC6EE040928D8C144CEA,LA4001,07-DEC-05

                              0B174EB0650FFAC1E040928D8C147AAE,LA4001,24-JAN-06

                              1305A9D254CA6976E040928D8C147F9B,LA4001,05-MAY-06

                              137DE2BF9D6934CEE040928D8C14147E,LA4001,11-MAY-06

                              073D7315A72D3B2CE040928D8C140380,LA4001,06-DEC-05

                              0B5609E5ABD4DC84E040928D8C1447E8,LA4001,27-JAN-06

                              0C2BF981AD932626E040928D8C144708,LA4001,06-FEB-06

                              1962DC44614EC075E040928D8C1464CB,LA4001,25-JUL-06

                              1963BF4D3A1CD96AE040928D8C1402C9,LA4001,25-JUL-06

                              053064A460499BEEE040928D8E144B43,LA4003,09-NOV-05

                              08E1040E78DB964FE040928D8C14150C,LA4001,26-DEC-05

                              194E6E20C87B7CE0E040928D8C146F83,LA4001,24-JUL-06

                              FA8074B6B9D6ADDDE030928D0115255D,LA0001,27-JUN-05

                              FCF498BBDD19F350E030928D8C145217,LA4001,28-JUL-05

                              FEBD86F92350E0BDE030928D8C147152,LA4001,20-AUG-05

                              FF4C7B44DAEE2E54E030928D8C1435B5,LA4001,27-AUG-05

                              020C0B018D868FBFE040928D8C140514,LA4001,01-OCT-05

                              0B0671CD5BAB991EE040928D8C144347,LA4001,23-JAN-06

                              FFD7CA9E03A13132E030928D8C14662F,LA4001,03-SEP-05

                              05714C3BDA2887C0E040928D8C147D5C,LA4001,13-NOV-05

                              058448CCBE1912ECE040928D8C1431B3,LA4001,14-NOV-05

                              0586D4355340AEFEE040928D8C144AAF,LA4001,14-NOV-05

                              05BE78896D824631E040928D8C142A3A,LA4001,17-NOV-05

                              12C69431E47B0EDFE040928D8C1431C0,LA4001,01-MAY-06

                              16CE638A996EF11AE040928D8C142F83,LA4001,22-JUN-06

                              3AABDE29A1525B04E040928D8C1403C9,LA4001,21-SEP-07

                              5D239F67B2E6F746E0402382C8135133,ADS2UPG,03-DEC-08

                              E526AA415EF0E4BEE040000AEA0048EE,VIS,30-AUG-13

                              60769CBD0BD0CC45E0402382C8135F53,R1211XB4,14-JAN-09

                              667FD8EC3365C77CE04023824E112D34,R1211XB9,01-APR-09

                              4A471B7F7A04D145E050000AD8004548,R1213,09-MAR-17

                              6A2E34FBD43A1504E050160A3A411D9A,R1213,19-APR-18

                              6B0A60E32B85FFF1E050160A3A4122A6,R1213,30-APR-18

                              5C95A440FECE3AA0E0401490CAC454B9,ADR3X14,26-NOV-08

                              66044AD15E6B7622E04023824E113CF6,R1211XB9,26-MAR-09

                              529B8FCFE120346DE0506A0A228C0FD7,R1213,23-JUN-17

                              62A0A01B5FB809E9E040B98B50481E9F,R1211XB6,10-FEB-09

                              52726C101C58147CE0506A0A228C0EA8,R1213,21-JUN-17

                              E3E3BE947A7FAC3AE040060A9C8634E7,VIS,14-AUG-13

                              58FFA7F7F12E3BECE0506A0A86A74F55,R1213,12-SEP-17

                              50E0AD78E0BFCE1EE040928D4C384F14,LA4101,30-JUN-08

                              5670DB28DF35284EE040928D5C155414,LA5095,09-SEP-08

                              4A5972E63C823515E050000AD8001BA0,R1213,10-MAR-17

                               

                              65 rows selected.