Installation Guide for Oracle Database with Red Hat JBoss

10.4 HotFix 3

Back Next

Import the Metadata into the Operational Reference Store

After you create the

Operational Reference Store

, import the initial metadata into the

Operational Reference Store

. 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_ors

On Windows.

sip_ant.bat import_ors

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 Operational Reference Store database host name [localhost]	Name of the host that is running the database.
Enter the Operational Reference Store database port number [1521]	Port number that the database listener uses. Default is 1521 .
Enter the Operational Reference Store database service name	Name of the Oracle service. This prompt is displayed if the selected Oracle connection type is SERVICE.
Enter Oracle Net connect identifier (TNS Name). [orcl]	TNS name that is used to connect to the Oracle database. Default is orcl .
ORS DB 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 the Operational Reference Store database user name [cmx_ors]	User name to access the Operational Reference Store. Default is cmx_ors .
Enter the Operational Reference Store database user password	Password to access the Operational Reference Store.
Enter locale name from the list: de, en_US, fr, ja, ko, zh_CN. [en_US]	Operating system locale. Default is en_US .
Enter the integer code of Operational Reference Store Timeline Granularity: Year 5, Month 4, Day 3, Hour 2, Minute 1, Second 0 [3]	Specify timeline units to use. Default is days. The timeline granularity that you configure cannot be modified later. For more information about timeline, see the Multidomain MDM Configuration Guide .