Multidomain MDM
- Multidomain MDM 10.3 HotFix 1
- All Products
Tasks
| Description
|
---|---|
Grant privileges to the database administrative user
| If you want to use a database administrative user to create the MDM Hub Master Database and the Operational Reference Store, grant privileges to the database administrative user. The user must have the privileges to grant options for distributed transactions and
DBMS_LOCK .
To grant privileges to the database administrative user, connect to the database as a user with privileges to grant options, and run the following SQL statements:
|
Add the Oracle TNS name
| For connections to the Oracle database, add TNS name entries to the
tnsnames.ora file on the
Hub Server and
Process Server machines.
To add TNS name entries, use the following syntax:
The TNS names on the
Hub Server and
Process Server machines must be the same.
|
Test the database connection
| Test the connection to the database from each machine on which you want to run the
Hub Server or the
Process Server .
In SQL*Plus, use the following SQL statement syntax:
sqlplus <user name>/<password>@<TNS Name>
|