Re: 10G XE login on Windows and ZoneAlarm Pro

On Mon, 8 Jan 2007 22:33:30 +0000, Jim Smith <usenet_at_ponder-stibbons.com> wrote:

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

Hi Jim.
Thanks for your reply.

About the 'None of these are relevent to connecting to XE'.

That's what I thought, but I CAN logon using the database home page ONLY if I remove any restrictions on ZoneAlarm as far as cookies, web bugs, private headers, adverts, animations, popup/under and any kind of script. Keeping any one (1) of them in place prevents logon ( In that the home page simply returns to iself).

Now, XE runs on the loopback ( 127.0.0.1) which is in the trusted zone and shouldn't have any problem at all. I haven't changed any setting so all has it's default installation setting.

I am indeed talking about the database home page. As a beginner using Oracle I would obviously try that road and learn to walk first before I try to fly. I haven't tried a connection thru cmd line, wouldn't know how. And it would of course defeat the purpose of the XE gui at all wouldn't it? it's more or less for individuals like me XE is here.

I have added a expert rule to ZoneAlarm opening up any and every port to loopback, but to no avail.

The host being localhost ( 127.0.0.1) is in the trusted zone. Adding the host itself ( under it host name) to the trusted zone doesn't change a thing.

Robert A. Reissaus Received on Mon Jan 08 2007 - 19:20:05 CST