暂无图片
暂无图片
1
暂无图片
暂无图片
暂无图片

oracle rac 11g打补丁打到一半异常中断数据库无法启动

原创 伟鹏 2023-10-26
251

1、在其中一个节点,正常无报错:
root@rac01 bin]# cd …/OPatch
[root@rac01 OPatch]# ./opatch auto /u01/app/grid/opatch0211/32495145
Executing /u01/app/grid/product/11.2.0/grid/perl/bin/perl /u01/app/grid/product/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /u01/app/grid/opatch0211 -patchn 32495145 -paramfile /u01/app/grid/product/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/grid/product/11.2.0/grid/cfgtoollogs/opatchauto2022-02-11_22-53-20.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/grid/product/11.2.0/grid/cfgtoollogs/opatchauto2022-02-11_22-53-20.report.log

2022-02-11 22:53:20: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/grid/product/11.2.0/grid/crs/install/crsconfig_params

Stopping RAC /u01/app/oracle/product/11.2.0/db_1 …
Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully

patch /u01/app/grid/opatch0211/32495145/32328626 apply successful for home /u01/app/oracle/product/11.2.0/db_1

Stopping CRS…
The Oracle Grid Infrastructure stack failed to stop.
Resetting the status, starting CRS…

2、第二个节点打补丁过程中异常中断,之后节点无法启动,报错如下:
ORA-15025: could not open disk “/dev/asm-DATA”
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
SUCCESS: diskgroup DATA was dismounted
ERROR: diskgroup DATA was not mounted
ORA-15025: could not open disk “/dev/asm-FRA”
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
SUCCESS: diskgroup FRA was dismounted
ERROR: diskgroup FRA was not mounted
ORA-00210: cannot open the specified control file
ORA-00202: control file: ‘+FRA/sxdb/controlfile/current.256.967224223’
ORA-17503: ksfdopn:2 Failed to open file +FRA/sxdb/controlfile/current.256.967224223
ORA-15001: diskgroup “FRA” does not exist or is not mounted
ORA-15040: diskgroup is incomplete
ORA-00210: cannot open the specified control file
ORA-00202: control file: ‘+DATA/sxdb/controlfile/current.260.967224223’
ORA-17503: ksfdopn:2 Failed to open file +DATA/sxdb/controlfile/current.260.967224223
ORA-15001: diskgroup “DATA” does not exist or is not mounted
ORA-15040: diskgroup is incomplete
ORA-205 signalled during: alter database mount…

3、查看/dev下asm盘的属性
grid:asmadmin 没有问题,但是不应该没权限呀
4、查看ORACLE_HOME/bin/oracle的属主 确认是oracle:asmadmin 查看GRID_HOME/bin/oracle的属主,
发现变成了oracle:asmadmin
并且权限也不是6751
5、解决办法:
更改$GRID_HOME/bin/oracle的属主为grid:asmadmin
权限设置为6751
重新启动集群服务正常;

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论