Re: Listener problem on one client computer

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" <ORACLE-L_at_fatcity.com> 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: BranimirP_at_cpas.com
>
> 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: ListGuru_at_fatcity.com (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: damien_at_nethings.net

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: ListGuru_at_fatcity.com (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).