Re: Newbie question on how to change Oracle 9i listener port number

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 14 Apr 2004 18:58:52 +1000
Message-ID: <407cfd4f$0$16965$afc38c87@news.optusnet.com.au>

Don wrote:

> Hi,
>
> I have installed oracle 9i on both Windows and AIX environment with
> default listener port number ( 1521 ). Just wonder if it is possible
> to change the port number. ( I've tried to change the listener.ora
> port number, restart listener, and server, and it is still using the
> default number)
>
> Thanks

Er, well then you edited the wrong listener.ora, because it's only the contents of the listener.ora (in %ORACLE_HOME%\network\admin by default) that tells the listener.ora which port to listen on. On Windows, I would stop the service and re-start it.

Regards
HJR Received on Wed Apr 14 2004 - 03:58:52 CDT