Re: Net8 tcp listener reconfigures to Random port after 45 seconds

You are running into configuration issues with the listener. By default in 8i, the listener requires no listener.ora config file to tell it where to listen (ip address, port). Instead, the instance dynamically registers itself with the listener process and regularly (about every minute) updates the listener with a status. Dynamic registration uses parameters in the init.ora like service_name (and any MTS (multi-threaded server) parameters). From your listener output, it is obvious you have MTS enabled in your init.ora. That is why you get the registration on the "random port". This will be the primary connection point for clients (unless you force a "dedicated" connection via the tnsnames.ora file on your client).

Short answer is, if you want to use port 1521 and dedicated server connections, disable all the mts parameters in you init.ora (and remove your listener.ora file) and restart your instance.

If you want to use special ports, different service names, etc., you must configure listener.ora and init.ora. In the init.ora you will need to set local_listener parameter to use non-default listener configs. This takes some playing around and testing as it is sometimes hard to "override" the dynamic registration. There are some good articles on metalink if you have access. Received on Thu Aug 02 2001 - 15:22:31 CDT