标签云
asm 恢复 asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 kfed MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-01110 ORA-01555 ORA-01578 ORA-08103 ORA-600 2662 ORA-600 2663 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 ORACLE恢复 Oracle 恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (100)
- 数据库 (1,598)
- DB2 (22)
- MySQL (70)
- Oracle (1,463)
- Data Guard (49)
- EXADATA (7)
- GoldenGate (21)
- ORA-xxxxx (158)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (13)
- ORACLE 21C (3)
- Oracle ASM (65)
- Oracle Bug (7)
- Oracle RAC (47)
- Oracle 安全 (6)
- Oracle 开发 (27)
- Oracle 监听 (27)
- Oracle备份恢复 (530)
- Oracle安装升级 (84)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (75)
- PostgreSQL (18)
- PostgreSQL恢复 (6)
- SQL Server (27)
- SQL Server恢复 (8)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (36)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (19)
-
最近发表
- PostgreSQL解析wal日志之—walminer
- Oracle 19c/21c最新patch信息-202404
- PostgreSQL恢复系列:pg_filedump批量处理
- PostgreSQL部分主要字典信息
- PostgreSQL恢复系列:pg_filedump恢复字典构造
- PostgreSQL 16 源码安装
- ORA-00742 ORA-00312 恢复
- 数据库open成功后报ORA-00353 ORA-00354错误引起的一系列问题(本质ntfs文件系统异常)
- ORA-600 ktsiseginfo1故障
- ORA-00600: internal error code, arguments: [16703], [1403], [4] 原因
- 最近遇到几起ORA-600 16703故障(tab$被清空),请引起重视
- ORA-600 2662快速恢复之Patch scn工具
- TNS-12518: TNS:listener could not hand off client connection
- ora.storage无法启动报ORA-12514故障处理
- 断电引起文件scn异常数据库恢复
- ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
- .[hudsonL@cock.li].mkp勒索加密数据库完美恢复
- 模拟带库实现rman远程备份
- 又一例:ORA-600 kclchkblk_4和2662故障
- Oracle误删除数据文件恢复
分类目录归档:Oracle RAC
私网直连后遗症:一节点无法启动导致另外节点haip无法启动
该案例为两节点rac(11.2.0.4),private 网络使用直连方式,其中一个节点主机异常无法启动,另外一个节点集群启动发现haip无法正常启动
# crsctl stat res -t -init -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.asm 1 ONLINE ONLINE xifenfei1 Started ora.cluster_interconnect.haip >>>> OFFLINE 1 ONLINE OFFLINE ora.crf 1 ONLINE ONLINE xifenfei1 ora.crsd 1 ONLINE OFFLINE >>>> OFFLINE ora.cssd 1 ONLINE ONLINE xifenfei1 ora.cssdmonitor 1 ONLINE ONLINE xifenfei1 ora.ctssd 1 ONLINE ONLINE xifenfei1 OBSERVER ora.diskmon 1 OFFLINE OFFLINE ora.drivers.acfs 1 ONLINE ONLINE xifenfei1 ora.evmd 1 ONLINE INTERMEDIATE xifenfei1 ora.gipcd 1 ONLINE ONLINE xifenfei1 ora.gpnpd 1 ONLINE ONLINE xifenfei1 ora.mdnsd 1 ONLINE ONLINE xifenfei1
alerthostname日志
2018-09-02 10:38:56.767: [/u01/app/11.2.0/grid/bin/orarootagent.bin(7866)]CRS-5818:Aborted command 'start' for resource 'ora.cluster_interconnect.haip'. Details at (:CRSAGF00113:) {0:0:2} in /u01/app/11.2.0/grid/log/xifenfei1/agent/ohasd/orarootagent_root/orarootagent_root.log. 2018-09-02 10:39:00.771: [ohasd(7495)]CRS-2757:Command 'Start' timed out waiting for response from the resource 'ora.cluster_interconnect.haip'. Details at (:CRSPE00111:) {0:0:2} in /u01/app/11.2.0/grid/log/xifenfei1/ohasd/ohasd.log. 2018-09-02 10:40:00.802: [/u01/app/11.2.0/grid/bin/orarootagent.bin(7866)]CRS-5818:Aborted command 'start' for resource 'ora.cluster_interconnect.haip'. Details at (:CRSAGF00113:) {0:0:2} in /u01/app/11.2.0/grid/log/xifenfei1/agent/ohasd/orarootagent_root/orarootagent_root.log. 2018-09-02 10:40:04.806: [ohasd(7495)]CRS-2757:Command 'Start' timed out waiting for response from the resource 'ora.cluster_interconnect.haip'. Details at (:CRSPE00111:) {0:0:2} in /u01/app/11.2.0/grid/log/xifenfei1/ohasd/ohasd.log.
orarootagent_root日志
2018-09-02 10:37:56.805: [ USRTHRD][3650455296]{0:0:2} No HAIP info configured in GPNP, using defaults 2018-09-02 10:37:56.805: [ USRTHRD][3650455296]{0:0:2} The final CIDR subnet 169.254/16 2018-09-02 10:37:56.805: [ default][3650455296]clsvactversion:4: Retrieving Active Version from local storage. 2018-09-02 10:37:56.809: [ USRTHRD][3650455296]{0:0:2} HAIP: mbr num is 0. [ CLWAL][3650455296]clsw_Initialize: OLR initlevel [70000] 2018-09-02 10:37:56.843: [ USRTHRD][3650455296]{0:0:2} HAIP: initializing to 1 interfaces 2018-09-02 10:37:56.844: [ USRTHRD][3650455296]{0:0:2} HAIP: configured to use 1 interfaces
gipcd.log日志
2018-09-02 10:38:56.787: [ CLSINET][2477147904] Returning NETDATA: 0 interfaces 2018-09-02 10:38:56.988: [GIPCDCLT][2477147904] gipcdClientInterfaceRequest: sent local interface list back to client 2018-09-02 10:38:56.822: [GIPCHDEM][2468742912] gipchaDaemonInfRequest: sent local interfaceRequest, hctx 0x1369730 [0000000000000010] { gipchaContext : host 'xifenfei1', name 'gipcd_ha_name', luid '184dd356-00000000', numNode 0, numInf 0, usrFlags 0x0, flags 0x63 } to gipcd 2018-09-02 10:38:56.822: [GIPCDCLT][2477147904] gipcdClientThread: req from local client of type gipcdmsgtypeInterfaceRequest, endp 00000000000002cb 2018-09-02 10:38:56.822: [GIPCDCLT][2477147904] gipcdClientInterfaceRequest: Received type(gipcdmsgtypeInterfaceRequest), endp(00000000000002cb), len(1032), buf(0x7fab858b7a78):[hostname(xifenfei1), retStatus(gipcretSuccess)] 2018-09-02 10:38:56.822: [GIPCDCLT][2477147904] gipcdClientInterfaceQueryToMonitor: enqueue local interface query (2) to worklist 2018-09-02 10:38:56.823: [GIPCDCLT][2477147904] gipcdClientInterfaceRequest: sent local interface query 2018-09-02 10:38:56.823: [GIPCDMON][2472945408] gipcdMonitorCheckXfer: set new infQuery 2018-09-02 10:38:56.831: [ GIPCLIB][2477147904] gipclibSetTraceLevel: to set level to 0
ohasd.log日志
2018-09-02 10:38:52.494: [GIPCHDEM][1878710016]gipchaDaemonInfRequest: sent local interfaceRequest, hctx 0x2749eb0 [0000000000000010] { gipchaContext : host 'xifenfei1', name 'CLSFRAME_oracler-cluster', luid '47624c02-00000000', numNode 0, numInf 0, usrFlags 0x0, flags 0x63 } to gipcd 2018-09-02 10:38:57.255: [ AGFW][3305629440]{0:0:2} Received the reply to the message: RESOURCE_START[ora.cluster_interconnect.haip 1 1] ID 4098:502 from the agent /u01/app/11.2.0/grid/bin/orarootagent_root 2018-09-02 10:38:57.255: [ AGFW][3305629440]{0:0:2} Agfw Proxy Server sending the reply to PE for message:RESOURCE_START[ora.cluster_interconnect.haip 1 1] ID 4098:500 2018-09-02 10:38:57.255: [ CRSPE][3295123200]{0:0:2} Received reply to action [Start] message ID: 500 2018-09-02 10:38:57.256: [ CRSPE][3295123200]{0:0:2} Got agent-specific msg: CRS-5017: The resource action "ora.cluster_interconnect.haip start" encountered the following error: Start action for HAIP aborted. For details refer to "(:CLSN00107:)" in "/u01/app/11.2.0/grid/log/xifenfei1/agent/ohasd/orarootagent_root/orarootagent_root.log". 2018-09-02 10:38:57.500: [GIPCHDEM][1878710016]gipchaDaemonInfRequest: sent local interfaceRequest, hctx 0x2749eb0 [0000000000000010] { gipchaContext : host 'xifenfei1', name 'CLSFRAME_oracler-cluster', luid '47624c02-00000000', numNode 0, numInf 0, usrFlags 0x0, flags 0x63 } to gipcd
检查私网状态,发现eth2网络链路状态为down,由于网络直连,而另外一台机器无法启动
[root@xifenfei1 rules.d]# ethtool eth1 Settings for eth1: Supported ports: [ TP ] Supported link modes: 10baseT/Half 10baseT/Full 100baseT/Half 100baseT/Full 1000baseT/Full Supported pause frame use: Symmetric Supports auto-negotiation: Yes Advertised link modes: 10baseT/Half 10baseT/Full 100baseT/Half 100baseT/Full 1000baseT/Full Advertised pause frame use: Symmetric Advertised auto-negotiation: Yes Speed: Unknown! Duplex: Unknown! (255) Port: Twisted Pair PHYAD: 1 Transceiver: internal Auto-negotiation: on MDI-X: Unknown Supports Wake-on: d Wake-on: d Current message level: 0x00000007 (7) drv probe link Link detected: no ====>网卡链路状态异常 [root@xifenfei1 rules.d]# ifconfig eth0 Link encap:Ethernet HWaddr 6C:92:BF:2B:7B:36 inet addr:10.10.17.42 Bcast:172.17.17.255 Mask:255.255.255.0 inet6 addr: fe80::6e92:bfff:fe2b:7b36/64 Scope:Link UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 --------->注意 RX packets:234424 errors:0 dropped:0 overruns:0 frame:0 TX packets:160916 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:16926236 (16.1 MiB) TX bytes:24269882 (23.1 MiB) Memory:91160000-91180000 eth1 Link encap:Ethernet HWaddr 6C:92:BF:2B:7B:37 inet addr:11.1.1.2 Bcast:11.1.1.255 Mask:255.255.255.0 UP BROADCAST MULTICAST MTU:1500 Metric:1 --------->注意少了RUNNING RX packets:0 errors:0 dropped:0 overruns:0 frame:0 TX packets:0 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:0 (0.0 b) TX bytes:0 (0.0 b) Memory:91140000-91160000
关于网卡链路异常导致haip无法启动的mos描述请参考:CRSD & HAIP Resources Remain In OFFLINE as Private Network Interface is Partially Up (Doc ID 1529721.1).该案例是11.2集群私网使用直连引起的直接后遗症(非常不建议集群私网使用直连方式)
oracle rac 12.2 执行root.sh报CLSRSC-400
在redhat 7.3版本中安装oracle rac 12.2的过程中,执行root.sh脚本的第14步的时候报如下错误,导致无法继续
CLSRSC-400: A system reboot is required to continue installing.
The command ‘/u01/app/grid/product/12.2.0/grid/perl/bin/perl -I/u01/app/grid/product/12.2.0/grid/perl/lib
-I/u01/app/grid/product/12.2.0/grid/crs/install /u01/app/grid/product/12.2.0/grid/crs/install/rootcrs.pl ‘ execution failed
os版本信息
[grid@xifenfei01 ~]$ more /etc/redhat-release Red Hat Enterprise Linux Server release 7.3 (Maipo) [grid@xifenfei01 ~]$ uname -a Linux xifenfei01 3.10.0-514.el7.x86_64 #1 SMP Wed Oct 19 11:24:13 EDT 2016 x86_64 x86_64 x86_64 GNU/Linux
root.sh报错
[root@xifenfei01 ~]# /u01/app/grid/oraInventory/orainstRoot.sh Changing permissions of /u01/app/grid/oraInventory. Adding read,write permissions for group. Removing read,write,execute permissions for world. Changing groupname of /u01/app/grid/oraInventory to oinstall. The execution of the script is complete. [root@xifenfei01 ~]# /u01/app/grid/product/12.2.0/grid/root.sh Performing root user operation. The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /u01/app/grid/product/12.2.0/grid Enter the full pathname of the local bin directory: [/usr/local/bin]: Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ... Creating /etc/oratab file... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. Relinking oracle with rac_on option Using configuration parameter file: /u01/app/grid/product/12.2.0/grid/crs/install/crsconfig_params The log of current session can be found at: /u01/app/grid/grid_bash/crsdata/xifenfei01/crsconfig/rootcrs_xifenfei01_2017-06-11_09-52-55AM.log 2017/06/11 09:53:00 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'. 2017/06/11 09:53:00 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector. 2017/06/11 09:53:27 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector. 2017/06/11 09:53:27 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'. 2017/06/11 09:53:30 CLSRSC-363: User ignored prerequisites during installation 2017/06/11 09:53:30 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'. 2017/06/11 09:53:31 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'. 2017/06/11 09:53:32 CLSRSC-594: Executing installation step 5 of 19: 'SaveParamFile'. 2017/06/11 09:53:37 CLSRSC-594: Executing installation step 6 of 19: 'SetupOSD'. 2017/06/11 09:53:38 CLSRSC-594: Executing installation step 7 of 19: 'CheckCRSConfig'. 2017/06/11 09:53:38 CLSRSC-594: Executing installation step 8 of 19: 'SetupLocalGPNP'. 2017/06/11 09:53:51 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'. 2017/06/11 09:53:56 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'. 2017/06/11 09:53:56 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'. 2017/06/11 09:54:00 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'. 2017/06/11 09:54:15 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service' 2017/06/11 09:54:44 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'. 2017/06/11 09:54:48 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'. CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'xifenfei01' CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'xifenfei01' has completed CRS-4133: Oracle High Availability Services has been stopped. CRS-4123: Oracle High Availability Services has been started. 2017/06/11 09:55:15 CLSRSC-400: A system reboot is required to continue installing. The command '/u01/app/grid/product/12.2.0/grid/perl/bin/perl -I/u01/app/grid/product/12.2.0/grid/perl/lib -I/u01/app/grid/product/12.2.0/grid/crs/install /u01/app/grid/product/12.2.0/grid/crs/install/rootcrs.pl'execution failed
主要报错信息:
2017/06/11 09:55:15 CLSRSC-400: A system reboot is required to continue installing.
The command ‘/u01/app/grid/product/12.2.0/grid/perl/bin/perl -I/u01/app/grid/product/12.2.0/grid/perl/lib -I/u01/app/grid/product/12.2.0/grid/crs/install /u01/app/grid/product/12.2.0/grid/crs/install/rootcrs.pl ‘ execution failed
查询mos发下:ACFS Drivers Install reports CLSRSC-400: A system reboot is required to continue installing (Doc ID 2025056.1),主要是由于12c gi开始,acfs默认是安装的,由于acfs在redhat 7.3中不支持导致上述的错误信息.
[grid@xifenfei01 ~]$ acfsdriverstate -orahome $ORACLE_HOME supported ACFS-9459: ADVM/ACFS is not supported on this OS version: '3.10.0-514.el7.x86_64' ACFS-9201: Not Supported
处理方法
停掉crs,kill 进程(如果有不能停掉的,通过kill处理),执行root.sh
[root@xifenfei01 ~]# /u01/app/grid/product/12.2.0/grid/bin/crsctl status res -t -init -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.asm 1 OFFLINE OFFLINE STABLE ora.cluster_interconnect.haip 1 OFFLINE OFFLINE STABLE ora.crf 1 OFFLINE OFFLINE STABLE ora.crsd 1 OFFLINE OFFLINE STABLE ora.cssd 1 OFFLINE OFFLINE STABLE ora.cssdmonitor 1 OFFLINE OFFLINE STABLE ora.ctssd 1 OFFLINE OFFLINE STABLE ora.diskmon 1 OFFLINE OFFLINE STABLE ora.drivers.acfs 1 OFFLINE OFFLINE STABLE ora.evmd 1 OFFLINE OFFLINE STABLE ora.gipcd 1 OFFLINE OFFLINE STABLE ora.gpnpd 1 OFFLINE OFFLINE STABLE ora.mdnsd 1 OFFLINE OFFLINE STABLE ora.storage 1 OFFLINE OFFLINE STABLE -------------------------------------------------------------------------------- [root@xifenfei01 ~]# /u01/app/grid/product/12.2.0/grid/bin/crsctl stop crs -f CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'xifenfei01' CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'xifenfei02' has completed CRS-4133: Oracle High Availability Services has been stopped. [root@xifenfei02 ~]# ps -ef|grep d.bin root 29155 11754 0 10:46 pts/0 00:00:00 grep --color=auto d.bin [root@xifenfei01 ~]# /u01/app/grid/product/12.2.0/grid/root.sh Performing root user operation. The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /u01/app/grid/product/12.2.0/grid Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of "dbhome" have not changed. No need to overwrite. The contents of "oraenv" have not changed. No need to overwrite. The contents of "coraenv" have not changed. No need to overwrite. Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. Relinking oracle with rac_on option Using configuration parameter file: /u01/app/grid/product/12.2.0/grid/crs/install/crsconfig_params The log of current session can be found at: /u01/app/grid/grid_bash/crsdata/xifenfei01/crsconfig/rootcrs_xifenfei01_2017-06-11_10-33-57AM.log 2017/06/11 10:33:59 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'. 2017/06/11 10:33:59 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector. 2017/06/11 10:34:00 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector. 2017/06/11 10:34:00 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'. 2017/06/11 10:34:01 CLSRSC-363: User ignored prerequisites during installation 2017/06/11 10:34:01 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'. 2017/06/11 10:34:02 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'. 2017/06/11 10:34:02 CLSRSC-594: Executing installation step 5 of 19: 'SaveParamFile'. 2017/06/11 10:34:03 CLSRSC-594: Executing installation step 6 of 19: 'SetupOSD'. 2017/06/11 10:34:04 CLSRSC-594: Executing installation step 7 of 19: 'CheckCRSConfig'. 2017/06/11 10:34:04 CLSRSC-594: Executing installation step 8 of 19: 'SetupLocalGPNP'. 2017/06/11 10:34:06 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'. 2017/06/11 10:34:06 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'. 2017/06/11 10:34:53 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'. 2017/06/11 10:34:54 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'. 2017/06/11 10:35:09 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service' 2017/06/11 10:35:31 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'. 2017/06/11 10:35:33 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'. CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'xifenfei01' CRS-2673: Attempting to stop 'ora.mdnsd' on 'xifenfei01' CRS-2673: Attempting to stop 'ora.evmd' on 'xifenfei01' CRS-2673: Attempting to stop 'ora.gpnpd' on 'xifenfei01' CRS-2677: Stop of 'ora.mdnsd' on 'xifenfei01' succeeded CRS-2677: Stop of 'ora.evmd' on 'xifenfei01' succeeded CRS-2677: Stop of 'ora.gpnpd' on 'xifenfei01' succeeded CRS-2673: Attempting to stop 'ora.gipcd' on 'xifenfei01' CRS-2677: Stop of 'ora.gipcd' on 'xifenfei01' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'xifenfei01' has completed CRS-4133: Oracle High Availability Services has been stopped. CRS-4123: Oracle High Availability Services has been started. 2017/06/11 10:35:57 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'. 2017/06/11 10:36:01 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'. CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'xifenfei01' CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'xifenfei01' has completed CRS-4133: Oracle High Availability Services has been stopped. CRS-4123: Oracle High Availability Services has been started. CRS-2672: Attempting to start 'ora.evmd' on 'xifenfei01' CRS-2672: Attempting to start 'ora.mdnsd' on 'xifenfei01' CRS-2676: Start of 'ora.mdnsd' on 'xifenfei01' succeeded CRS-2676: Start of 'ora.evmd' on 'xifenfei01' succeeded CRS-2672: Attempting to start 'ora.gpnpd' on 'xifenfei01' CRS-2676: Start of 'ora.gpnpd' on 'xifenfei01' succeeded CRS-2672: Attempting to start 'ora.cssdmonitor' on 'xifenfei01' CRS-2672: Attempting to start 'ora.gipcd' on 'xifenfei01' CRS-2676: Start of 'ora.cssdmonitor' on 'xifenfei01' succeeded CRS-2676: Start of 'ora.gipcd' on 'xifenfei01' succeeded CRS-2672: Attempting to start 'ora.cssd' on 'xifenfei01' CRS-2672: Attempting to start 'ora.diskmon' on 'xifenfei01' CRS-2676: Start of 'ora.diskmon' on 'xifenfei01' succeeded CRS-2676: Start of 'ora.cssd' on 'xifenfei01' succeeded Disk groups created successfully. Check /u01/app/grid/grid_bash/cfgtoollogs/asmca/asmca-170611AM103637.log for details. 2017/06/11 10:37:40 CLSRSC-482: Running command: '/u01/app/grid/product/12.2.0/grid/bin/ocrconfig -upgrade grid oinstall' CRS-2672: Attempting to start 'ora.crf' on 'xifenfei01' CRS-2672: Attempting to start 'ora.storage' on 'xifenfei01' CRS-2676: Start of 'ora.storage' on 'xifenfei01' succeeded CRS-2676: Start of 'ora.crf' on 'xifenfei01' succeeded CRS-2672: Attempting to start 'ora.crsd' on 'xifenfei01' CRS-2676: Start of 'ora.crsd' on 'xifenfei01' succeeded CRS-4256: Updating the profile Successful addition of voting disk 49af246c7d2e4f5dbf0d9ea09cc047d5. Successfully replaced voting disk group with +DATA. CRS-4256: Updating the profile CRS-4266: Voting file(s) successfully replaced ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE 49af246c7d2e4f5dbf0d9ea09cc047d5 (/dev/mapper/data1) [DATA] Located 1 voting disk(s). CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'xifenfei01' CRS-2673: Attempting to stop 'ora.crsd' on 'xifenfei01' CRS-2677: Stop of 'ora.crsd' on 'xifenfei01' succeeded CRS-2673: Attempting to stop 'ora.storage' on 'xifenfei01' CRS-2673: Attempting to stop 'ora.crf' on 'xifenfei01' CRS-2673: Attempting to stop 'ora.gpnpd' on 'xifenfei01' CRS-2673: Attempting to stop 'ora.mdnsd' on 'xifenfei01' CRS-2677: Stop of 'ora.crf' on 'xifenfei01' succeeded CRS-2677: Stop of 'ora.gpnpd' on 'xifenfei01' succeeded CRS-2677: Stop of 'ora.storage' on 'xifenfei01' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'xifenfei01' CRS-2677: Stop of 'ora.mdnsd' on 'xifenfei01' succeeded CRS-2677: Stop of 'ora.asm' on 'xifenfei01' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'xifenfei01' CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'xifenfei01' succeeded CRS-2673: Attempting to stop 'ora.ctssd' on 'xifenfei01' CRS-2673: Attempting to stop 'ora.evmd' on 'xifenfei01' CRS-2677: Stop of 'ora.ctssd' on 'xifenfei01' succeeded CRS-2677: Stop of 'ora.evmd' on 'xifenfei01' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'xifenfei01' CRS-2677: Stop of 'ora.cssd' on 'xifenfei01' succeeded CRS-2673: Attempting to stop 'ora.gipcd' on 'xifenfei01' CRS-2677: Stop of 'ora.gipcd' on 'xifenfei01' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'xifenfei01' has completed CRS-4133: Oracle High Availability Services has been stopped. 2017/06/11 10:38:40 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'. CRS-4123: Starting Oracle High Availability Services-managed resources CRS-2672: Attempting to start 'ora.mdnsd' on 'xifenfei01' CRS-2672: Attempting to start 'ora.evmd' on 'xifenfei01' CRS-2676: Start of 'ora.mdnsd' on 'xifenfei01' succeeded CRS-2676: Start of 'ora.evmd' on 'xifenfei01' succeeded CRS-2672: Attempting to start 'ora.gpnpd' on 'xifenfei01' CRS-2676: Start of 'ora.gpnpd' on 'xifenfei01' succeeded CRS-2672: Attempting to start 'ora.gipcd' on 'xifenfei01' CRS-2676: Start of 'ora.gipcd' on 'xifenfei01' succeeded CRS-2672: Attempting to start 'ora.drivers.acfs' on 'xifenfei01' CRS-2674: Start of 'ora.drivers.acfs' on 'xifenfei01' failed CRS-2672: Attempting to start 'ora.cssdmonitor' on 'xifenfei01' CRS-2676: Start of 'ora.cssdmonitor' on 'xifenfei01' succeeded CRS-2672: Attempting to start 'ora.cssd' on 'xifenfei01' CRS-2672: Attempting to start 'ora.diskmon' on 'xifenfei01' CRS-2676: Start of 'ora.diskmon' on 'xifenfei01' succeeded CRS-2676: Start of 'ora.cssd' on 'xifenfei01' succeeded CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'xifenfei01' CRS-2672: Attempting to start 'ora.ctssd' on 'xifenfei01' CRS-2676: Start of 'ora.ctssd' on 'xifenfei01' succeeded CRS-2672: Attempting to start 'ora.drivers.acfs' on 'xifenfei01' CRS-2674: Start of 'ora.drivers.acfs' on 'xifenfei01' failed CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'xifenfei01' succeeded CRS-2672: Attempting to start 'ora.asm' on 'xifenfei01' CRS-2676: Start of 'ora.asm' on 'xifenfei01' succeeded CRS-2672: Attempting to start 'ora.storage' on 'xifenfei01' CRS-2676: Start of 'ora.storage' on 'xifenfei01' succeeded CRS-2672: Attempting to start 'ora.crf' on 'xifenfei01' CRS-2676: Start of 'ora.crf' on 'xifenfei01' succeeded CRS-2672: Attempting to start 'ora.crsd' on 'xifenfei01' CRS-2676: Start of 'ora.crsd' on 'xifenfei01' succeeded CRS-6023: Starting Oracle Cluster Ready Services-managed resources CRS-6017: Processing resource auto-start for servers: xifenfei01 CRS-6016: Resource auto-start has completed for server xifenfei01 CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources CRS-4123: Oracle High Availability Services has been started. 2017/06/11 10:40:23 CLSRSC-343: Successfully started Oracle Clusterware stack 2017/06/11 10:40:23 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'. CRS-2672: Attempting to start 'ora.ASMNET1LSNR_ASM.lsnr' on 'xifenfei01' CRS-2676: Start of 'ora.ASMNET1LSNR_ASM.lsnr' on 'xifenfei01' succeeded CRS-2672: Attempting to start 'ora.asm' on 'xifenfei01' CRS-2676: Start of 'ora.asm' on 'xifenfei01' succeeded CRS-2672: Attempting to start 'ora.DATA.dg' on 'xifenfei01' CRS-2676: Start of 'ora.DATA.dg' on 'xifenfei01' succeeded 2017/06/11 10:42:19 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'. 2017/06/11 10:43:16 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
其他剩余节点也是类似处理,最终跳过acfs安装成功
[grid@xifenfei01 ~]$ crsctl status res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.ASMNET1LSNR_ASM.lsnr ONLINE ONLINE xifenfei01 STABLE ONLINE ONLINE xifenfei02 STABLE ora.DATA.dg ONLINE ONLINE xifenfei01 STABLE ONLINE ONLINE xifenfei02 STABLE ora.LISTENER.lsnr ONLINE ONLINE xifenfei01 STABLE ONLINE ONLINE xifenfei02 STABLE ora.chad ONLINE ONLINE xifenfei01 STABLE ONLINE ONLINE xifenfei02 STABLE ora.net1.network ONLINE ONLINE xifenfei01 STABLE ONLINE ONLINE xifenfei02 STABLE ora.ons ONLINE ONLINE xifenfei01 STABLE ONLINE ONLINE xifenfei02 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE xifenfei01 STABLE ora.MGMTLSNR 1 ONLINE ONLINE xifenfei01 169.254.20.214 192.1 68.1.20 192.168.2.20 ,STABLE ora.asm 1 ONLINE ONLINE xifenfei01 Started,STABLE 2 ONLINE ONLINE xifenfei02 Started,STABLE 3 OFFLINE OFFLINE STABLE ora.cvu 1 ONLINE ONLINE xifenfei01 STABLE ora.mgmtdb 1 ONLINE ONLINE xifenfei01 Open,STABLE ora.qosmserver 1 ONLINE ONLINE xifenfei01 STABLE ora.scan1.vip 1 ONLINE ONLINE xifenfei01 STABLE ora.xifenfei01.vip 1 ONLINE ONLINE xifenfei01 STABLE ora.xifenfei02.vip 1 ONLINE ONLINE xifenfei02 STABLE --------------------------------------------------------------------------------
最新官方处理方案:CLSRSC-400: A system reboot is required to continue installing.
crfclust.bdb文件过大处理
grid所在目录空间满
[root@wldb01 ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sdw2 40G 22G 17G 58% / tmpfs 16G 219M 16G 2% /dev/shm /dev/sdw1 50G 46G 1.5G 97% /u01
使用find命令找出来大文件
[root@wldb01 grid]# find ./ type f -size +1024M ./crf/db/wldb01/crfclust.bdb
由于文件crfclust.bdb是Cluster Health Monitor (CHM) file,他的默认大小是1G,但是有在一些平台和版本中由于bug原因导致过大.
Oracle Cluster Health Monitor (CHM) using large amount of space (more than default) (Doc ID 1343105.1)
Bug 20186278 – crfclust.bdb Becomes Huge Size Due to Sudden Retention Change (Doc ID 20186278.8)
[grid@wldb01 ~]$ /u01/app/11.2.0/grid/bin/oclumon manage -get reppath CHM Repository Path = /u01/app/11.2.0/grid/crf/db/wldb01 Done
[root@wldb01 ~]# cd /u01/app/11.2.0/grid/crf/db/wldb01 [root@wldb01 wldb01]# du -sh 24G . [root@wldb01 wldb01]# ls -lhtr total 24G -rw-r-----. 1 root root 16M Mar 25 21:38 log.0000047847 -rw-r-----. 1 root root 8.0K Mar 25 21:38 repdhosts.bdb -rw-r-----. 1 root root 24K Mar 25 21:39 __db.001 -rw-r--r--. 1 root root 115M Mar 25 21:39 wldb01.ldb -rw-r-----. 1 root root 8.0K Mar 25 21:40 crfconn.bdb -rw-r-----. 1 root root 329M Mar 25 21:52 crfts.bdb -rw-r-----. 1 root root 508M Mar 25 21:53 crfloclts.bdb -rw-r-----. 1 root root 22G Mar 25 21:53 crfclust.bdb -rw-r-----. 1 root root 392K Mar 25 21:53 __db.002 -rw-r-----. 1 root root 16M Mar 25 21:53 log.0000047848 -rw-r-----. 1 root root 504M Mar 25 21:53 crfhosts.bdb -rw-r-----. 1 root root 650M Mar 25 21:53 crfcpu.bdb -rw-r-----. 1 root root 534M Mar 25 21:53 crfalert.bdb -rw-r-----. 1 root root 56K Mar 25 21:53 __db.006 -rw-r-----. 1 root root 1.2M Mar 25 21:53 __db.005 -rw-r-----. 1 root root 2.1M Mar 25 21:53 __db.004 -rw-r-----. 1 root root 2.6M Mar 25 21:53 __db.003
清理bdb文件
[root@wldb01 wldb01]# /u01/app/11.2.0/grid/bin/crsctl stop res ora.crf -init CRS-2673: Attempting to stop 'ora.crf' on 'wldb01' CRS-2677: Stop of 'ora.crf' on 'wldb01' succeeded [root@wldb01 wldb01]# /u01/app/11.2.0/grid/bin/crsctl status res -t -init -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.asm 1 ONLINE ONLINE wldb01 Started ora.cluster_interconnect.haip 1 ONLINE ONLINE wldb01 ora.crf 1 OFFLINE OFFLINE ora.crsd 1 ONLINE ONLINE wldb01 ora.cssd 1 ONLINE ONLINE wldb01 ora.cssdmonitor 1 ONLINE ONLINE wldb01 ora.ctssd 1 ONLINE ONLINE wldb01 ACTIVE:0 ora.diskmon 1 OFFLINE OFFLINE ora.drivers.acfs 1 ONLINE ONLINE wldb01 ora.evmd 1 ONLINE ONLINE wldb01 ora.gipcd 1 ONLINE ONLINE wldb01 ora.gpnpd 1 ONLINE ONLINE wldb01 ora.mdnsd 1 ONLINE ONLINE wldb01 [root@wldb01 wldb01]# rm -rf *.bdb [root@wldb01 wldb01]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sdw2 40G 22G 17G 58% / tmpfs 16G 219M 16G 2% /dev/shm /dev/sdw1 50G 22G 26G 46% /u01 [root@wldb01 wldb01]# du -sh 53M . [root@wldb01 wldb01]# /u01/app/11.2.0/grid/bin/crsctl start res ora.crf -init CRS-2672: Attempting to start 'ora.crf' on 'wldb01' CRS-2676: Start of 'ora.crf' on 'wldb01' succeeded [root@wldb01 wldb01]# /u01/app/11.2.0/grid/bin/crsctl status res -t -init -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.asm 1 ONLINE ONLINE wldb01 Started ora.cluster_interconnect.haip 1 ONLINE ONLINE wldb01 ora.crf 1 ONLINE ONLINE wldb01 ora.crsd 1 ONLINE ONLINE wldb01 ora.cssd 1 ONLINE ONLINE wldb01 ora.cssdmonitor 1 ONLINE ONLINE wldb01 ora.ctssd 1 ONLINE ONLINE wldb01 ACTIVE:0 ora.diskmon 1 OFFLINE OFFLINE ora.drivers.acfs 1 ONLINE ONLINE wldb01 ora.evmd 1 ONLINE ONLINE wldb01 ora.gipcd 1 ONLINE ONLINE wldb01 ora.gpnpd 1 ONLINE ONLINE wldb01 ora.mdnsd 1 ONLINE ONLINE wldb01