Installation Guide for Oracle Database with Red Hat JBoss

10.3 HotFix 2

Back Next

Import the Metadata into the MDM Hub Master Database

After you create the

MDM Hub Master Database

, import the initial metadata into the

MDM Hub Master Database

. The initial metadata includes repository tables and other objects that the

MDM Hub

requires in the

Hub Store

If you change the folder names in the distribution directory, metadata import fails.

Open a command prompt, and navigate to the following directory:

MDM Hub distribution directory

>/database/bin

To import the initial metadata, run the following command:

On UNIX.

./sip_ant.sh import_system

On Windows.

sip_ant.bat import_system

Answer the prompts described in the following table:

The prompts display default text in brackets. Press

Enter

to use the default value and go to the next prompt.

Prompts	Description
Enter the 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 MDM Hub Master Database service name [orcl]	Name of the Oracle service. This prompt is displayed 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>". Do you want to change the connect URL (y/n) [n] :	Connect URL for the Oracle connection type SERVICE. You can type y to change the default connect URL. To use the default connect URL, type n .
Enter database SID	Name of the Oracle System ID. This prompt is displayed if the selected Oracle connection type is SID.
Enter master user name [cmx_system]	User name to access the MDM Hub Master Database. Default is cmx_system .
Enter master database user password	Password to access the MDM Hub Master Database.
Enter locale name from the list: de, en_US, fr, ja, ko, zh_CN. [en_US]	Operating system locale. Default is en_US .