Today when checking “Search Keyphrases” for my site, I found out that someone wants to know about “starting tns listener on a different port”. So I though why not write about it so that in future it will be helpful to others.
I will not go in detail about physical file location (listener.ora) and will assume that the person already have such knowledge.
In Oracle the listener has a default name of LISTENER and is configured to listen on the following default protocol addresses as follows:
(address=(protocol=tcp)(host=host_name)(port=1521))
Clients configured with these addresses can connect to the listener on a given port.
By default it listen at port 1521, but can be changed to any other available port.
To change it simply we can edit this file called listener.ora
Example:
(address=(protocol=tcp)(host=host_name)(port=1421))
and then restart the listner through LSNRCTL utility as follows:
Anytime the listener.ora is modified, the listener must be stopped and re-started with the LSNRCTL utility.
To start or stop the listener:
Go to Command Prompt and TYPE LSNRCTL
To stop the listener
LSNRCTL> stop [listener_name]
To start the listener
LSNRCTL> start [listener_name]
WHERE listener_name is the name of the listener defined in the listener.ora file. It is not necessary to identify the listener if you are using the default listener, named LISTENER.
0 responses so far ↓
There are no comments yet...Kick things off by filling out the form below.
Leave a Comment