Re: windows 2003 srv r2 sp2 and oracle 10g

On Jan 7, 1:17 pm, Phil Davidson <P..._at_PhilDavidson.com> wrote:
> (Hello again, Mr. Hooper! You answered my question last Feb. 2007 about
> how to find out Oracle round trips. The subject was "How to count round
> trips from ADO via OraOLEDB to Oracle?")
>
> Is there a way to find out which HTTP port is currently in use by the
> database control? The install/portlist.ini file lists the ports
> established at install time, but one of my ports isn't working anymore.
> The "status" option on the emctl program doesn't report ports. The
> displayConfig option on emca seems to apply only to clusters, but I'm
> not using any clusters.
>
> More to the point, how can I find out why the HTTP port used by Oracle
> Enterprise Manager Database Control is no longer working for one of the
> databases on this server?
>

On the Windows platform, open a command prompt and type:  netstat -a -o >c:\ports.txt

The above will generate a list of all ports, including the listening ports (State will show Listening); open the file in Notepad. The Windows PID will also be listed, which is the process ID that is listening on the port. In the Task Manager, edit the columns displayed to include the PID, so that you can determine the name of the process that opened the port and is listening on that port. On my system, the Enterprise Manager Database Control process name is listed as Java, and most seem to have a port in the range of 5500 and above, although ports in and around 1158 may also be used.

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Mon Jan 07 2008 - 13:09:19 CST