Table of Contents

Search

  1. Preface
  2. Upgrade Overview
  3. Pre-Upgrade Tasks
  4. Database Tasks
  5. Application Server Tasks
  6. Hub Store Upgrade
  7. Hub Server Upgrade (In-place Upgrade)
  8. Process Server Upgrade (In-place Upgrade)
  9. Resource Kit Upgrade (In-place Upgrade)
  10. Post-Upgrade Tasks
  11. Search Configuration Upgrade
  12. ActiveVOS Post-Installation Tasks for the Application Server
  13. ActiveVOS Post-Upgrade Tasks for Business Entity Adapter
  14. ActiveVOS Post-Upgrade Tasks for Subject Areas Adapter
  15. Troubleshooting the Upgrade Process
  16. Frequently Asked Questions
  17. Processing Existing ActiveVOS Tasks
  18. Configuring Metadata Caching

Upgrading from Version 10.0, 10.1, 10.2, or 10.3

Upgrading from Version 10.0, 10.1, 10.2, or 10.3

Upgrading the MDM Hub Master Database in Verbose Mode

Upgrading the MDM Hub Master Database in Verbose Mode

To upgrade the
MDM Hub Master Database
, run the upgrade script.
If you did not use the Hub Console to make metadata changes, the database upgrade script might fail. If a script fails, contact Informatica Global Customer Support.
  1. Open a command prompt.
  2. Navigate to the following directory:
    • In UNIX. <
      MDM Hub distribution directory
      >/database/bin
    • In Windows. <
      MDM Hub distribution directory
      >\database\bin
  3. Run the
    MDM Hub Master Database
    upgrade script with the following command:
    • In UNIX.
      sip_ant.sh updatemasterdatabase
    • In Windows.
      sip_ant.bat updatemasterdatabase
  4. Answer the prompts.
  5. Answer the following prompt if it appears during the Master Database upgrade:
    This upgrade should be performed by a DBA to grant ‘create sequence’ privileges for the master database. The master database does not have ‘create sequence’ privileges, you can either grant it now (manually) and then move forward or re-start the upgrade, or direct this process to do so for you now, and continue the current upgrade. Do you want the process to create this privilege? Yes/No
    • If enter
      No
      , the upgrade process checks again to ensure the user granted the privilege, and then returns to the TNS name prompt.
    • If you enter
      Yes
      , you must answer the following prompts before you can continue with the upgrade process:
      Enter DBA username:
      Enter DBA password:
  6. In JBoss environments, restart the application server.
  7. Save a copy of the CMX_SYSTEM upgrade log files to the upgrade documentation directory. There is a log file for each change script.
    The upgrade process saves the files to the following location:
    • In UNIX.
      <
      MDM Hub installation directory
      >/server/resources/database/db_changes/<
      database name
      >/Master
    • In Windows.
      <
      MDM Hub installation directory
      >\server\resources\database\db_changes\<
      database name
      >\Master

0 COMMENTS

We’d like to hear from you!