Oracle Database 18c, often simply called Oracle for short, is one of the three most popular enterprise-class DBMS packages. This topic is the second step in a four topic sequence showing a complete installation and then utilization of Oracle 18c XE from the very beginning. Please see the Install Oracle topic for basic info on Oracle XE.
Disclaimer: These topics were accurate when written, using the versions of installation software indicated. Third party packages can and do change, so this topic may be out-of-date. It is provided as an example of how such installations can be approached.
Installing Oracle XE and readying it for use in typical installations involves four steps:
Open a Firewall Port for Oracle
Connect to Oracle
This is the second topic in the above sequence of steps.
In this topic, we are using a 64-bit Windows 10 system to which we have connected via Remote Desktop (RDP). This entire topic was conducted on that machine via RDP.
If we have Manifold installed on the same computer on which we install Oracle, and if we will always use our Oracle installation from the same computer, we can skip this step. For example, if we are an individual user with only one computer and we do everything on that one computer, we can always connect to Oracle from Manifold using a localhost designation, that is, not going through any network.
We only need to do this procedure if we want to access this Oracle installation through the network from other computers. For example, if we work in an organization with several computers and one of them hosts this Oracle installation but we actually do our Manifold work on a different computer, to connect from our desktop computer to the machine hosting Oracle we have to be able to connect to it through the web.
Microsoft's Windows Defender Firewall will prevent connections through the network to Oracle, so we must first configure the firewall to allow connections to Oracle via TCP/IP to the port used by Oracle. That is easy to do.
We will allow connections through port 1521, the default port for Oracle. We can use a similar procedure to open a port through the firewall for any other database, such as PostgreSQL or SQL Server, for which we might want to allow connections through the Windows firewall.
Launch Windows Control Pane, the full version. That is easiest to do by entering Windows Control Pane in the Windows taskbar search box for launching commands.
Choose Windows Defender Firewall. When the app launches, click on Advanced Settings in the left hand stack of choices.
Click on Inbound Rules. in the left hand pane. The illustration above appears. Click on New Rule.
Choose Port and click Next.
Enter 1521 and click Next. That is the default port for Oracle.
Choose Allow the connection and click Next.
Leave all check boxes checked. Click Next.
Enter Oracle, or some other suitably descriptive name which will remind us what this rule does, and click Finish.
Done. We can now close the dialogs by clicking the X buttons in the upper right corners.
We have opened a firewall port to stop Windows from blocking access to Oracle from the network. Next, we will configure our Oracle installation.
Continue this case study on installing Oracle with the Configure Oracle topic.
Jump to the beginning of the case study: Install Oracle
DBMS Data Sources - Notes
File - Create - New Data Source
Real and Virtual Components
Install SQL Server
Connect to Oracle
Big List of Formats and Data Sources
Example: Switching between Manifold and Native Query Engines