In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |
APPLIES TO:
Oracle Cloud Infrastructure - Database Service - Version N/A and later Oracle Database Exadata Express Cloud Service - Version N/A and later Oracle Database Backup Service - Version N/A and later Oracle Database Cloud Exadata Service - Version N/A and later Oracle Database Cloud Service - Version N/A and later Information in this document applies to any platform.
SYMPTOMS
While trying to start clusterware, ASM was not able to start. Errors in the CRS alert<hostname>.log contains:
and while trying to start using sqlplus, the following is displayed:
SQL*Plus: Release 11.2.0.4.0 Production on Mon Jun 26 08:30:34 2017Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to an idle instance.SQL> startup ORA-27504: IPC error creating OSD context ORA-27300: OS system dependent operation:if_not_found failed with status: 0 ORA-27301: OS failure message: Error 0 ORA-27302: failure occurred at: skgxpvaddr9 ORA-27303: additional information: requested interface 172.xx.xx107 not found. Check output from ifconfig command SQL>
CHANGES
Problems with hardware, ending up changing server, and kept previous spfile configuration for ASM
CAUSE
ASM instance had in the spfile, as displayed in the alert_+ASM3.log, the following information for cluster_interconnects:
Using parameter settings in server-side spfile +DATA/<cluster>/asmparameterfile/registry.253.947555425 >>>>>>>>>> spfile System parameters with non-default values: sga_max_size = 272M large_pool_size = 12M instance_type = "asm" cluster_interconnects = "172.xx.xx.107" >>>>>>>>>>>>>> cluster_interconnects = "172.xx.xx.107" <<<<<<<<<<<<<<<<<<< private ip address defined in spfile sga_target = 0 memory_target = 1G memory_max_target = 1G remote_login_passwordfile= "EXCLUSIVE"
The ifconfig -a output from the node where ASM3 is supposed to be running, did not had any network card with the ip address 172.xx.xx107, but HAIP was already up and plumbed into private interface:
lo0: flags=2001000849<UP,LOOPBACK,RUNNING,MULTICAST,IPv4,VIRTUAL> mtu 8232 index 1 inet 127.0.0.1 netmask ff000000 ipmp0: flags=8001000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4,IPMP> mtu 1500 index 4 inet 172.xx.xx.63 netmask ffffff00 broadcast 172.xx.11.255 groupname ipmp0 ipmp1: flags=8001000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4,IPMP> mtu 1500 index 2 inet 172.xx.xx.113 netmask ffffff00 broadcast 172.xx.18.255 groupname ipmp1 ipmp1:1: flags=8001000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4,IPMP> mtu 1500 index 2 >>>>>>>>>>>>>>> HAIP is running inet 169.xxx.xx.107 netmask ffff0000 broadcast 169.xxx.255.255 net0: flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 index 5 inet 0.0.0.0 netmask ff000000 broadcast 0.xxx.255.255 groupname ipmp0 net1: flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 index 3 inet 0.0.0.0 netmask ff000000 broadcast 0.xxx.255.255 groupname ipmp1 lo0: flags=2002000849<UP,LOOPBACK,RUNNING,MULTICAST,IPv6,VIRTUAL> mtu 8252 index 1 inet6 ::1/128 ipmp0: flags=28002000840<RUNNING,MULTICAST,IPv6,IPMP> mtu 1500 index 4 inet6 ::/0 groupname ipmp0 ipmp1: flags=28002000840<RUNNING,MULTICAST,IPv6,IPMP> mtu 1500 index 2 inet6 ::/0 groupname ipmp1 net0: flags=20002000841<UP,RUNNING,MULTICAST,IPv6> mtu 1500 index 5 inet6 ::/0 groupname ipmp0 net1: flags=20002000841<UP,RUNNING,MULTICAST,IPv6> mtu 1500 index 3 inet6 ::/0 groupname ipmp1
The /etc/hosts file had another entry for the private interface of this node, and not the old ip address of 172.xx.xx.107:
SOLUTION
*.cluster_interconnects='172.xx.xx.107'by issuing:SQL> alter system reset cluster_interconnects SCOPE=SPFILE SID='*';System altered.SQL>2) restart asm
REFERENCES
NOTE:199389.1 - How To Request Management Attention on a Service Request (SR) with Oracle Support Services
编辑推荐:
- ocp 19c考题,科目082考试题(16)-about dropping and unused columns03-03
- 【ASM】ORA-27504 ORA-27300 ORA-27303 while starting ASM (Doc ID 2281441.1)03-03
- [重庆思庄每日技术分享]-ORA-00235 :不带锁定的控制文件读取因并发更新而不一致03-03
- [重庆思庄每日技术分享]-sqlplus登录数据库时报错:ORA-1254703-03
- oracle ocp 19c考题,科目082考试题(17)-using an invisible column03-03
- 【DBA】Oracle 中DBA地址的文件号使用的是相对文件号(RELATIVE_FNO)03-03
- 【TUNE_ORACLE】Oracle健康检查基础项目(三)项目检查步骤概述其二03-03
- 【TUNE_ORACLE】Oracle健康检查基础项目(四)项目检查步骤概述其三03-03
相关推荐
-
雷神推出 MIX PRO II 迷你主机:基于 Ultra 200H,玻璃上盖 + ARGB 灯效
2 月 9 日消息,雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C:支持手写笔、第三方安卓应用
2 月 10 日消息,制造商 Musnap 现已在海外推出一款 Oce
热文推荐
- 利用福禄克光纤测试仪了解综合布线
利用福禄克光纤测试仪了解综合布线
26-03-03 - Bug 27223075 - Wait for 'PX Deq: Join Ack' when no active QC but PPA* slaves sho
- dbua升级oracle数据库
dbua升级oracle数据库
26-03-03 - 【北亚数据恢复】误删除oracle表和误删除oracle表数据的数据恢复方法
- 【北亚数据恢复】异常断电导致Oracle数据库报错的oracle数据恢复
【北亚数据恢复】异常断电导致Oracle数据库报错的oracle数据恢复
26-03-03 - opatch打补丁,单机
opatch打补丁,单机
26-03-03 - 数据类型与函数索引-Oracle篇
数据类型与函数索引-Oracle篇
26-03-03 - 【Flashback】Flashback Database闪回数据库功能实验
- ORACLE DSG数据同步软件进程导致数据库无法正常关闭
ORACLE DSG数据同步软件进程导致数据库无法正常关闭
26-03-03 - 如何快速批量下载亚马逊平台的高清图片
如何快速批量下载亚马逊平台的高清图片
26-03-03
