解决ORA-02069: global_names parameter must be set to TRUE for this operation 问题
来源:互联网 发布:单簧管 知乎 编辑:程序博客网 时间:2024/05/16 15:12
解决ORA-02069: global_names parameter must be set to TRUE for this operation 问题
问题产生背景:
多数据库分库,在各个库之间采用dblink连接,DML操作会导致该问题的产生。
解决步骤
各个数据库设置独立地global name, 并enable global name.
select * from global_name;
alter database rename global_name to MAINDB;
修改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 =192.168.198.136)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)vi $ORACLE_HOME/network/admin/listener.ora
SID_LIST_LISTENER = (
SID_LIST = (
SID_DESC =
(GLOBAL_DBNAME = MAINDB)
(ORACLE_HOME = /db/oracle/product/11.2.0/db_1)
(SID_NAME=orcl)
)
)
各个库都要这样修改。
把DBLINK name 设置成和global name保持相同.
删除旧的db link: drop database link ORCLMAIN;
在MAINDB上建立到IPDB的link
Create database link IPDB connect to admin identified by 123
using ‘IPDB’;从库也要建立到主库的反向DBLINK,命名原则同上.
在IPDB上建立到MAINDB的link
Create database link MAINDB connect to admin identified by 123
创建表同义词
create synonym IP_RECORD for IP_RECORD@IPDB ;
http://blog.csdn.net/huzhenwei/article/details/2533869
https://dba010.wordpress.com/2011/01/05/oracle-errorsora/#ORA-02069
http://blog.csdn.net/wwwer1/article/details/7297551
- 解决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
- 关于: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
- 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
- Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added
- ora-02069 此操作的Global_names必须设置为True
- ORA-00096: invalid value for parameter plsql_compiler_flags, must be from among NON_DEBUG, DEBUG, INTERPRETED, NATIVE
- 解决android报错IllegalArgumentException: parameter must be a descendant of this view
- 【转载】Parameter must be a descendant of this view问题的解决方案
- Android解决"parameter must be a descendant of this view(参数必须是此视图的子视图 )"问题的方法
- DateTimePicker 控件出现 "You must be in ShowCheckbox mode to set to this date" 的错误
- DateTimePicker 控件出现 "You must be in ShowCheckbox mode to set to this date" 的错误
- DateTimePicker 控件出现 "You must be in ShowCheckbox mode to set to this date" 的错误
- Parameter must be a descendant of this view 错误
- could not be set to a 'string' value. You must set this property to a non-null value of type
- Name for parameter binding must not be null or empty! On JDKs < 8, you need to use @Param for named
- 用scrapy写爬虫 显示 Filtered offsite request to 错误.
- 工厂方法与抽象工厂
- android加载网络图片,圆形图片加载
- 详解spl_autoload_register()函数
- pthread多线程编程详细解析----条件变量 pthread_cond_t
- 解决ORA-02069: global_names parameter must be set to TRUE for this operation 问题
- 机器学习中特征降维和特征选择的区别
- 人工智能再攻下一城——“翻译领域赶超95%人类”【智库2861】
- DeepLearning(基于caffe)实战项目(1)--mnist_convert函数分析
- MySQL 导出数据select into outfile用法
- Git常用命令
- 逆矩阵介绍及C++/OpenCV/Eigen的三种实现
- REST架构风格
- 如何在tomcat下配置二级域名