Whenever you make a change to your listener.ora file, you need to stop and restart the listener in order for that change to take effect.
This is because the Oracle Net listener only reads listener.ora at startup.
This process of stopping and immediately restarting the listener is commonly referred to as
bouncing the listener.
The process for bouncing the listener is simple:
- Start listener control
- Issue a stop command
- Issue a start command
Try the following simulation for this process:
bouncing Oracle Listener
This simulation used the listener control program from a DOS prompt.
On an Windows machine, you also have the option of stopping and starting the listener from the Services control panel.
This demonstratoin used
lsnrctl because it is a universal approach that works on any Oracle installation, including those on Unix.
In the output from restarting the listener, the key item to look for is the
service handler[1] for the COIN instance. This tells you that the listener is now monitoring the network for incoming connection requests for that instance. You will find an example of this in the exercise below, under the section titled
Services Summary.