当前位置：网站首页>由参数cluster_database引发的ORA-01102异常

由参数cluster_database引发的ORA-01102异常

2022-08-07 10:02:00 【51CTO】

数据库：oracle 11.2.0.4

系统：centos 7.9

环境：rac(2节点)+2个dg

问题描述：检查集群发现节点2数据库状态为instance Shutdown，如下所示：

       
       [[email protected] ~]$ crsctl stat res -t
       
--------------------------------------------------------------------------------
       
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
       
--------------------------------------------------------------------------------
       
Local Resources
       
--------------------------------------------------------------------------------
       
ora.DATA.dg
       
               ONLINE  ONLINE       hisdb1                                       
       
               ONLINE  ONLINE       hisdb2                                       
       
ora.LISTENER.lsnr
       
               ONLINE  ONLINE       hisdb1                                       
       
               ONLINE  ONLINE       hisdb2                                       
       
ora.OCR.dg
       
               ONLINE  ONLINE       hisdb1                                       
       
               ONLINE  ONLINE       hisdb2                                       
       
ora.asm
       
               ONLINE  ONLINE       hisdb1                   Started             
       
               ONLINE  ONLINE       hisdb2                   Started             
       
ora.gsd
       
               OFFLINE OFFLINE      hisdb1                                       
       
               OFFLINE OFFLINE      hisdb2                                       
       
ora.net1.network
       
               ONLINE  ONLINE       hisdb1                                       
       
               ONLINE  ONLINE       hisdb2                                       
       
ora.ons
       
               ONLINE  ONLINE       hisdb1                                       
       
               ONLINE  ONLINE       hisdb2                                       
       
--------------------------------------------------------------------------------
       
Cluster Resources
       
--------------------------------------------------------------------------------
       
ora.LISTENER_SCAN1.lsnr
       
      1        ONLINE  ONLINE       hisdb1                                       
       
ora.cvu
       
      1        ONLINE  ONLINE       hisdb1                                       
       
ora.hisdb1.vip
       
      1        ONLINE  ONLINE       hisdb1                                       
       
ora.hisdb2.vip
       
      1        ONLINE  ONLINE       hisdb2                                       
       
ora.oc4j
       
      1        ONLINE  ONLINE       hisdb2                                       
       
ora.orcl.db
       
      1        ONLINE  ONLINE       hisdb1                   Open                
       
      2        ONLINE  OFFLINE                               Instance Shutdown   
       
ora.pacs.db
       
      1        ONLINE  ONLINE       hisdb1                   Open                
       
      2        ONLINE  ONLINE       hisdb2                   Open                
       
ora.scan1.vip
       
      1        ONLINE  ONLINE       hisdb1  
      
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.

重启orcl数据库，报错ORA-01102.

       
       [[email protected] ~]$ srvctl stop database -d orcl
       
[[email protected] ~]$ srvctl start database -d orcl
       
PRCR-1079 : Failed to start resource ora.orcl.db
       
CRS-5017: The resource action "ora.orcl.db start" encountered the following error: 
       
ORA-01102: cannot mount database in EXCLUSIVE mode
       
. For details refer to "(:CLSN00107:)" in "/u01/app/11.2.0/grid/log/hisdb2/agent/crsd/oraagent_oracle/oraagent_oracle.log".
       
日志文件oraagent_oracle.log主要存在以下告警：
       
2022-08-06 23:57:12.737: [ora.orcl.db][3547522816]{1:51157:512} [clean] ORA-01034: ORACLE not available
       
ORA-27101: shared memory realm does not exist
       
Linux-x86_64 Error: 2: No such file or directory
       
Process ID: 0
       
Session ID: 0 Serial number: 0
       
……
       
CRS-2674: Start of 'ora.orcl.db' on 'hisdb2' failed
       
CRS-2632: There are no more servers to try to place resource 'ora.orcl.db' on that would satisfy its placement policy
      
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.

Change：

orcl数据库此前做过字符集的修改，曾将cluster_database参数设置为false，很可能在修改完字符集后没有将此参数修改回true.

检查节点1 pfile中该参数值.

节点1执行：

       
       节点1执行：
       
SQL> create pfile from spfile;
       
File created.
       
[[email protected] dbs]$ cat initorcl1.ora
       
*.cluster_database=FALSE  (该参数值果然是FALSE)
       
将节点1中该参数值修改为ture.
       
SQL> alter system set cluster_database=true scope=spfile sid='*';
       
System altered.
       
SQL> shutdown immediate;
       
Database closed.
       
Database dismounted.
       
ORACLE instance shut down.
       
[[email protected] ~]$ srvctl start database -d orcl   (此处成功开启orcl数据库)
       
[[email protected] ~]$ logout
       
[[email protected] ~]# su - grid
       
Last login: Sat Aug  6 23:45:37 CST 2022 on pts/2
       
[[email protected] ~]$ crsctl stat res -t
       
--------------------------------------------------------------------------------
       
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
       
--------------------------------------------------------------------------------
       
Local Resources
       
--------------------------------------------------------------------------------
       
ora.DATA.dg
       
               ONLINE  ONLINE       hisdb1                                       
       
               ONLINE  ONLINE       hisdb2                                       
       
ora.LISTENER.lsnr
       
               ONLINE  ONLINE       hisdb1                                       
       
               ONLINE  ONLINE       hisdb2                                       
       
ora.OCR.dg
       
               ONLINE  ONLINE       hisdb1                                       
       
               ONLINE  ONLINE       hisdb2                                       
       
ora.asm
       
               ONLINE  ONLINE       hisdb1                   Started             
       
               ONLINE  ONLINE       hisdb2                   Started             
       
ora.gsd
       
               OFFLINE OFFLINE      hisdb1                                       
       
               OFFLINE OFFLINE      hisdb2                                       
       
ora.net1.network
       
               ONLINE  ONLINE       hisdb1                                       
       
               ONLINE  ONLINE       hisdb2                                       
       
ora.ons
       
               ONLINE  ONLINE       hisdb1                                       
       
               ONLINE  ONLINE       hisdb2                                       
       
--------------------------------------------------------------------------------
       
Cluster Resources
       
--------------------------------------------------------------------------------
       
ora.LISTENER_SCAN1.lsnr
       
      1        ONLINE  ONLINE       hisdb1                                       
       
ora.cvu
       
      1        ONLINE  ONLINE       hisdb1                                       
       
ora.hisdb1.vip
       
      1        ONLINE  ONLINE       hisdb1                                       
       
ora.hisdb2.vip
       
      1        ONLINE  ONLINE       hisdb2                                       
       
ora.oc4j
       
      1        ONLINE  ONLINE       hisdb2                                       
       
ora.orcl.db
       
      1        ONLINE  ONLINE       hisdb1                   Open                
       
      2        ONLINE  ONLINE       hisdb2                   Open                
       
ora.pacs.db
       
      1        ONLINE  ONLINE       hisdb1                   Open                
       
      2        ONLINE  ONLINE       hisdb2                   Open                
       
ora.scan1.vip
       
      1        ONLINE  ONLINE       hisdb1                          
       
SQL> create pfile from spfile;
       
File created.
       
[[email protected] dbs]$ cat initorcl1.ora
       
*.cluster_database=TRUE  (最新pfile文件中该参数已成功修改)
      
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.

原网站

版权声明
本文为[51CTO]所创，转载请带上原文链接，感谢
https://blog.51cto.com/u_12991611/5552563

当前位置：网站首页>由参数cluster_database引发的ORA-01102异常

由参数cluster_database引发的ORA-01102异常

边栏推荐

猜你喜欢

随机推荐