In message <kuq5q2ll2bm21nf0kbniihgtq91ij09f7e_at_4ax.com>, Robert A.
Reissaus <oracle10G_at_risdi.com> writes
>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
I'm out of ideas. You will probably get better advice on the XE forum on
OTN.
--
Jim Smith
Ponder Stibbons Limited <http://oracleandting.blogspot.com/>
RSS <http://oracleandting.blogspot.com/atom.xml>
Received on Tue Jan 09 2007 - 05:04:17 CST
