Oracle 11g RAC listener offline

Oracle 11g RAC listener offline

After the Oracle 11g RAC listener has changed the network, the listener process offline appears, and the two nodes are switched frequently. Check the log/var/log/message to find frequent registration and revocation actions.

Listening log/u01/app/oracle/diag/tnslsnr/rac1/listener/trace/listener. log
Listening file/u01/app/11.2.0/grid/network/admin/listener. ora
Oracle error log/u01/app/oracle/diag/rdbms/oaorcl/trace/alert
Rac process log/u01/app/11.2.0/grid/log/rac/crsd. log
?? /U03/oracle/app/11.2.0/grid/log/orajdcpt */alertorajdcpt *. log
?? /U03/oracle/app/11.2.0/grid/log/orajdcpt */cssd/ocssd. log
/U01/app/11.2.0/grid/log/rac1/agent/crsd/oraagent_grid/oraagent_grid.log

Ip address fluctuations are found.

Solution:

Add in/etc/sysctl. conf

Net. ipv4.conf. default. arp_ignore = 1

Meaning: Determine the responses sent in different ways. The request for receiving ARP Protocol 0-(default) represents the target IP address anywhere and any interface is configured. 1-only the target IP address is the local address, and the input interface is configured.
Net. ipv4.conf. all. arp_ignore = 1 meaning: Same as above

Then sysctl-p
Add the mac address to the/etc/sysconfig/network-scripts/ifcfg-eth file. You can view the mac address in ifconfig.

Oracle Database listening is very slow, and hang basically handles faults

Dynamic and Static monitoring features of Oracle listeners

Non-default listeners and port configurations for placing an instance in the Oracle 11g RAC Environment

Configure and manage Oracle listener logs

Oracle error-ORA-12514: TNS: No listener

ORA-12514 listening error solved

Six connection problems and solutions for Oracle listeners

Oracle LISTENER does not listen to Oracle instances. Problem solved

Set the Oracle LISTENER password (LISTENER)