Re: Break out instances to different ports

On Wed, 04 Apr 2007 15:37:13 -0700, fitzjarrell_at_cox.net wrote:

> You need two named listeners in addition to your default listener to
> accomplish this, such as listener_test and listener_dev, on separate
> ports. Then change your tnsnames.ora to reflect the new port
> assignments. Then, start your additional listeners, connect to TEST and
> DEV and issue an 'alter system register;' to have your new listeners
> recognize them

Even that is not necessary. Newer versions have a parameter "local listener" (introduced in 9i) which is the default listener that instance registers with. If parameter local_listener is not defined, instance will try connecting to the listener on the port 1521.

-- 
http://www.mladen-gogala.com