In this article we will show you how to install Oracle Spatial Studio on Windows Server 2022. Oracle Spatial Studio is a powerful, web-based application that enables users—both technical and non-technical—to visualize, explore, and analyze geospatial data stored in Oracle databases. It simplifies working with spatial data by providing an intuitive interface and rich mapping tools without the need for GIS software expertise.
Prerequisites
Before installing Spatial Studio, ensure your system meets the following requirements.
- Operating System: Windows Server 2016, 2019 or 2022
- Java Development Kit (JDK). You can download and install Java from this link.
- Oracle Database. Follow this guide to install Oracle Database 23ai on Windows system.
- Memory: Minimum 4GB and recommended 8 GB or more
Steps to Install Oracle Spatial Studio on Windows Server 2022
Step 1. Create a New User/Schema
In this step we will create a new User/Schema. And then, we grant some privileges to the new schema. Open Windows PowerShell and run sqlplus.
sqlplus sys as sysdba
#Output
SQL*Plus: Release 23.0.0.0.0 - Production on Tue Apr 8 05:04:35 2025
Version 23.7.0.25.01
Copyright (c) 1982, 2025, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.7.0.25.01
SQL> And then alter the container
SQL>alter session set container=freepdb1;Now create a new user
CREATE USER dhani IDENTIFIED BY "Oracle.2025"
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON USERS;Step 2. Grant Required Privileges
Now we need to grant some basic privileges to the new user
GRANT CONNECT, RESOURCE TO dhani;
GRANT CREATE VIEW TO dhani;
GRANT CREATE MATERIALIZED VIEW TO dhani;
GRANT UNLIMITED TABLESPACE TO dhani;Next, let’s grant some privileges required by Spatial Studio
GRANT EXECUTE ON MDSYS.SDO_GEOM_METADATA_TO_JSON TO dhani;
GRANT EXECUTE ON MDSYS.SDO_UTIL TO dhani;
GRANT SELECT ON ALL_SDO_GEOM_METADATA TO dhani;
GRANT SELECT ON ALL_SDO_INDEX_METADATA TO dhani;
GRANT SELECT ON DBA_ROLE_PRIVS TO dhani;
GRANT SELECT ON DBA_USERS TO dhani;
GRANT SELECT ANY DICTIONARY TO dhani;
GRANT EXECUTE ON DBMS_LOCK TO dhani;Step 3. Download Oracle Spatial Studio
Please download the latest version of Oracle Spatial Studio and extract it to a folder, for example C:\Oracle\Oracle_Spatial_Studio
Now double-click the start.bat file inside the Oracle_Spatial_Studio folder to start the Oracle Spatial Studio.
Step 4. Configure Firewall
We need to configure the Windows firewall to allow connection through port 4040. Open Windows Firewall settings and allow port 4040.
Step 5. Configure Spatial Studio via Web
Open a web browser and type the server IP address with the following format:
https://your-ip-address:4040/spatialstudio
The default user is: admin and the default password is welcome1.
Now enjoy Oracle Spatial Studio.