GLOBAL DATABASE NAMES

Hi,
I'm figthing with the following Problem:

A Third Party Product (EDM-System Metaphase) requires that the init.ora Parameter global_names has to be set to FALSE. Metaphase works in a distributed oracle environment with internal synchronous replication mechanism without ORACLE Replication Features. The Metaphase replication requires the odd setting of global_names because it works with DB-Links between Schemas, not Databases. Hint: This works very fine in a worldwide distributed environment at Daimler-Benz (Germany, Brasil).

But we need a method to support asynchronous replication with ORACLE features (multi-master replication, updateble snapshots) because we want

increase the overall availability of the whole system (with synchronous replication
you need high available systems and WAN network connections all the time -
between different timezones).
The ORACLE advanced replication features requires the setting of global_names = TRUE (Working with full qualified database names and database
domains is required).

Is there any solution to
a) work with ORACLE advanced replication option and global_names = FALSE ?
or
b) set the parameter global_names session-specific for connected Metaphase Processes

     via a Package Utility like DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (sid, serial#)

     In other words: Setting global_names = TRUE instance-wide for ORACLE-Replication tasks

     and session-specific to FALSE for the connected Metaphase Processes.

     (Hint: There is absolutely no way to give the Metaphase DB-Interface-Processes a

      ALTER SESSION SET GLOBAL_NAMES = TRUE shortly after connect ! -> BlackBox)

Is there anyone out there who can help me ?

Best Regards and thanks in advance
a guy from debis in Germany (Stuttgart) Received on Mon Aug 31 1998 - 09:25:48 CDT