Enabling Oracle Global Naming - 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

Before you can create a database link, you must define the Oracle global database name global_names parameter at the host and at each satellite database site. The global database name is the full name of the database and uniquely identifies it from any other database.

The global database name is either in the form database_name.database_domain for a VPN or database_name for a DMZ, where database_name is the database name, and the database_domain is the fully qualified domain name where the database is located.  For example, if the database_domain is myserver.b30.ingr.com and myserver has a database named hostbeta, then the global_names parameter should be set to hostbeta.myserver.b30.ingr.com for a VPN or to hostbeta for a DMZ.

The global database name should have been defined during database installation and configuration. To verify that the global database name is properly defined, be sure the global_names and db_domain parameters are set properly. To determine the current global database name, run the following SQL statement:

select * from global_name;