Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Windows 10 Defender firewall question

Murray SobolApr 15 2021

When I installed Oracle 18 XE on my Windows 10 laptop I did NOT get an opportunity to add entries to the firewall.
If you have the Windows Defender Firewall activated, you will be asked to allow network access to the Java Platform SE binary. Check the checkboxes to allow access to the networks of your choice and click the “Allow access” button. Note: If you do not allow network access for Java, some features of Oracle Database 18c XE might not work correctly.
Oracle Database 18c XE Windows FirewallHow do I add the above entry to my firewall?

This post has been answered by cormaco on Apr 16 2021
Jump to Answer

Comments

Billy Verreynne

Rules on an executable can be created. Select the java.exe executable and define the required access rules for it.
See https://docs.microsoft.com/en-us/windows/security/threat-protection/windows-firewall/best-practices-configuring for the basics - i.e. select PROGRAM for the rules:
image.png

Murray Sobol

Thanks Billy; I was pre-mature with my post. I found a similar link and added the missing Java entry.
This is the REAl issue I am trying to resolve:
I recently installed Oracle 18c Express Edition on my Windows 10x laptop.
When I tried to run DBCA I got this message:
image.png

When I researched this error one suggestion was to use a TRY/Catch block to trap this error; I shouldn't be trying to change DBCA.
My background is with Oracle 11g on Windows servers; I am researching a project to migrate databases to Oracle 19.
I would have preferred to install an Oracle 19 Express edition but apparently that does not exist.
My account with oracle is a "free" one so I don't have access to knowledge base articles.
I am curious - did something change between Oracle 11 and Oracle 18/19 with respect to language support.
Amy assistance would be appreciated.

I had issues with ORACLE_HOME not being set properly but I resolved that.
Now My Listener and other Oracle services start properly.
Remaining problem is with DBCA.

Billy Verreynne

Sorry, last used Oracle on Windows NT back with Oracle 7 - and Linux troubleshooting does not work on Windows. Knee jerk reaction is that your Windows o/s is not fully certified for Oracle, or there is some kind of config stuffup in the Registry.
As for version changes, there are release notes for each new Oracle version that list changes and new features and options.

cormaco
Answer

Does it have to be Windows installation?
If not you can use this VirtualBox appliance to get a running Oracle 19.3 EE database on Oracle Linux:
Developer Day - Hands-on Database Application Development (0 Bytes)

Marked as Answer by Murray Sobol · Apr 28 2021
Murray Sobol

Billy: I checked the supported OS's for Oracle 18c XE; my platform IS supported.
Cormaco: Yes, it needs to be a Windows installation.
Also, my potential client does not work with LINUX and is unwilling to spend the extra money for Oracle 19.x EE
Murray

1 - 5

Post Details

Added on Apr 15 2021
5 comments
3,791 views