I have to do netstat -a on the webserver or on the Oracle server? Listener.ora is on the oracle server or on the webserver?
I don't have any access on the oracle server and nobody can help on this side. Best regards, Damien ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, September 02, 2003 9:14 PM > > > The ports are the same, I've checked the tnsnames.ora files > > and copied & > > pasted the content of the box who work on the web server. > > Still same prob. > > > > How can I check if i can open the port? It's a Win2000 server. > > > > > > To see if your Win2K server listens on port 1521 open MSDOS 'box' > and type: > > C:\>netstat -n > > Among (many) other things you should see something of this sort: > > Active Connections > > Proto Local Address Foreign Address State > TCP 192.168.200.38:1031 192.168.200.38:1521 ESTABLISHED > TCP 192.168.200.38:1521 192.168.200.38:1031 ESTABLISHED > > You could also check contents of LISTENER.ORA file as it should list > host name, protocol and listening port. > > You've mentioned that your problem is inability to acces database > from the web server. Normally web server should be sitting in > "insulated" DMZ environmemt, and there *should* be a firewall betweeen > database and your web server. May be that's the part you are not aware > of and/or not under your control, or it might happen that somebody > changed firewall rules leaving your SQL*Net sessions on "dry". > > If you do have DMZ, you should either have "SQL*Net aware" firewall or > you could force Oracle to use static port (look for Metalink Note: > 66382.1) as normally SQL*Net ports are dynamically negotiated, and > only initial connection negotiation starts on port 1521. > > Branimir > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Branimir Petrovic > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Damien INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
