Quantcast
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

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word

Comment moderation is enabled. Your comment may take some time to appear.