In linux, oracle10g lsnrctl does not respond to sqlplus normal bug4518443, oracle10glsnrctl

In linux, oracle10g lsnrctl does not respond to sqlplus normal bug4518443, oracle10glsnrctl
Symptom Description: The oracle version used is 10.2.0.1.0 in linux. If lsnrctl status is entered on the command line interface, no response is returned. If lsnrctl stop is entered, no response is returned. Applications connected to the database run normally, but new applications cannot connect to the database. SQL plus is normal on the oracle database server, but PL/SQL and navicat on the client cannot connect to the database server.

Problem diagnosis: oracle listening is down

After querying the information online, it is found that this is caused by a bug 4518443 in oracle 10.2.0.1.0. This bug will automatically create a sublistener. When this happens, the listener will be suspended. The BUG exists in any operating system.


Solution:
1. view the LISTNER process (both statements are acceptable)
$ Ps aux | grep LISTENER
$ Ps aux | grep tnslsnr
Normally, there is only one LISTENER process, and this BUG shows two LISTENER processes, so you need to close one process.


2. kill the LISTENER process (kill is required for both processes)
$ Kill-9 26184


3. Restart LISTENER.
$ Lsnrctl stop
$ Lsnrctl start


4. view the LISTNER process again
$ Ps aux | grep LISTENER
At this time, only one LISTENER process exists.
Oracle 9635 10.8 0.0 204508 9512? Rsl Sep18 620: 18 $ ORACLE_HOME/bin/tnslsnr LISTENER-inherit


So far, the LISTENER can be used normally. If no further processing is performed, the same problem will still occur in a period of time. Therefore, we need to completely solve this problem.


5. Complete Solution
5.1: upgrade solution
You can Upgrade oracle to a version later than oracle 10.2.0.3.
Ps: there is a great risk of upgrading the online production database online. Once the upgrade fails, all online applications cannot be accessed, therefore, we do not recommend that you use this method to solve this problem for production databases used online, unless they are used online after the upgrade.

5.2: Modify the listener. ora File
Add the following parameter to the listener. ora file: SUBSCRIBE_FOR_NODE_DOWN_EVENT _ <listener_name> = OFF # Here, listener_name is the name of the configured listener, if it is the default LISTENER. The specific modification is as follows:


$ Vi $ ORACLE_HOME/network/admin/listener. ora
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER = OFF


6. Restart LISTENER.
$ Lsnrctl stop
$ Restart CTL start


If you only modify this BUG, we recommend that you modify the listener. ora file. We also remind you to Upgrade ORACLE before ORACLE is officially put into use.
Lsnrctl is not displayed. After ORACLE10G is installed, lsnrctl is not displayed at all. Why?

The prompt is clear, that is, the listener problem. If the server starts the listener, log on to the server using SQL/plus to check whether the listener can be logged on. If the listener can be logged on, the listener is OK; then try to connect to the client, provided that the net name of the client is configured in advance, when manually configuring the net name, pay attention to tnsname. the format of the ora File


Linux + oracle10g does not respond after sqlplus/nolog is executed on the server, and no error is reported in the future.

I encountered the same problem and tried a lot of methods. I also tried to add p4612267_10201_linux.zip, but still did not respond.
The environment variable configuration is as follows:
######### Oracle env
Export TMP =/tmp
Export ORACLE_BASE =/home/oracle
Export ORACLE_HOME = $ ORACLE_BASE/product/10.2.0
Export ORACLE_SID = orcl
Export ORACLE_ADMIN = $ ORACLE_BASE/admin
Export NLS_LANG = "Simplified Chinese_china". ZHS16GBK
Export LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/lib
Export ORA_NLS33 = $ ORACLE_HOME/ocommon/nls/data
Export PATH =/usr/sbin: $ PATH: $ ORACLE_HOME/bin
Export CLASSPATH = $ ORACLE_HOME/JRE: $ ORACLE_HOME/jlib: $ ORACLE_HOME/rdbms/jlib
######## Oracle env
I don't know how to solve it ..