Today I finally found the problem. The traceroute shows the good route, but a Ms Proxy Client installed on the server blocked the request apparently. Just disabling it resolve everything.
Damien
Damien wrote:
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 Babilon 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).
