Create the Database Link - Intergraph Smart P&ID - 10.0 - Administration & Configuration - Intergraph

Intergraph Smart P&ID Workshare Configuration and Reference

Language
English
Product
Intergraph Smart P&ID
Search by Category
Administration & Configuration
Smart P&ID Version
10
Smart Engineering Manager Version
11
  1. On the host database server, use Oracle Net Manager to create a net service name for the host database (for example, set the name to hostbeta).

  2. On the satellite database server, use Net Manager to create a net service name for both the satellite database and the host database.

    • The net service name at the satellite site must match the net service name at the host site.

    • The database server at the host or satellite site usually has two IP addresses, one for internal and the other for external use. The database server (either the host or the satellite) should open to the IP addresses of the database servers of the other sites.

  3. Connect to the satellite database using the SQLPLUS Utility or the SQL Developer Utility on the satellite server.

  4. To create the database link, refer to Oracle documentation for dblink.

    • The database link should be created with the Connected User option. Defined in this manner, the database link user does not automatically inherit DBA privileges, but rather the database link user privileges are determined at runtime when the link is accessed by the connected user. If the connected user has credentials at the destination of the link, then those credentials determine what actions are possible via the database link with respect to the destination or remote database.

    • Another option is to create a special user with system Create Database Link privileges and then use this special user to create the database link. However, when the database link is defined with the Connected User option, the application will have the same privileges as if the database link were created using a system account.