当前位置： 首页 > news >正文

12.2RAC环境从RAC转为单机模式的问题处理

news 2025/8/15 17:25:45

近期，在某用户的测试环境，需要将RAC转为单机模式，然后进行数据恢复；一开始只是将数据库软件通过make -f ins_rdbms.mk rac_off  和 make -f ins_rdbms.mk ioracle关闭RAC模式；然后在启动数据库（sqlplus / as sysdba登录后startup时报错：ORA-00600: internal error code, arguments: [kgfz_getDiskAccessMode:ntyp], [0], [], [], [], [], [], [], [], [], [], []
ORA-29701: unable to connect to Cluster Synchronization Service）；

MOS文档Database reports ORA-600 KGFZ_GETDISKACCESSMODE:NTYP when starting (Doc ID 2587331.1)显示，12.2开始需要彻底卸载集群，进行卸载后可以正常进行启动和恢复（卸载参考How to Deconfigure/Reconfigure(Rebuild OCR) or Deinstall Grid Infrastructure (Doc ID 1377349.1)，注意Note: in 12c, or higher, while performing the procedure, instead of rootcrs.pl, rootcrs.sh should be used if exists in the same location as rootcrs.pl）。

处理过程如下：

1.数据库软件从集群转为单机模式

[oracle@test1 lib]$ make -f ins_rdbms.mk rac_off
rm -f /home/u01/app/product/12.2.0/db_1/lib/libskgxp12.so
cp /home/u01/app/product/12.2.0/db_1/lib//libskgxpg.so /home/u01/app/product/12.2.0/db_1/lib/libskgxp12.so
rm -f /home/u01/app/product/12.2.0/db_1/lib/libskgxn2.so
cp /home/u01/app/product/12.2.0/db_1/lib//libskgxns.so \/home/u01/app/product/12.2.0/db_1/lib/libskgxn2.so
/usr/bin/ar cr /home/u01/app/product/12.2.0/db_1/rdbms/lib/libknlopt.a /home/u01/app/product/12.2.0/db_1/rdbms/lib/ksnkcs.o 
[oracle@test1 lib]$ make -f ins_rdbms.mk ioracle
chmod 755 /home/u01/app/product/12.2.0/db_1/bin- Linking Oracle 
rm -f /home/u01/app/product/12.2.0/db_1/rdbms/lib/oracle
/home/u01/app/product/12.2.0/db_1/bin/orald  -o /home/u01/app/product/12.2.0/db_1/rdbms/lib/oracle -m64 -z noexecstack -Wl,--disable-new-dtags -L/home/u01/app/product/12.2.0/db_1/rdbms/lib/ -L/home/u01/app/product/12.2.0/db_1/lib/ -L/home/u01/app/product/12.2.0/db_1/lib/stubs/   -Wl,-E /home/u01/app/product/12.2.0/db_1/rdbms/lib/opimai.o /home/u01/app/product/12.2.0/db_1/rdbms/lib/ssoraed.o /home/u01/app/product/12.2.0/db_1/rdbms/lib/ttcsoi.o -Wl,--whole-archive -lperfsrv12 -Wl,--no-whole-archive /home/u01/app/product/12.2.0/db_1/lib/nautab.o /home/u01/app/product/12.2.0/db_1/lib/naeet.o /home/u01/app/product/12.2.0/db_1/lib/naect.o /home/u01/app/product/12.2.0/db_1/lib/naedhs.o /home/u01/app/product/12.2.0/db_1/rdbms/lib/config.o  -ldmext -lserver12 -lodm12 -lofs -lcell12 -lnnet12 -lskgxp12 -lsnls12 -lnls12  -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lclient12  -lvsn12 -lcommon12 -lgeneric12 -lknlopt `if /usr/bin/ar tv /home/u01/app/product/12.2.0/db_1/rdbms/lib/libknlopt.a | grep xsyeolap.o > /dev/null 2>&1 ; then echo "-loraolap12" ; fi` -lskjcx12 -lslax12 -lpls12  -lrt -lplp12 -ldmext -lserver12 -lclient12  -lvsn12 -lcommon12 -lgeneric12 `if [ -f /home/u01/app/product/12.2.0/db_1/lib/libavserver12.a ] ; then echo "-lavserver12" ; else echo "-lavstub12"; fi` `if [ -f /home/u01/app/product/12.2.0/db_1/lib/libavclient12.a ] ; then echo "-lavclient12" ; fi` -lknlopt -lslax12 -lpls12  -lrt -lplp12 -ljavavm12 -lserver12  -lwwg  `cat /home/u01/app/product/12.2.0/db_1/lib/ldflags`    -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lngsmshd12 -lnro12 `cat /home/u01/app/product/12.2.0/db_1/lib/ldflags`    -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lngsmshd12 -lnnzst12 -lzt12 -lztkg12 -lmm -lsnls12 -lnls12  -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lztkg12 `cat /home/u01/app/product/12.2.0/db_1/lib/ldflags`    -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lngsmshd12 -lnro12 `cat /home/u01/app/product/12.2.0/db_1/lib/ldflags`    -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lngsmshd12 -lnnzst12 -lzt12 -lztkg12   -lsnls12 -lnls12  -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 `if /usr/bin/ar tv /home/u01/app/product/12.2.0/db_1/rdbms/lib/libknlopt.a | grep "kxmnsd.o" > /dev/null 2>&1 ; then echo " " ; else echo "-lordsdo12 -lserver12"; fi` -L/home/u01/app/product/12.2.0/db_1/ctx/lib/ -lctxc12 -lctx12 -lzx12 -lgx12 -lctx12 -lzx12 -lgx12 -lordimt12 -lclsra12 -ldbcfg12 -lhasgen12 -lskgxn2 -lnnzst12 -lzt12 -lxml12 -lgeneric12 -locr12 -locrb12 -locrutl12 -lhasgen12 -lskgxn2 -lnnzst12 -lzt12 -lxml12 -lgeneric12  -lgeneric12 -lorazip -loraz -llzopro5 -lorabz2 -lipp_z -lipp_bz2 -lippdcemerged -lippsemerged -lippdcmerged  -lippsmerged -lippcore  -lippcpemerged -lippcpmerged  -lsnls12 -lnls12  -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lsnls12 -lunls12  -lsnls12 -lnls12  -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lasmclnt12 -lcommon12 -lcore12  -laio -lons  -lfthread12   `cat /home/u01/app/product/12.2.0/db_1/lib/sysliblist` -Wl,-rpath,/home/u01/app/product/12.2.0/db_1/lib -lm    `cat /home/u01/app/product/12.2.0/db_1/lib/sysliblist` -ldl -lm   -L/home/u01/app/product/12.2.0/db_1/lib `test -x /usr/bin/hugeedit -a -r /usr/lib64/libhugetlbfs.so && test -r /home/u01/app/product/12.2.0/db_1/rdbms/lib/shugetlbfs.o && echo -Wl,-zcommon-page-size=2097152 -Wl,-zmax-page-size=2097152 -lhugetlbfs`
test ! -f /home/u01/app/product/12.2.0/db_1/bin/oracle || (\mv -f /home/u01/app/product/12.2.0/db_1/bin/oracle /home/u01/app/product/12.2.0/db_1/bin/oracleO &&\chmod 600 /home/u01/app/product/12.2.0/db_1/bin/oracleO )
mv /home/u01/app/product/12.2.0/db_1/rdbms/lib/oracle /home/u01/app/product/12.2.0/db_1/bin/oracle
chmod 6751 /home/u01/app/product/12.2.0/db_1/bin/oracle

