RE: Listener problem on one client computer

> -----Original Message-----
> From: Damien [mailto:damien_at_nethings.net]
> Sent: September 2, 2003 4:09 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 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.
>

Do the netstat on your Win2K database server to see if TCP port 1521 is listed in LISTENIG category.

Also confirm that there is and/or there is not DMZ (with firewall) between your web server and your database server. Usually DBAs are unaware od and/or are out of "loop" with these matters, and normally people in charge of these firey beasts are normally unaware of and/or uncaring for the dynamic nature of Oracle's TNS listener process...

tnsping is a friend too. Try it out from any client (unit with Oracle Client software) on the same network segment where the database is. Then move a "step" away (to the next segment to verify that routing does indeed route TNS packets properly).

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).