Oracle Express Edition (XE) database setup along with sqldeveloper and DBeaver in Windows

oracle_express_install

Skill - Oracle Express Edition (XE) database setup along with sqldeveloper and DBeaver in Windows

In this post we will install Oracle Express Edition (XE) database which is free and is meant for local and light weight database setup.

Oracle Express database is ideal for local development and testing without connecting to remote databases

Since Oracle Express database is free, there are some limitations

Only one CPU will be used even if the computer has multiple cores and CPUs
Maximum of 11 GB data storage is only supported, if you try to store more than that, the database will throw ORA-12592 error
Not more than 1 GB RAM will be used by the database
HTTPS is not supported

In a nutshell, don’t use it for production, use it only for testing and development purposes.

Detailed information about the limitations of Oracle Express database can be seen here

Download Oracle Express Edition (XE) database from https://www.oracle.com/in/database/technologies/xe-downloads.html or search for “download oracle express edition” if this link does not work
Download the relevant zip file by clicking on the link like " Oracle Database 21c Express Edition for Windows x64"

If the ORACLE_HOME environment variable has been set, delete it.
Download Oracle database zip file
Unzip the files
Run the setup.exe to install the database
During the setup set the database password
The official setup guide can be found here

run services.msc command to open the services window
Right click on the OracleServiceXE service and select stop or start to start or stop the oracle database

run services.msc command to open the services window
Right click on the OracleServiceXE service and select properties. Then select Startup type to “Manual” if you want the database to not start automatically on system start.

sqldeveloper is the database administration client tool by Oracle.
Download the tool as a zipped folder from here
Unzip the file to get the sqldeveloper folder. Inside the folder run the “sqldeveloper.exe” to start the sqldeveloper tool
Click the Create Connection button on the top-left and fill the connection settings as shown in the below image
* You can click the “Test” button to check if the settings are correct. Finally click the “Connect” button.

DBeaver community edition is a free universal database management tool that supports many databases including Oracle
Download DBeaver from here
Check my post on DBeaver setup here
For connecting to Oracle database, click new connection button at the top-left, select the database as Oracle and fill up the connection settings as shown in the image below.
* You can click the “Test Connection” button to check if the settings are correct. Finally click the “Finish” button.

You can see the video on this post here are here