How to Install Oracle Database 23ai on Windows 11

In this article, we will install Oracle Database 23ai on Windows 11. Oracle Database is a powerful database that has so many features. In the previous article, we’ve learned how to install Oracle Database on Oracle Linux 9. Oracle Database 23ai introduces advanced AI capabilities, enhancing performance and scalability for modern applications. Installing this database on Windows 11 is straightforward.

Prerequisites

Before beginning, ensure you have:

Operating System: Windows 11 (64-bit)
Memory (RAM): Minimum 2 GB; 4 GB or more recommended
Storage: At least 10 GB of free disk space
Privileges: Administrator rights on the system

Step 1. Install Java JDK

Oracle Database requires Java to run properly. Please install Java JDK prior to the Oracle Database installation. Download the latest version of Java for Windows from the link below.

https://www.oracle.com/java/technologies/downloads/#java8-windows

Once installed, open Command Prompt and run this command

java --version

Make sure it returns the Java version installed on your system such as:

In most cases, we need to edit JAVA_HOME environment. You can Googling how to edit the Java home environment on Windows 11.

Step 2: Download Oracle Database 23ai

Visit the Oracle Database 23ai Downloads page.
Choose the Windows version suitable for your system.
Sign in with your Oracle account or create a new one to proceed with the download.

Step 3: Extract the Installation Files

Once downloaded, navigate to the location of the ZIP file.
Right-click the ZIP file and select Extract All.
Choose a destination folder and click Extract.

Step 4: Initiate the Installation

Open the extracted folder.
Locate and double-click setup.exe.

Follow the installation wizard

By default, the Oracle Database 23ai will be installed to C:\app\your-username\product\23ai. You can change this location but in this example, I will leave it as is.

Make sure the installation completed without any errors.

Step 5. Verify the Installation

Now let’s check if Oracle Database 23ai installed correctly. Open Command Prompt and login to Oracle

sqplus / as sysdba

If you see the following prompt, then Oracle Database is installed correctly

Step 6. Enable Remote Connection

By default, Oracle Database only accessible from the localhost. If you are planning to access the database remotely, we need to edit the listener.ora file.

Below is the original content of the file listener.ora. Note the WIN11-TEST host. This is my hostname and in your file, this will be written as your host name. We need to change this part.

# listener.ora Network Configuration File: C:\app\dhani\product\23ai\dbhomeFree\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

DEFAULT_SERVICE_LISTENER = FREE

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = WIN11-TEST)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

Change the host value to 0.0.0.0

# listener.ora Network Configuration File: C:\app\dhani\product\23ai\dbhomeFree\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

DEFAULT_SERVICE_LISTENER = FREE

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

Now restart the listener service. Open Command Prompt as Administrator and then use this two commands to restart

lsnrctl stop
lsnrctl start

Configure Firewall

Now we need to configure the Firewall to allow incoming connection to port 1521. Open Windows Defender Firewall with Advanced Security and then click Inbound Rules. Click New Rule, select Port and type 1521 on the specific local ports.

Click Next and choose Allow the connection.

At this point, we have successfully installed Oracle Database 23ai on Windows 11. I hope this will be useful for you who wants to learn Oracle Database. See you next time.