OracleBrains.Com header image 2

Starting Listener on a different port

January 1st, 2007 by Rajender Singh · No Comments

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.


Tags: Oracle Administration · Oracle Database

0 responses so far ↓

  • There are no comments yet...Kick things off by filling out the form below.

Leave a Comment