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

I imagine that you are talking about the GUI - called Application Express. I'd expect from what you have described that the command line utility sqlplus would work just fine.

I somewhat disagree with your "rather obvious" settings. Application Express definitely uses cookies and javascript - I don't know what "private header information" is but it might well use that as well. It also uses or can use svg graphics if these count under 'animation'. You might well be reasonable in restricting these items from the web (personally I think you'd be being over-paranoid but that's just opinion) but I fail entirely to see why you would block the effective operation of web applications that you had setup on your own network.

I'd suggest either trusting the web interface, or else using the command line.

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info/services