2.启动数据库实例时的报错

[oracle@test1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 12.2.0.1.0 Production on Fri Sep 8 18:33:57 2023Copyright (c) 1982, 2016, Oracle.  All rights reserved.Connected to an idle instance.SQL> 
SQL> 
SQL> startup nomount
ORA-00600: internal error code, arguments: [kgfz_getDiskAccessMode:ntyp], [0], [], [], [], [], [], [], [], [], [], []
ORA-29701: unable to connect to Cluster Synchronization Service
SQL> exit
Disconnected

3.对集群软件进行卸载时的报错及日志--12C开始需要用Note: in 12c, or higher, while performing the procedure, instead of rootcrs.pl, rootcrs.sh should be used if exists in the same location as rootcrs.pl

[root@test1 ~]# /home/u01/grid/crs/install/rootcrs.pl -deconfig -force -verbose
Can't locate Env.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 . /home/u01/grid/crs/install /home/u01/grid/crs/install/../../perl/lib) at /home/u01/grid/crs/install/crsinstall.pm line 286.
BEGIN failed--compilation aborted at /home/u01/grid/crs/install/crsinstall.pm line 286.
Compilation failed in require at /home/u01/grid/crs/install/rootcrs.pl line 165.
BEGIN failed--compilation aborted at /home/u01/grid/crs/install/rootcrs.pl line 165.
[root@test1 ~]# /home/u01/grid/crs/install/rootcrs.pl -deconfig -force -verbose -lastnode
Can't locate Env.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 . /home/u01/grid/crs/install /home/u01/grid/crs/install/../../perl/lib) at /home/u01/grid/crs/install/crsinstall.pm line 286.
BEGIN failed--compilation aborted at /home/u01/grid/crs/install/crsinstall.pm line 286.
Compilation failed in require at /home/u01/grid/crs/install/rootcrs.pl line 165.
BEGIN failed--compilation aborted at /home/u01/grid/crs/install/rootcrs.pl line 165.
[root@test1 ~]# /home/u01/grid/crs/install/rootcrs.sh -deconfig -force -verbose -lastnode
Using configuration parameter file: /home/u01/grid/crs/install/crsconfig_params
The log of current session can be found at:/home/u01/gridbase/crsdata/test1/crsconfig/crsdeconfig_test1_2023-09-08_06-43-59PM.log
PRCR-1070 : Failed to check if resource ora.cvu is registeredCRS-0184 : Cannot communicate with the CRS daemon.2023/09/08 18:44:10 CLSRSC-180: An error occurred while executing the command '/home/u01/grid/bin/srvctl stop cvu -f'
PRCR-1070 : Failed to check if resource ora.cvu is registeredCRS-0184 : Cannot communicate with the CRS daemon.2023/09/08 18:44:10 CLSRSC-180: An error occurred while executing the command '/home/u01/grid/bin/srvctl remove cvu -f'
PRCR-1068 : Failed to query resourcesCRS-0184 : Cannot communicate with the CRS daemon.2023/09/08 18:44:11 CLSRSC-180: An error occurred while executing the command '/home/u01/grid/bin/srvctl stop scan_listener -f'
PRCR-1068 : Failed to query resourcesCRS-0184 : Cannot communicate with the CRS daemon.2023/09/08 18:44:11 CLSRSC-180: An error occurred while executing the command '/home/u01/grid/bin/srvctl remove scan_listener -y -f'
PRCR-1068 : Failed to query resources
CRS-0184 : Cannot communicate with the CRS daemon.
2023/09/08 18:44:12 CLSRSC-180: An error occurred while executing the command '/home/u01/grid/bin/srvctl stop scan -f'
PRCR-1068 : Failed to query resources
CRS-0184 : Cannot communicate with the CRS daemon.
2023/09/08 18:44:13 CLSRSC-180: An error occurred while executing the command '/home/u01/grid/bin/srvctl remove scan -y -f'
PRCR-1070 : Failed to check if resource ora.net1.network is registered
CRS-0184 : Cannot communicate with the CRS daemon.
PRCR-1070 : Failed to check if resource ora.helper is registered
CRS-0184 : Cannot communicate with the CRS daemon.
PRCR-1070 : Failed to check if resource ora.ons is registered
CRS-0184 : Cannot communicate with the CRS daemon.2023/09/08 18:44:13 CLSRSC-180: An error occurred while executing the command '/home/u01/grid/bin/srvctl config nodeapps'

http://www.lryc.cn/news/159863.html

相关文章：

  • Docker 中 jdk8容器里无法使用 JDK 的 jmap 等命令的问题
  • typeScript--[es6class类实现继承]
  • 解决eclipse的报错：Must declare a named package because this compilation
  • linux sed常用各种操作大全
  • 通过 Keycloak 结合 OAuth2.0协议进行 Amazon API Gateway 鉴权
  • 修复中间件log4j漏洞方案(直接更换漏洞jar包)
  • 怎么压缩pdf文件大小？详细压缩步骤
  • php 安装rabbitmq：如何使用 PHP 安装 RabbitMQ？
  • 算法训练营day44|动态规划 part06：完全背包 (完全背包、 LeetCode518. 零钱兑换 II、377. 组合总和 Ⅳ )
  • 包管理工具--》其他包管理器之cnpm、pnpm、nvm
  • 线性代数的学习和整理22：矩阵的点乘（草稿）
  • 如何在Windows中使用C#填写和提取PDF表单
  • microsoft.office.interop.word 怎样 读取 某个汉字 字体颜色为红色
  • 第二十二章 Classes - 调用类方法的快捷方式
  • 标准C++day2——函数重载、默认形参和引用
  • Qt5下遍历QList的方法
  • Leetcode 剑指 Offer II 043. 完全二叉树插入器
  • 链路追踪Skywalking应用实战
  • 提升你的Android开发技能：从AR/VR沉浸到UI设计和故障排除
  • Arm 架构 Ubuntu 使用 Docker 安装 Gitlab 并使用
  • 百度地图3D棱柱鼠标事件
  • PHP调用java class 类实现文件签名
  • 信号和槽机制
  • 计算机视觉领域经典模型汇总（2023.09.08
  • 华为云云耀云服务器L实例评测｜在 Centos Docker 中使用Nginx部署Vue项目
  • 高频知识汇总 |【计算机网络】面试题汇总（万字长文通俗易懂）
  • 6.Flask-APScheduler定时任务框架
  • 电脑入门：路由器访问控制列表基础知识
  • 目标检测笔记(十四): 使用YOLOv8完成对图像的目标检测任务（从数据准备到训练测试部署的完整流程）
  • windows系统edge浏览器退出账户后还能免密登录的解决方式