Re: orace10G XE WindowsXp and Zonealarm Pro

Robert A. Reissaus wrote:
> Hi guys.
> I have installed a oracle10 Express Edition on my Windowsxp. On the
> system I am running ZoneAlarm Pro with rather obvious adjusted privacy
> settings as follows:
> 3rd party cookies are blocked.
> private header information is disabled.
> popup/under ads are blocked
> animations are blocked
> script execution is blocked ( vbscript etc).
>
> As a result I can NOT logon to the database using SYSTEM ( or any
> other user for that matter).
>
> The ONLY i can log in is to remove ANY initial blockage in my
> firewall. This is of course totally unacceptable. Now I have tried to
> tweak the firewall settings in such a way that ports used by oracle
> are allowed, but that doesn't work. It *looks* like oracle circumvents
> the firewall entirely.
>
> Anybody any idea?
> Robert A. Reissaus

It has been several years since I experimented with Zone Alarm. Is there a log file generated by Zone Alarm that shows the port connections that it is actively blocking? Is your version of Zone Alarm able to grant or deny network access to specific applications - you may have unintentionally specified that Zone Alarm should not permit network/Internet access by Oracle.

You may need to expressly permit access to the listener, which may be listening on port 1521. You may need to competely open that port number, as well as allowing all traffic from that port number (TCP traffic). Also, you may need to permit all traffic on the loopback address (127.0.0.1).

As mentioned by Sybrand, specific Oracle error messages when attempting to connect are helpful, as they may help determine which firewall setting must be adjusted.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Mon Jan 08 2007 - 14:43:22 CST