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 Net8 listener only reads listener.ora
at startup. This process of stopping and immediately restarting the listener is commonly referred to as bouncing
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 NT 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 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.
service handler: A Net8 related entity that runs in conjunction with the listener to handle connection requests for a database instance.
Click the Exercise link below, and do the exercise to stop and restart your listener in order for your addition of the
instance to take effect.
Bouncing Listener - Exercise
After you have completed the exercise, click the Quiz link below to test your knowledge of the material you have learned so far.
Net Listener Bounce - Quiz