Table of Contents

Search

  1. Preface
  2. Upgrade Overview
  3. Pre-Upgrade Tasks
  4. Database Tasks
  5. Application Server Tasks
  6. Hub Store Upgrade
  7. Hub Server Upgrade (In-place Upgrade)
  8. Process Server Upgrade (In-place Upgrade)
  9. Resource Kit Upgrade (In-place Upgrade)
  10. Post-Upgrade Tasks
  11. Search Configuration Upgrade
  12. ActiveVOS Post-Installation Tasks for the Application Server
  13. ActiveVOS Post-Upgrade Tasks for Business Entity Adapter
  14. ActiveVOS Post-Upgrade Tasks for Subject Areas Adapter
  15. Appendix A: Troubleshooting the Upgrade Process
  16. Appendix B: Frequently Asked Questions
  17. Appendix C: Processing Existing ActiveVOS Tasks
  18. Appendix D: Configuring Metadata Caching

Upgrading from Version 10.0, 10.1, 10.2, or 10.3

Upgrading from Version 10.0, 10.1, 10.2, or 10.3

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>

0 COMMENTS

We’d like to hear from you!