The ListenerParameterFile information is missing from lsnrctlstatus.

I. Environment Information host platform: linux6.2 database version: 11.2.0.3 (psu5) Single Instance II: Problem phenomenon lsnrctlstatus no listening file (ListenerParameterFile) found during monitoring status check

I. Environment Information host platform: linux6.2 database version: 11.2.0.3 (psu5) Single Instance II: Problem phenomenon lsnrctlstatus no listening file (ListenerParameterFile) found during monitoring status check

I. Environment Information

Host platform: linux 6.2

Database Version: 11.2.0.3 (psu5) Single Instance

Ii. Problem

Lsnrctl status no listening File found when viewing the listening status (Listener Parameter File, normally there will be listening File Information)

-- Note that information cannot be directly sent out because the question bank is a commercial database. The following content is simulated in the test environment.

1. lsnrctl status information of the Question Bank

[Oracle @ localhost admin] $ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.4.0-Production on 15-APR-2014 17: 47: 28 Copyright (c) 1991,201 3, Oracle. all rights reserved. connecting to (ADDRESS = (PROTOCOL = tcp) (HOST =) (PORT = 1521) STATUS of the LISTENER ------------------------ AliasLISTENERVersionTNSLSNR for Linux: Version 11.2.0.4.0-ProductionStart Date15-APR-2014 17: 25: 41Uptime0 days 0 hr. 21 min. 47 secTrace LeveloffSecurityON: Local OS AuthenticationSNMPOFFListener Log File/u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log. xmlListening Endpoints Summary... (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = localhost. localdomain) (PORT = 1521) Services Summary... service "ora11g" has 1 instance (s ). instance "ora11g", status READY, has 1 handler (s) for this service... the command completed successfully

2. lsnrctl status information of the normal Database

[Oracle @ localhost admin] $ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.4.0-Production on 15-APR-2014 17: 24: 56 Copyright (c) 1991,201 3, Oracle. all rights reserved. connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = localhost. localdomain) (PORT = 1521) STATUS of the LISTENER ------------------------ AliasLISTENERVersionTNSLSNR for Linux: Version 11.2.0.4.0-ProductionStart Date15-APR-2014 17: 17: 16Uptime0 days 0 hr. 7 min. 39 secTrace LeveloffSecurityON: Local OS AuthenticationSNMPOFFListener Parameter File/u01/app/oracle/product/11.2.0.4/db_1/network/admin/listener. oraListener Log File/u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log. xmlListening Endpoints Summary... (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = localhost. localdomain) (PORT = 1521) (DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (KEY = EXTPROC1521) Services Summary... service "ora11g" has 1 instance (s ). instance "ora11g", status READY, has 1 handler (s) for this service... the command completed successfully

-- Note that the information of 1, 2 is found to be missing the line "Listener Parameter File *****" in the lsnrctl status information of the question bank. The listener. ora file does not exist in cd $ ORACLE_HOME/network/admin. How did this problem occur? No information is found for MOS.

Iii. Fault Simulation 1

---- I guess it may be that the listener. ora file was accidentally deleted, so I decided to simulate it from this aspect.

1. lsnrctl status (the "Listener Parameter File" information exists in a normal database)

[Oracle @ localhost admin] $ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.4.0-Production on 15-APR-2014 17: 24: 56 Copyright (c) 1991,201 3, Oracle. all rights reserved. connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = localhost. localdomain) (PORT = 1521) STATUS of the LISTENER ------------------------ AliasLISTENERVersionTNSLSNR for Linux: Version 11.2.0.4.0-ProductionStart Date15-APR-2014 17: 17: 16Uptime0 days 0 hr. 7 min. 39 secTrace LeveloffSecurityON: Local OS AuthenticationSNMPOFFListener Parameter File/u01/app/oracle/product/11.2.0.4/db_1/network/admin/listener. oraListener Log File/u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log. xmlListening Endpoints Summary... (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = localhost. localdomain) (PORT = 1521) (DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (KEY = EXTPROC1521) Services Summary... service "ora11g" has 1 instance (s ). instance "ora11g", status READY, has 1 handler (s) for this service... the command completed successfully

2. Delete the listener. ora File

Cd $ ORACLE_HOME/network/admin

Mv listener. ora listener. ora. bak

3. lsnrctl status

-- The lsnrctl status information in step 1 is exactly the same (after deletion, the information is still normal, probably because the listener has not restarted. Let's restart the listener)

4. Restart the listener.

1) lsnrctl stop

2) lsnrctl start

3) lsnrctl status

[Oracle @ localhost admin] $ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.4.0-Production on 15-APR-2014 17: 47: 28 Copyright (c) 1991,201 3, Oracle. all rights reserved. connecting to (ADDRESS = (PROTOCOL = tcp) (HOST =) (PORT = 1521) STATUS of the LISTENER ------------------------ AliasLISTENERVersionTNSLSNR for Linux: Version 11.2.0.4.0-ProductionStart Date15-APR-2014 17: 25: 41Uptime0 days 0 hr. 21 min. 47 secTrace LeveloffSecurityON: Local OS AuthenticationSNMPOFFListener Log File/u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log. xmlListening Endpoints Summary... (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = localhost. localdomain) (PORT = 1521) Services Summary... service "ora11g" has 1 instance (s ). instance "ora11g", status READY, has 1 handler (s) for this service... the command completed successfully

-- The problem occurs again. The "Listener Parameter File" information in the Listener is no longer displayed.

-- You may be wondering why the listener. ora file can be used to restart the listener. This is because we use the default listener, and 9i can start listening without listener. ora (default listener)

5. Restore the listener. ora File

1) mv listener. ora. bak listener. ora

2) lsnrctl status (still no "Listener Parameter File" Information)

3) restart the listener

Lsnrctl stop

Lsnrctl start

4) lsnrctl status ("Listener Parameter File" information is displayed)

-- The Listener returns to normal.

Iv. Summary

When 9i starts, the default listener can be started without the listener. ora file (Listening to port 1521 of the IP address corresponding to the host name)

1) install oracle software (without database creation)

2) Start the listener (oracle software is installed and listener. ora is not configured)