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)