ORACLE RAC安装问题解决记录(5)- 未设置cluster_database导致 ORA-01102 cannot mount database in EXCLUSIVE mode
来源:互联网 发布:七日杀捏脸数据站 编辑:程序博客网 时间:2024/06/05 15:21
系统环境
主机:Window2003R2 SP2 VMWare Server1.0.5装了两台WINDOWS2008
每台机器768M内存
其上装了Oracle11g(11.1.0.6) For Windows32
主机:Window2003R2 SP2 VMWare Server1.0.5装了两台WINDOWS2008
每台机器768M内存
其上装了Oracle11g(11.1.0.6) For Windows32
两台机器的RAC数据库启动参数如下:
*.audit_file_dest='C:/oracle/admin/rawrac/adump'
*.audit_trail='db'
*.cluster_database_instances=2
*.compatible='11.1.0.0.0'
*.control_files='c:/raw/oradata/rawrac/control01.ctl','c:/raw/oradata/rawrac/control02.ctl','c:/raw/oradata/rawrac/control03.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='rawrac'
*.diagnostic_dest='C:/oracle'
rawrac1.instance_number=1
rawrac2.instance_number=2
*.memory_target=384827392
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='exclusive'
rawrac2.thread=2
rawrac1.thread=1
rawrac1.undo_tablespace='UNDOTBS1'
rawrac2.undo_tablespace='UNDOTBS2'
*.audit_trail='db'
*.cluster_database_instances=2
*.compatible='11.1.0.0.0'
*.control_files='c:/raw/oradata/rawrac/control01.ctl','c:/raw/oradata/rawrac/control02.ctl','c:/raw/oradata/rawrac/control03.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='rawrac'
*.diagnostic_dest='C:/oracle'
rawrac1.instance_number=1
rawrac2.instance_number=2
*.memory_target=384827392
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='exclusive'
rawrac2.thread=2
rawrac1.thread=1
rawrac1.undo_tablespace='UNDOTBS1'
rawrac2.undo_tablespace='UNDOTBS2'
问题现象:
两台机器都可以独立运行,但是不能同时运行。
当一台机器启动后,另一台机器启动时报如下错误:
两台机器都可以独立运行,但是不能同时运行。
当一台机器启动后,另一台机器启动时报如下错误:
SQL>startup nomount;
ORA-01102: cannot mount database in EXCLUSIVE mode
SQL>
ORA-01102: cannot mount database in EXCLUSIVE mode
SQL>
问题原因:
由于是采用一台一台机器手动建库并手动配置RAC的方式
在初始化参数里忘记了设置cluster_database=true
解决方法:
使用如下命令设置cluster_database=true
使用如下命令设置cluster_database=true
alter system set cluster_database=true scope=spfile sid='*';
如果两个节点的spfile或pfile不在一起,需要在两个节点上都设置。
本来以为设置cluster_database_instances大于1就是RAC了,没想到一定要设置cluster_database=true,看来理解得有点问题。
- ORACLE RAC安装问题解决记录(5)- 未设置cluster_database导致 ORA-01102 cannot mount database in EXCLUSIVE mode
- Oracle ORA-01102故障: cannot mount database in EXCLUSIVE mode
- 【oracle案例】ORA-01102: cannot mount database in EXCLUSIVE mode
- ORA-01102: cannot mount database in EXCLUSIVE mode- DB关闭后进程未彻底停止
- ORA-01102: cannot mount database in EXCLUSIVE mode
- ORA-01102: cannot mount database in EXCLUSIVE mode
- ORA-01102: cannot mount database in exclusive mode
- ORA-01102: cannot mount database in EXCLUSIVE mode - Linux Servers
- ORA-01102: cannot mount database in EXCLUSIVE mode
- ORA-01102: cannot mount database in EXCLUSIVE mode
- ORA-01102: cannot mount database in EXCLUSIVE mode
- ORA-01102: cannot mount database in EXCLUSIVE mode
- ora-01102:cannot mount database in exclusive mode
- ORA-01102: cannot mount database in EXCLUSIVE mode处理方法
- ORA-01102: cannot mount database in EXCLUSIVE mode
- ORA-01102: cannot mount database in EXCLUSIVE mode
- ORA-01102: cannot mount database in EXCLUSIVE mode
- ORA-01102: cannot mount database in EXCLUSIVE mode
- 猫的成绩应该被确认
- Java 泛型的理解与等价实现
- application session cookie
- 五子棋游戏开发点滴-(一)
- java经典面试题
- ORACLE RAC安装问题解决记录(5)- 未设置cluster_database导致 ORA-01102 cannot mount database in EXCLUSIVE mode
- iReport+jasperReports制作WEB报表
- 尼康介绍
- 一个事务的例子
- 地震 级别 烈度 测算
- Google 开始虚化街景中的人物面部
- MS office系列MS office最实用的快捷键最实用的快捷键
- MiddleGen完全配置
- 地震、海啸是怎么发生的,它们的级别怎样确定?