Re: Oracle 9.2 tnslsnr uses port 8080 on XP

Hi Don

Had something similar recently and it turned out to be the instance settings for Oracle XML DB which were listening on this port. Check your dispatchers setting in v$parameter, if the XMLDB service is specified here then that is your problem.

If you don't want network XML DB access then set dispatchers to null and restart your listener and instance. I couldn't find a way to get ALTER SYSTEM to accept setting this back to nothing in the spfile (tried NULL, '' etc. but it wouldn't have it), so had to generate a pfile and edit that, then start the instance from the pfile and recreate an spfile.

If you do want to keep XML DB but want it on a different port then look at using the xdb_utility database package to change (this setting is in the database and not in a config file I believe).

KJP Don wrote:
> How do I disable the TNS Listener from using port 8080 under Windows
> XP. I have read other posts, but they refer to Unix and/or the
> init.ora (not used in rel 9.2)
>
> thanks
>
> Don
Received on Mon Oct 06 2003 - 21:59:21 CDT