How to start, disable, and restart oracle listeners in linux

How to start, disable, and restart oracle listeners in linux is a basic task for DBA to start and close oracle listeners, however, the Linux system administrator or programmer sometimes needs to perform some basic DBA operations in the development database, so it is very important for them to understand some basic management operations. This article will discuss how to use the LSNRCTL command to start, close, and view the listener status. How to start, close, and restart the oracle listener before starting, closing, or restarting the oracle listener, make sure to use the lsnrctl status Command to check the status of the oracle listener. In addition to the listener status, you can also obtain the following information from the output of the lsnrctl status Command: listener startup time listener's runtime listener parameter file listener. the location of ora, usually in the location of the listener log file under the $ ORACLE_HOME/network/admin directory. If the oracle listener does not run, you will get the following information:

$ lsnrctl status   LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 04-APR-2009 16:27:39   Copyright (c) 1991, 2007, Oracle. All rights reserved.   Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521)))   TNS-12541: TNS:no listener   TNS-12560: TNS:protocol adapter error   TNS-00511: No listener   Linux Error: 111: Connection refused   Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))   TNS-12541: TNS:no listener   TNS-12560: TNS:protocol adapter error   TNS-00511: No listener   Linux Error: 2: No such file or directory $ lsnrctl statusLSNRCTL for Linux: Version 11.1.0.6.0 - Production on 04-APR-2009 16:27:39Copyright (c) 1991, 2007, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521)))TNS-12541: TNS:no listenerTNS-12560: TNS:protocol adapter errorTNS-00511: No listenerLinux Error: 111: Connection refusedConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))TNS-12541: TNS:no listenerTNS-12560: TNS:protocol adapter errorTNS-00511: No listenerLinux Error: 2: No such file or directory

 

If the oracle listener is running, you will get the following information:

$ lsnrctl status   LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 04-APR-2009 16:27:02   Copyright (c) 1991, 2007, Oracle. All rights reserved.   Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521)))   STATUS of the LISTENER   ————————   Alias                     LISTENER   Version                   TNSLSNR for Linux: Version 11.1.0.6.0 - Production   Start Date                29-APR-2009 18:43:13   Uptime                    6 days 21 hr. 43 min. 49 sec   Trace Level               off   Security                  ON: Local OS Authentication   SNMP                      OFF   Listener Parameter File   /u01/app/oracle/product/11.1.0/network/admin/listener.ora   Listener Log File         /u01/app/oracle/diag/tnslsnr/devdb/listener/alert/log.xml   Listening Endpoints Summary…   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=1521)))   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))   Services Summary…   Service “devdb” has 1 instance(s).   Instance “devdb”, status UNKNOWN, has 1 handler(s) for this service…   Service “devdb.thegeekstuff.com” has 1 instance(s).   Instance “devdb”, status READY, has 1 handler(s) for this service…   Service “devdbXDB.thegeekstuff.com” has 1 instance(s).   Instance “devdb”, status READY, has 1 handler(s) for this service…   Service “devdb_XPT.thegeekstuff.com” has 1 instance(s).   Instance “devdb”, status READY, has 1 handler(s) for this service…   The command completed successfully $ lsnrctl statusLSNRCTL for Linux: Version 11.1.0.6.0 - Production on 04-APR-2009 16:27:02Copyright (c) 1991, 2007, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521)))STATUS of the LISTENER————————Alias                     LISTENERVersion                   TNSLSNR for Linux: Version 11.1.0.6.0 - ProductionStart Date                29-APR-2009 18:43:13Uptime                    6 days 21 hr. 43 min. 49 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /u01/app/oracle/product/11.1.0/network/admin/listener.oraListener Log File         /u01/app/oracle/diag/tnslsnr/devdb/listener/alert/log.xmlListening Endpoints Summary…(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))Services Summary…Service “devdb” has 1 instance(s).Instance “devdb”, status UNKNOWN, has 1 handler(s) for this service…Service “devdb.thegeekstuff.com” has 1 instance(s).Instance “devdb”, status READY, has 1 handler(s) for this service…Service “devdbXDB.thegeekstuff.com” has 1 instance(s).Instance “devdb”, status READY, has 1 handler(s) for this service…Service “devdb_XPT.thegeekstuff.com” has 1 instance(s).Instance “devdb”, status READY, has 1 handler(s) for this service…The command completed successfully

 

2. start the oracle listener if the oracle listener does not run, you can use the lsnrctl start command to start the oracle listener. This command will start all the listeners. If you only want to start a specific listener, you can specify the listener name after start, for example, lsnrctl start [listener-name].

