Re: 10G XE login on Windows and ZoneAlarm Pro

In message <fev4q2dnt39857kln11u40do9eb7ui073p_at_4ax.com>, Robert A. Reissaus <oracle10G_at_risdi.com> writes
>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).
>

None of these are relevant to connecting to XE.

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

Are you talking about using the XE gui (the "database home page") or connecting to the database directly?

The database home page uses 8080 (unless you changed it at installation). Direct connection to the database uses 1521 initially, but then hands off the connection to another thread using an arbitrary port number.

In either case, it should be possible to specify the local machine (either 127.0.0.1 or the real ip address) as a trusted host for the firewall. Any ports remain closed to anything other than the local machine.

-- 
Jim Smith
Ponder Stibbons Limited <http://oracleandting.blogspot.com/>
RSS <http://oracleandting.blogspot.com/atom.xml>