赞
踩
ASM on Non-First Node (Second or Others) Fails to Start: PMON (ospid: nnnn): terminating the instance due to error 481 (文档 ID 1383737.1) | 编辑转到底部 | |
In this Document APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterGen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later Oracle Cloud Infrastructure - Database Service - Version N/A and later Oracle Database Cloud Exadata Service - Version N/A and later Oracle Database Cloud Schema Service - Version N/A and later Information in this document applies to any platform. PURPOSEThis note lists common causes of ASM start up failure with the following error on non-first node (second or others):
If ASM on non-first node was running previously, likely the following will be in alert.log when it failed originally:
SCOPEDETAILSCase1: link local IP (169.254.x.x) is being used by other adapter/networkSymptoms:
Dell iDRAC service module may use link local, engage Dell to change the subnet. On Sun T series, by default, ILOM (adapter name usbecm0) uses link local, engage Oracle Support for advice. Case2: firewall exists between nodes on private network (iptables etc)No firewall is allowed on private network (cluster_interconnect) between nodes including software firewall like iptables, ipmon etc Case3: HAIP is up on some nodes but not on allSymptoms:
Solution: $GRID_HOME/bin/crsctl stat res ora.cluster_interconnect.haip -init
$GRID_HOME/bin/crsctl start res ora.cluster_interconnect.haip -init
If the issue happened in the middle of GI upgrade, refer to: note 2063676.1 - rootupgrade.sh fails on node1 as HAIP was not starting from old home but starting from new home Case4: HAIP is up on all nodes but some do not have route infoSymptoms:
Solution: 169.254.0.0 0.0.0.0 255.255.0.0 U 0 0 0 bond2 Note: the first field is HAIP subnet ID and will start with 169.254.xxx.xxx, the third field is HAIP subnet netmask and the last field is private network adapter name 4.2. Execute the following as root on the node that's missing HAIP route: # route add -net <HAIP subnet ID> netmask <HAIP subnet netmask> dev <private network adapter>
# $GRID_HOME/bin/crsctl start res ora.crsd -init
Case5. HAIP is up on all nodes and route info is presented but HAIP is not pingableSymptom: Kernel IP routing table Destination Gateway Genmask Flags MSS Window irtt Iface 192.168.x.x * 255.255.255.0 U 0 0 0 eth2 192.168.x.x * 255.255.255.0 U 0 0 0 eth1 192.168.x.x * 255.255.255.0 U 0 0 0 eth0 link-local * 255.255.0.0 U 0 0 0 eth2 default 192.168.x.x 0.0.0.0 UG 0 0 0 eth0
For Openstack Cloud implementation, engage system admin to create another neutron port to map link-local traffic. For other environment, engage SysAdmin/NetworkAdmin to review routing/network setup. REFERENCESNOTE:1640865.1 - Known Issues: Grid Infrastructure Redundant Interconnect and ora.cluster_interconnect.haipNOTE:1210883.1 - Grid Infrastructure Redundant Interconnect and ora.cluster_interconnect.haip NOTE:1386709.1 - The Basics of IPv4 Subnet and Oracle Clusterware |
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。