$ lsnrctl start   LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 04-APR-2009 16:27:42   Copyright (c) 1991, 2007, Oracle. All rights reserved.   Starting /u01/app/oracle/product/11.1.0/bin/tnslsnr: please wait…   TNSLSNR for Linux: Version 11.1.0.6.0 - Production   System parameter file is /u01/app/oracle/product/11.1.0/network/admin/listener.ora   Log messages written to /u01/app/oracle/diag/tnslsnr/devdb/listener/alert/log.xml   Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=1521)))   Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))   Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521)))   STATUS of the LISTENER   ————————   Alias                     LISTENER   Version                   TNSLSNR for Linux: Version 11.1.0.6.0 - Production   Start Date                04-APR-2009 16:27:42   Uptime                    0 days 0 hr. 0 min. 0 sec   Trace Level               off   Security                  ON: Local OS Authentication   SNMP                      OFF   Listener Parameter File   /u01/app/oracle/product/11.1.0/network/admin/listener.ora   Listener Log File         /u01/app/oracle/diag/tnslsnr/devdb/listener/alert/log.xml   Listening Endpoints Summary…   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=1521)))   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))   Services Summary…   Service “devdb” has 1 instance(s).   Instance “devdb”, status UNKNOWN, has 1 handler(s) for this service…   The command completed successfully $ lsnrctl startLSNRCTL for Linux: Version 11.1.0.6.0 - Production on 04-APR-2009 16:27:42Copyright (c) 1991, 2007, Oracle. All rights reserved.Starting /u01/app/oracle/product/11.1.0/bin/tnslsnr: please wait…TNSLSNR for Linux: Version 11.1.0.6.0 - ProductionSystem parameter file is /u01/app/oracle/product/11.1.0/network/admin/listener.oraLog messages written to /u01/app/oracle/diag/tnslsnr/devdb/listener/alert/log.xmlListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=1521)))Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521)))STATUS of the LISTENER————————Alias                     LISTENERVersion                   TNSLSNR for Linux: Version 11.1.0.6.0 - ProductionStart Date                04-APR-2009 16:27:42Uptime                    0 days 0 hr. 0 min. 0 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /u01/app/oracle/product/11.1.0/network/admin/listener.oraListener Log File         /u01/app/oracle/diag/tnslsnr/devdb/listener/alert/log.xmlListening Endpoints Summary…(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))Services Summary…Service “devdb” has 1 instance(s).Instance “devdb”, status UNKNOWN, has 1 handler(s) for this service…The command completed successfully

 

3. close the oracle listener if the oracle listener is running, you can use the lsnrctl stop command to close the oracle listener. This command will disable all listeners. If you only want to disable a specific listener, you can specify the name of the listener after stopping, for example, lsnrctl stop [listener-name].

$ lsnrctl stop   LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 04-APR-2009 16:27:37   Copyright (c) 1991, 2007, Oracle. All rights reserved.   Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521)))   The command completed successfully $ lsnrctl stopLSNRCTL for Linux: Version 11.1.0.6.0 - Production on 04-APR-2009 16:27:37Copyright (c) 1991, 2007, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521)))The command completed successfully

 

4. Restart the oracle listener and use lsnrctl reload to restart the listener. This command can replace lsnrctl stop and lsnrctl start. The listener. ora configuration will be read when you do not need to close or start the listener.

$ lsnrctl reload   LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 04-APR-2009 17:03:31   Copyright (c) 1991, 2007, Oracle. All rights reserved.   Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521)))   The command completed successfully $ lsnrctl reloadLSNRCTL for Linux: Version 11.1.0.6.0 - Production on 04-APR-2009 17:03:31Copyright (c) 1991, 2007, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=1521)))The command completed successfully

 

Oracle listener help 1. View All listener commands. The lsnrctl command can display all available listener commands. The output in oracle11g is as follows:

start - Start the Oracle listener stop - Stop the Oracle listener status - Display the current status of the Oracle listener services - Retrieve the listener services information version - Display the oracle listener version information reload - This will reload the oracle listener SID and parameter files. This is equivalent to lsnrctl stop and lsnrctl start. save_config - This will save the current settings to the listener.ora file and also take a backup of the listener.ora file before overwriting it. If there are no changes, it will display the message “No changes to save for LISTENER” trace - Enable the tracing at the listener level. The available options are ‘trace OFF’, ‘trace USER’, ‘trace ADMIN’ or ‘trace SUPPORT’ spawn - Spawns a new with the program with the spawn_alias mentioned in the listener.ora file change_password - Set the new password to the oracle listener (or) change the existing listener password. show - Display log files and other relevant listener information. $ lsnrctl help   LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 04-APR-2009 16:12:09   Copyright (c) 1991, 2007, Oracle. All rights reserved.   The following operations are available   An asterisk (*) denotes a modifier or extended command:   start               stop                status   services            version             reload   save_config         trace               spawn   change_password     quit                exit   set*                show* $ lsnrctl helpLSNRCTL for Linux: Version 11.1.0.6.0 - Production on 04-APR-2009 16:12:09Copyright (c) 1991, 2007, Oracle. All rights reserved.The following operations are availableAn asterisk (*) denotes a modifier or extended command:start               stop                statusservices            version             reloadsave_config         trace               spawnchange_password     quit                exitset*                show*

 

2. You can use lsnrctl help to obtain detailed help information for the specified listener command. As shown below

$ lsnrctl help show   LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 04-APR-2009 16:22:28   Copyright (c) 1991, 2007, Oracle. All rights reserved.   The following operations are available after show   An asterisk (*) denotes a modifier or extended command:   rawmode                     displaymode   rules                       trc_file   trc_directory               trc_level   log_file                    log_directory   log_status                  current_listener   inbound_connect_timeout     startup_waittime   snmp_visible                save_config_on_stop   dynamic_registration