重庆思庄Oracle、Redhat认证学习论坛

标题: oracle 11g rac启动报错ORA-01102: cannot mount database in ... [打印本页]

作者: jiawang 时间: 2022-9-1 11:01
标题: oracle 11g rac启动报错ORA-01102: cannot mount database in ...
本帖最后由 jiawang 于 2022-9-2 08:52 编辑

报错现象：启动oracle 11g rac数据库时出现以下错误,只能启动其中一个节点,另一个节点启动不了，可能是以前修改cluster_database这个参数引起的.在oralc rac架构这个参数必须设置为TRUE.

Rac01节点: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 1068937216 bytes
Fixed Size                2260088 bytes
Variable Size          734004104 bytes
Database Buffers       327155712 bytes
Redo Buffers             5517312 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

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)