Forum Stats

  • 3,876,237 Users
  • 2,267,082 Discussions
  • 7,912,477 Comments

Discussions

Windows 10 Defender firewall question

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.

How do I add the above entry to my firewall?

Best Answers

  • User_KC6Y3
    User_KC6Y3 Member Posts: 73 Green Ribbon
    Answer ✓

    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:


    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.

  • cormaco
    cormaco Member Posts: 2,049 Silver Crown
    edited Apr 16, 2021 7:39AM 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:


  • User_KC6Y3
    User_KC6Y3 Member Posts: 73 Green Ribbon
    Answer ✓

    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

Answers

  • Billy Verreynne
    Billy Verreynne Software Engineer Member Posts: 28,951 Red Diamond

    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:


  • User_KC6Y3
    User_KC6Y3 Member Posts: 73 Green Ribbon
    Answer ✓

    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:


    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
    Billy Verreynne Software Engineer Member Posts: 28,951 Red Diamond

    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
    cormaco Member Posts: 2,049 Silver Crown
    edited Apr 16, 2021 7:39AM 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:


  • User_KC6Y3
    User_KC6Y3 Member Posts: 73 Green Ribbon
    Answer ✓

    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