Damien Your gesture is appreciated. It is a must that such solutions are shared with the list members.
GovindanK > Thank you very mutch for your replys, > > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK 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).
