解决ORA-02069: global_names parameter must be set to TRUE for this operation 问题

解决ORA-02069: global_names parameter must be set to TRUE for this operation 问题

问题产生背景：

多数据库分库，在各个库之间采用dblink连接，DML操作会导致该问题的产生。

解决步骤

1. 各个数据库设置独立地global name， 并enable global name.

   

   select * from global_name;

   alter database rename global_name to MAINDB;

2. 修改tnsnames.ora 和listener.ora.

   vi $ORACLE_HOME/network/admin/tnsnames.ora

   MAINDB =
   (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.198.135)(PORT = 1521))
   (CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = orcl)
   )
   )

   IPDB =
   (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST =