{"id":112,"date":"2009-10-12T19:16:00","date_gmt":"2009-10-12T22:16:00","guid":{"rendered":"http:\/\/www.soudba.com.br\/?p=112"},"modified":"2009-10-12T19:16:00","modified_gmt":"2009-10-12T22:16:00","slug":"rac-ora-01102-cannot-mount-database-in-exclusive-mode","status":"publish","type":"post","link":"https:\/\/www.soudba.com.br\/?p=112","title":{"rendered":"RAC ORA-01102: cannot mount database in EXCLUSIVE mode"},"content":{"rendered":"

Por algumas vezes, quando adicionando mais grupos em um RAC aconteceu o erro:<\/p>\n

ORA-01102: cannot mount database in EXCLUSIVE mode<\/p>\n

Assim, consegui detectar que em alguns casos simplesmente efetuando o boot e em outros casos resolvendo somente colocando novamente em modo de CLUSTER atraves dos parametros abaixo:
cluster_database boolean
TRUE
cluster_database_instances integer
2<\/p>\n

veja o erro abaixo:<\/p>\n

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options<\/p>\n

SQL> show parameter cluster<\/p>\n

NAME TYPE
———————————— ———————————
VALUE
——————————
cluster_database boolean
FALSE
cluster_database_instances integer
1
cluster_interconnects string<\/p>\n

SQL> alter system set cluster_database=TRUE scope=spfile sid=’*’;<\/p>\n

System altered.<\/p>\n

SQL> alter system set cluster_database_instances=2 scope=spfile sid=’*’;<\/p>\n

System altered.<\/p>\n

SQL> shutdown immediate<\/p>\n

Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> SQL> SQL>
SQL>
SQL> startup
ORACLE instance started.<\/p>\n

Total System Global Area 583008256 bytes
Fixed Size 1220676 bytes
Variable Size 201330620 bytes
Database Buffers 373293056 bytes
Redo Buffers 7163904 bytes
Database mounted.
Database opened.
SQL> <\/p>\n

ora.eg7086.vip application ONLINE ONLINE eg7086
[oracle@eg7038 ~]$ crs_stat -t
Name Type Target State Host
————————————————————
ora….B1.inst application ONLINE OFFLINE
ora….B2.inst application ONLINE ONLINE eg7086
ora.RDBB.db application ONLINE ONLINE eg7038
ora….SM1.asm application ONLINE ONLINE eg7038
ora….38.lsnr application ONLINE ONLINE eg7038
ora.eg7038.gsd application ONLINE ONLINE eg7038
ora.eg7038.ons application ONLINE ONLINE eg7038
ora.eg7038.vip application ONLINE ONLINE eg7038
ora….SM2.asm application ONLINE ONLINE eg7086
ora….86.lsnr application ONLINE ONLINE eg7086
ora.eg7086.gsd application ONLINE ONLINE eg7086
ora.eg7086.ons application ONLINE ONLINE eg7086
ora.eg7086.vip application ONLINE ONLINE eg7086
[oracle@eg7038 ~]$ ps -ef |grep pmon
oracle 31627 1 0 20:39 ? 00:00:00 asm_pmon_+ASM1
oracle 10191 1 2 20:46 ? 00:00:00 ora_pmon_RDBB1
oracle 10484 27876 0 20:46 pts\/2 00:00:00 grep pmon
[oracle@eg7038 ~]$ sqlplus \/ as sysdba<\/p>\n

SQL*Plus: Release 10.2.0.1.0 – Production on Tue Oct 6 20:46:53 2009<\/p>\n

Copyright (c) 1982, 2005, Oracle. All rights reserved.<\/p>\n

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options<\/p>\n

SQL> show parameter thread<\/p>\n

NAME TYPE
———————————— ———————————
VALUE
——————————
parallel_threads_per_cpu integer
2
thread integer
1
SQL> show parameter cluster<\/p>\n

NAME TYPE
———————————— ———————————
VALUE
——————————
cluster_database boolean
FALSE
cluster_database_instances integer
1
cluster_interconnects string<\/p>\n

SQL> alter system set cluster_database=TRUE scope=spfile sid=’*’; <\/p>\n

System altered.<\/p>\n

SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01102: cannot mount database in EXCLUSIVE mode<\/p>\n

SQL> alter system set cluster_database_instances=2 scope=spfile;<\/p>\n

System altered.<\/p>\n

SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01102: cannot mount database in EXCLUSIVE mode<\/p>\n

SQL> shutdown immediate;
ORA-01507: database not mounted<\/p>\n

ORACLE instance shut down.
SQL> startup
ORA-29707: inconsistent value 2 for initialization parameter cluster_database_instances with other instances
SQL> alter system set cluster_database_instances=2 scope=spfile sid=’*’;
alter system set cluster_database_instances=2 scope=spfile sid=’*’
*
ERROR at line 1:
ORA-01034: ORACLE not available<\/p>\n

SQL> startup nomount;
ORA-29707: inconsistent value 2 for initialization parameter cluster_database_instances with other instances
SQL> shutdown immediate;
ORA-01012: not logged on
SQL> conn \/ as sysdba
Connected to an idle instance.
SQL> startup
ORA-29707: inconsistent value 2 for initialization parameter cluster_database_instances with other instances
SQL> conn \/ as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.<\/p>\n

Total System Global Area 583008256 bytes
Fixed Size 1220676 bytes
Variable Size 222302140 bytes
Database Buffers 352321536 bytes
Redo Buffers 7163904 bytes
Database mounted.
Database opened.
SQL><\/p>\n","protected":false},"excerpt":{"rendered":"

Por algumas vezes, quando adicionando mais grupos em um RAC aconteceu o erro: ORA-01102: cannot mount database in EXCLUSIVE mode Assim, consegui detectar que em alguns casos simplesmente efetuando o boot e em outros casos resolvendo somente colocando novamente em … Continue lendo →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[185,186,233],"tags":[],"class_list":["post-112","post","type-post","status-publish","format-standard","hentry","category-ora-01102","category-ora-01102-cannot-mount-database-in-exclusive-mode","category-rac-ora-01102-cannot-mount-database-in-exclusive-mode"],"_links":{"self":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts\/112","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=112"}],"version-history":[{"count":0,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts\/112\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=112"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=112"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}