Stop the Oracle listener (Windows systems)

The listener service can be shut down either from the Services dialog window in the Windows Control Panel or manually from a command prompt. Note This example shows the shutdown of a listener service called LISTENER. More than one listener service can be run on a system and each listener should be defined in a configuration file called listener.ora. Control panel shutdown Log on to the operating system as a user with administrator privilege. In the Windows Services dialog box, select the service named Oraclehome-nameTNSListener. Click Stop. Verify that the OracleTNSListener service has stopped running by checking the Windows Services dialog box for the following entry: Oraclehome-nameTNSListener startup-mode startup-mode is either Automatic or Manual. Click Close. Manual shutdown Log on to the operating system as a user with administrator privilege. To connect as internal (without a password), this account must be part of ORA_DBA Windows local group. Manually set the Oracle environment: Copy set ORACLE_HOME=Oracle-home-path set PATH=%PATH%;%ORACLE_HOME%\bin Stop the OracleTNSListener service: Copy %ORACLE_HOME%\bin\lsnrctl stop LISTENER Verify that the OracleTNSListener service has stopped running by checking the Windows Services dialog box for the following entry: Oraclehome-nameTNSListener startup-mode startup-mode is either Automatic or Manual.