Today, a test database is down. After the Oracle database is restarted, the listener cannot be started, and the lsnrctlstart or lsnrctlstatus commands are stuck in this step:
Today, a test database is down. After the Oracle database is restarted, the listener cannot be started. The lsnrctl start or lsnrctl status Command is stuck in this step:
Today, a test database is down. After the Oracle database is restarted, the listener cannot be started. The lsnrctl start or lsnrctl status Command is stuck in this step:
Lsnrctl status
LSNRCTL for Linux: Version 10.2.0.5.0-Production on 09-APR-2013 15:14:39
Copyright (c) 1991,201 0, Oracle. All rights reserved.
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = dbserver) (PORT = 1521 )))
Then there is no more
The pain point is that the listener. log File Path of the listener is not the default path,
I want to delete the listener, and the interface is stuck in the delete step. If I don't go down, it's useless to restart.
Later I thought it may be because the listener. log is too large to be written into it,
Therefore, the find-name '* listener *' command is used to locate the listener. log rm and recreate it.
Client Connection successful.
The headache is that the lsnrctl status Command is still unavailable, as before, stuck in the previous step.
So I checked the/etc/hosts file and found that the IP address here is not the address of the current database. After the inquiry, I learned that the server was moved, the IP address was changed, and the hosts file was not modified.
Later, the IP address will be changed.
The lsnrctl command can be used normally.
Related reading:
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
,