Search

Upgrading from Version 9.7.1

Upgrading from Version 9.7.1

10.3

Back Next

Step 3. Set Up Database Privileges and Connections

Step 3. Set Up Database Privileges and Connections

Set up database privileges and connections.

The following table describes the tasks that you need to perform to set up database privileges and connections:

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: GRANT SELECT ON sys.pending_trans$ TO <DBA user> with grant option; GRANT SELECT ON sys.dba_pending_transactions TO <DBA user> with grant option; GRANT SELECT ON sys.dba_2pc_pending TO <DBA user> with grant option; GRANT EXECUTE ON sys.dbms_xa TO <DBA user> with grant option; GRANT EXECUTE ON sys.dbms_lock TO <DBA user> with grant option;
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: <TNS NAME> = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(Host = <Oracle server host name>)(Port = <Oracle server port>)) ) (CONNECT_DATA = (SERVICE_NAME = <Oracle SID>) ) ) 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>

Set Up Oracle Database

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.