Oracle 10 Gb log on occasionally in Linux

Log on to the database using the following methods in Oracle in Linux: sqlplus/nolog conn/as sysdba, but it gets stuck at the conn/as sysdba step and cannot be logged on, and check whether the listening status does not respond.

This is a bug in oracle 10.2.0.1. sqplus and lsnrctl are not easy to use after a certain number of days. Generally, restart the server. Either Install patches or add a sentence to the listening file according to the practice on the Internet.

Add SUBSCRIBE_FOR_NODE_DOWN_EVENT _ <listener_name> = OFF to the listener. ora file. <listener_name> indicates the name of the listener of the database. For example, the LISTENER name is LISTENER by default. The statement is SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER = OFF.