Upgrading from Version 9.0.1 or 9.1.0 for Oracle

10.3 HotFix 1

Back Next

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.

Open a command prompt.

Navigate to the following directory:

In UNIX. <

MDM Hub distribution directory

>/database/bin

In Windows. <

MDM Hub distribution directory

>\database\bin

Run the

MDM Hub Master Database

upgrade script with the following command:

In UNIX.

sip_ant.sh updatemasterdatabase

In Windows.

sip_ant.bat updatemasterdatabase

Answer the prompts.

For Oracle environments, provide the following information for the

MDM Hub Master Database

Prompt	Description
Enter database type (ORACLE, MSSQL, DB2)	Database type. Specify Oracle .
Enter Oracle Connection Type (service, sid). [service]	Connection type. Use one of the following values: SERVICE Uses the service name to connect to Oracle. SID Uses the Oracle System ID to connect to Oracle. Default is SERVICE.
Enter the database host name [localhost]	Name of the host that is running the database.
Enter the database port number. [1521]	Port number that the database listener uses. Default is 1521 .
Enter the database service name [orcl]	Name of the Oracle service. This prompt appears if the selected Oracle connection type is SERVICE. Default is orcl .
Enter Oracle Net connect identifier (TNS Name). [orcl]	TNS name that is used to connect to the Oracle database. Default is orcl .
Master Database Connect URL: "jdbc:oracle:thin:@//<host_name>:<port>/<service_name>".	Connect URL for the Oracle connection type SERVICE.
Enter database SID [orcl]	Name of the Oracle System ID. This prompt appears if the selected Oracle connection type is SID.
Master Database user name [cmx_system]	You cannot change the MDM Hub Master Database name.
Enter the Master Database user password	Password to access the MDM Hub Master Database.

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:

In JBoss environments, restart the application server.

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

Rename Saved Search

Table of Contents

Upgrading from Version 9.0.1 or 9.1.0 for Oracle

Upgrading from Version 9.0.1 or 9.1.0 for Oracle

Upgrading the MDM Hub Master Database in Verbose Mode

Upgrading the MDM Hub Master Database in Verbose Mode