8 Replies Latest reply on Aug 25, 2021 11:57 PM by kunal pandit

    Migrating MDM 10.4 to oracle RAC server

    Cristian Montesinos Fernandez New Member

      Hello

      Currently, we have MDM 10.4 installed with an Oracle x86 server (data + metadata)

      We would like to migrate the database server to  new Oracle RAC server without reinstalling the product and the process is not clear to me

       

      I was thinking on the following path:

       

       

      1. Creating new  CMX_SYSTEM(sip_ant.sh create_system)

       

       

      2. Importing the CMX_SYSTEM(impdp export from CMX_SYSTEM x86 database) --> is this step necessary?

       

       

      3. Creating new  AVOS(sip_ant.sh create_bpm)

       

       

      4. Importing the AVOS(impdp export from AVOS schema on x86 database)

       

       

      5. Creating the CMX_ORS(sip_ant.sh create_ors)

       

       

      6. Importing the CMX_ORS(impdp export from CMX_ORS schema on x86 database)

       

       

      7. Modifying connection parameters

       

       

      Update the table (Master DB Schema) CMX_SYSTEM.C_REPOS_DATABASE with the new database hostname for the following columns

      CONNECT_URL

      DATABASE_HOST

      DDM_CONNECT_URL

      DATABASE_ID (If SID used update database host else if service no need to change)

      Update the table CMX_ORS.C_REPOS_DB_RELEASE with the new database hostname for the following columns

      DATABASE_HOST

      DATABASE_ID (If SID used update database host else if DB service no need to change)

      CONNECT_URL

       

       

       

       

      8. Update the JDBC Datasource in application server(jboss) with the new database host name.

       

       

      9. add new CMX_ORS database on Hub server

       

       

      10. Modify tnsnames on HUBSERVER

       

       

      there is any missing step?

      there is any kind of documentation to acomplish this kind of migration?

        • 1. Re: Migrating MDM 10.4 to oracle RAC server
          Sathiesh M Guru

          Doesnt need to go thru step 1-6. If doing that you would be forced to load data in MDM once again.

          All it needs is just create a oracle dump of all the schemas and recreate them as-is in the target RAC database.

          Then follow steps 7 onwards and pls refer the KBs out there regarding cloning cmx_system, ORS.

          For ActiveVos DB some additional steps maybe needed, which you can check thru support case.

          • 2. Re: Migrating MDM 10.4 to oracle RAC server
            Anuvinda Kulkarni Guru

            To configure the Master Database (CMX_SYSTEM) and Operational Reference Store (ORS) in Oracle Real Application Clusters (RAC) environment:

             

            1. Create a dump of the master and ORS schemas from source DB and export it to the target RAC DB server

             

            2. Validate JDBC at the application server’s console.

             

            3. Run an update query on the CMX System Data source URL as follows:

             

            update c_repos_database set connect_url = 'jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =<host address 1>)(PORT =  1523)) (ADDRESS = (PROTOCOL = TCP)(HOST =<host address 2>)(PORT = 1523)) (LOAD_BALANCE = yes)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = <service name>) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 180) (DELAY = 5) ) ) )' where database_desc like '%MRM Master Database%'

             

            This should update only one row in the c_repos_database table.

             

            4.Run an update query on the ORS connect_url as follows:

             

            update c_repos_db_release set connect_url = 'jdbc:oracle:thin:@//< host address 1>:1523/<service name>) '

             

            5. Registration of the ORS.

            jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = <host address 1>)(PORT = 1523)) (ADDRESS = (PROTOCOL = TCP)(HOST =  <host address 2>)(PORT = 1523)) (LOAD_BALANCE = yes)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = <service name>) (FAILOVER_MODE = (TYPE = SELECT)  (METHOD = BASIC) (RETRIES = 180) (DELAY = 5) )))

             

            - Unregister your ORS in the Hub Console (Databases menu) which has been manually edited in the application server.

            - Add the  ORS as an Oracle service using host<host address>, and service name <service name>.

            - Before saving, edit the JDBC URL as follows:

            - Enable the create data source option and test the connection after registration

            • 3. Re: Migrating MDM 10.4 to oracle RAC server
              Cristian Montesinos Fernandez New Member

              thanks for the answer

              it seeems clear for system and ors(at least teorically)

              now , the problem continues with AVOS  migration

              • 4. Re: Migrating MDM 10.4 to oracle RAC server
                kunal pandit Guru

                Please elaborate on the problem with AVOS.

                • 5. Re: Migrating MDM 10.4 to oracle RAC server
                  Cristian Montesinos Fernandez New Member

                  Hi

                  there is no problem, the question is how to proceed with AVOS migration

                  • 6. Re: Migrating MDM 10.4 to oracle RAC server
                    kunal pandit Guru

                    Please note that if the underlying database ID or database name for the ORS is not changing, you will be able to migrate existing ActiveVOS tasks and settings from old database to new database.

                    • 7. Re: Migrating MDM 10.4 to oracle RAC server
                      Cristian Montesinos Fernandez New Member

                      OK, this part is clear,  but, the question is which are the setps to migrate  AVOS

                      • 8. Re: Migrating MDM 10.4 to oracle RAC server
                        kunal pandit Guru

                        It seems that we do not have any documented steps as but we found the following information -

                         

                        Informatica does not certify Oracle Real Application Clusters (RAC) for ActiveVOS, that is, this is not tested with Oracle RAC or have any modules that are specific for Oracle RAC with ActiveVOS. However, ActiveVOS works with MultiSite, and therefore can be used with Oracle RAC architecture.

                         

                        It seems that you can just start with the 2 copies of the same schema to begin with for ActiveVOS schema. However, you may need to check for any Database specific settings in the ActiveVOS URN mappings and Task information.

                         

                        If you still need further assistance, you can always raise a case with Informatica Support