Enabling Oracle Global Naming - Intergraph Smart Engineering Manager - 12 - Help - Hexagon

Intergraph Smart Engineering Manager Help

Language
English
Product
Intergraph Smart Engineering Manager
Search by Category
Help
Smart Engineering Manager Version
12

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;