Re: orace10G XE WindowsXp and Zonealarm Pro

On 8 Jan 2007 12:43:22 -0800, "Charles Hooper" <hooperc2000_at_yahoo.com> wrote:

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

Hi Charles.
Thanks for your reply.
Everything is running on the same machine, so the loopback ( being equal to localhost) is in the trusted zone. Unfortunately trying to logon using the database home page just results in it returning to the database home page without presenting me with an error. The only indication I get is from ZoneAlarm telling me that Cookies where denied. That's how I found I had to change the standard setting I have for ZoneAlarm to allowing everything ( See above in cookies etc). To me this sound absurd since those settings are there for the Internet and NOT for the trusted zone.

To test something I went out on a limb and gave all oracle related programs I could find in the program tab all rights possible (access and server in trusted and internet). Rebooted and tried again. No difference.

Robert A. Reissaus Received on Mon Jan 08 2007 - 19:40:42 CST