Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Multidomain MDM 10.5
  • All Products

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. Hierarchies Upgrade
  13. ActiveVOS Post-Installation Tasks for the Application Server
  14. ActiveVOS Post-Upgrade Tasks for Business Entity Adapter
  15. ActiveVOS Post-Upgrade Tasks for Subject Areas Adapter
  16. Appendix A: Troubleshooting the Upgrade Process
  17. Appendix B: Frequently Asked Questions
  18. Appendix C: Processing Existing ActiveVOS Tasks
  19. Appendix D: Configuring Metadata Caching

Upgrading from Version 10.1, 10.2, 10.3, or 10.4

Upgrading from Version 10.1, 10.2, 10.3, or 10.4

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>
0 COMMENTS
We’d like to hear from you!