oracle

推荐列表 站点导航

当前位置:首页 > 数据库 > oracle >

可能是以前修改cluster_database这个参数引起的.在oralc rac架构这个参数必须设置为TRUE. 错误

来源:网络  作者:网友投稿  发布时间:2021-01-20 21:53
启动oracle11grac数据库时呈现以下错误,只能启动个中一个节点,另一个节点启动不了,大概是以前修改cluster_database这个参...

只能启动个中一个节点, 启动oracle 11g rac数据库时呈现以下错误, Oracle. All rights reserved. Connected to an idle instance. SQL startup ORA-01102: cannot mount database in EXCLUSIVE mode --没有修改参数前报错,大概是以前修改cluster_database这个参数引起的.在oralc rac架构这个参数必需配置为TRUE. 错误信息: ORA-01102: cannot mount database in EXCLUSIVE mode 办理要领: rac1节点: SQL show parameter cluster_database; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ cluster_database boolean FALSE cluster_database_instances integer 1 SQL alter system set cluster_database=true scope=spfile; System altered. SQL shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL startup ORACLE instance started. Total System Global Area 830930944 bytes Fixed Size 2257800 bytes Variable Size 566234232 bytes Database Buffers 260046848 bytes Redo Buffers 2392064 bytes Database mounted. Database opened. SQL select open_mode from v$database; OPEN_MODE -------------------- READ WRITE SQL show parameter cluster_database; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ cluster_database boolean TRUE cluster_database_instances integer 2 SQL rac2节点: [oracle@rac2 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Thu Sep 29 10:14:16 2016 Copyright (c) 1982。

修改后启动乐成 SQL startup ORACLE instance started. Total System Global Area 830930944 bytes Fixed Size 2257800 bytes Variable Size 599788664 bytes Database Buffers 226492416 bytes Redo Buffers 2392064 bytes Database mounted. Database opened. SQL select open_mode from v$database; OPEN_MODE -------------------- READ WRITE SQL show parameter cluster_database; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ cluster_database boolean TRUE cluster_database_instances integer 2 ,另一个节点启动不了, 2013,。

相关热词:

本站内容来源于网络,如有侵权请与我们联系,我们会及时删除,我们深感抱歉!
注:本站所有信息仅供用于网络技术学习参考,学习中请遵循相关法律法规!

本文地址: https://www.juheyunku.com/sql/oracle/12946.shtml

下一篇:没有了
Copyright © www.juheyunku.com      关于 | 合作 | 声明 | 联系 | 更新 | 地图 | Tags

可能是以前修改cluster_database这个参数引起的.在oralc rac架构这个参数必须设置为TRUE. 错误

2021-01-20 编辑:网友投稿

只能启动个中一个节点, 启动oracle 11g rac数据库时呈现以下错误, Oracle. All rights reserved. Connected to an idle instance. SQL startup ORA-01102: cannot mount database in EXCLUSIVE mode --没有修改参数前报错,大概是以前修改cluster_database这个参数引起的.在oralc rac架构这个参数必需配置为TRUE. 错误信息: ORA-01102: cannot mount database in EXCLUSIVE mode 办理要领: rac1节点: SQL show parameter cluster_database; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ cluster_database boolean FALSE cluster_database_instances integer 1 SQL alter system set cluster_database=true scope=spfile; System altered. SQL shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL startup ORACLE instance started. Total System Global Area 830930944 bytes Fixed Size 2257800 bytes Variable Size 566234232 bytes Database Buffers 260046848 bytes Redo Buffers 2392064 bytes Database mounted. Database opened. SQL select open_mode from v$database; OPEN_MODE -------------------- READ WRITE SQL show parameter cluster_database; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ cluster_database boolean TRUE cluster_database_instances integer 2 SQL rac2节点: [oracle@rac2 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Thu Sep 29 10:14:16 2016 Copyright (c) 1982。

修改后启动乐成 SQL startup ORACLE instance started. Total System Global Area 830930944 bytes Fixed Size 2257800 bytes Variable Size 599788664 bytes Database Buffers 226492416 bytes Redo Buffers 2392064 bytes Database mounted. Database opened. SQL select open_mode from v$database; OPEN_MODE -------------------- READ WRITE SQL show parameter cluster_database; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ cluster_database boolean TRUE cluster_database_instances integer 2 ,另一个节点启动不了, 2013,。

本站内容来源于网络,如有侵权请与我们联系,我们会及时删除,我们深感抱歉!
注:本站所有信息仅供学习参考!
本文地址为 https://www.juheyunku.com/sql/oracle/12946.shtml

相关文章

风云图片

推荐阅读

返回oracle频道首页